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

[Irfin A [GMail]]

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/20141210/d3ae1934/attachment.html>