[Bucardo-general] Replication failed in a Master-Slave config

[Hadri Rahman]

Thanks for you reply.

I've tried what you suggested, and the results are:

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.


On Wed, Dec 10, 2014 at 5:46 PM, Irfin A [GMail] <foo.bazz at gmail.com> wrote:

> Bucardo store its data in its own schema named bucardo. So to see that
> schema you need to type \dn in psql shell, or you can simply use pgAdmin
> for GUI.
>
> A simpe test to see whether the replication working is to try to
> insert/update/delete a record in a synced table on master side, and see
> if the change also happens on slave side.
>
> Also you can try to see the output of 'bucardo_ctl status' command, right
> before and after you make record changes on master side.
>
> On Wednesday, December 10, 2014, Hadri Rahman <hadri90 at gmail.com> wrote:
>
>> When I tried to perform replication in Bucardo from the master side,
>> whenever I add a sync and type "bucardo start" it will run in the
>> background. However, when I tried to look at the results at the slave side,
>> it appears that the replication was unsuccessful.
>>
>> For example; when I look at the database contents in the master side, I
>> would get something like this:
>>
>> postgres=# \dt
>>               List of relations
>> Schema | Name    | Type       | Owner
>> ----------------------------------------------------------
>> public    | testing   | table       | postgres
>>
>> The slave side, on the other hand, would produce something like this:
>>
>> postgres=# \dt
>>               List of relations
>> Schema | Name    | Type       | Owner
>> ----------------------------------------------------------
>> public    | rep_test  | table       | postgres
>>
>> Does anyone have any suggestions on anything I might have gotten wrong?
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141211/7a1a7a2c/attachment-0001.html>