[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.


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)

        bucardo add db repltest
        Cannot add database: must supply a database name to connect to

        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...

        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:

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

More information about the Bucardo-general mailing list