[Bucardo-general] lack of documentation: how the heck do things work?
Ed Snajder
ed.snajder at jivesoftware.com
Wed Apr 18 17:44:37 UTC 2012
I have found that there are some gaps between the v4 operation and v5 syntax. Some of the gaps are quite subtle, and tricky. I have been building up and tearing down some replicated systems recently, and plan to pull my notes together to update the documentation a little bit.
The one that really challenged me was adding tables that did not have primary keys. With the removal of the 'type' option, I would get errors on tables that had primary keys. After a little digging into the code a bit, I found that you could identify a database's role in the dbgroup creation, as in
bucardo add dbgroup mydbgroup db1:source db2:fullcopy
as opposed to a group with PKs:
bucardo add dbgroup mydbgroup db1:source db2:target
As I am uncovering things, I am finding that they are more the way I want them to work, the documentation just has not caught up yet.
In the errors below, i did the same thing a lot where I did not name the objects I was creating:
bucardo add herd db=mydb dbhost=localhost dbport=1234
instead of
bucardo add herd MYNEWHERD db=mydb dbhost=localhost dbport=1234
I bet I still do it one out of every 5 new objects ;)
Also, in the package there is a bucardo.html file that has some different options. It also has some inconsistencies, but between bucardo help, bucardo.html I think most of the answers are there.
Ed
________________________________________
From: bucardo-general-bounces at bucardo.org [bucardo-general-bounces at bucardo.org] on behalf of Christian Recktenwald [bucardo-contact at lihas.de]
Sent: Wednesday, April 18, 2012 12:16 PM
To: bucardo-general at bucardo.org
Subject: [Bucardo-general] lack of documentation: how the heck do things work?
Hi Folks,
I've been running against walls fuer several days now.
Every single step I have to repeat five or ten times,
because the documentation is completely unsufficient
because it's highly inspecific.
So all I can see are errors over errors.
An example:
My postgres 9.1.3 database is named "repltest".
There's a user "repltest" and a password "repltest".
Replication target would be test/test2/test2
Bucardo is 4.99.3 .
bucardo help add db
->
Usage: add db <name> [optional information]
Adds a database
Optional information:
type=type of database (defaults to postgres. Others: drizzle,mongo,mysql,oracle,redis,sqlite)
db=name (database name to connect to)
...
trial:
bucardo add db repltest
->
Cannot add database: must supply a database name to connect to
trial:
bucardo add db db=repltest
->
Cannot add database: must supply a database name to connect to
what is this?
ok, maybe I need two db names: the sql-databasee and the bucrado ab alias.
which is which? dunno...
trial:
bucardo add db repltest db=buc_repltest
->
Connection test failed. You may force add it with the --force argument.
other way round:
bucardo add db buc_repltest db=repltest
->
Added database "buc_repltest"
Nice, got that one
now, I intended to add all tables inside repltest.
one step back:
bucardo delete db buc_repltest
->
Removed database "buc_repltest"
now the right one:
bucardo add db buc_repltest db=repltest addalltables
->
Sorry, could not find a database named "repltest"
The following databases are available:
buc_repltest
And so on and so on. A constant pain in the ass.
So: what could be done about this? Am I the only one
experiencing things that way?
--
LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart
Fon: +49 (7 11) 78 28 50 90 - Fax: +49 (7 11) 78 28 50 91
Mail: lihas at lihas.de - Web: http://lihas.de
Linux, Netzwerke, Consulting & Support - USt-ID: DE 227 816 626 Stuttgart
_______________________________________________
Bucardo-general mailing list
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
More information about the Bucardo-general
mailing list