[Bucardo-general] Unable to perform replication in Bucardo in a Master-Slave setting

Hadri Rahman hadri90 at gmail.com
Mon Dec 15 02:03:03 UTC 2014


When I was trying to perform replication from Master to Server, the
replication was able to run on the Master server, but the table in the
slave database did not receive and apply the changes.

According to the Bucardo mailing list, to see the schema needed to perform
the sync, type the `/dn` command to show it.

On Master side, the command reveals this:

     postgres=#\dn
     List of schemas
     Name        |     Owner
     bucardo    |    bucardo
     public        |    postgres
     test        |    postgres
     testschema    |    postgres

On the Slave side, however:

     postgres=#\dn
     List of schemas
     Name        |     Owner
     public        |    postgres

Another suggestion is to insert data into the table at the master side, and
see if there are changes made on the slave side but there is no change.
And when running `bucardo status` on the master server, it shows this:

     PID of Bucardo MCP: 1852
     Name        State        Last Good    Time        Last I/D        Last
Bad

=========================================================================
     Example    Good        Dec 10, 2014    18h 37m 55s    0/0        none
                               16:10:19

But on the slave server the result is:

     DBI connect (‘dbname=bucardo’, ‘bucardo’,…) failed: fe_sendauth: no
password supplied at /usr/local/bin/bucardo line 296

I’ve tried removing the recovery.conf file in the slave server so that I
can install Bucardo and add the user Bucardo to the database but it failed
to do so.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141215/f15eaf96/attachment.html>


More information about the Bucardo-general mailing list