[Bucardo-general] Replication failed in a master-slave setting
Hadri Rahman
hadri90 at gmail.com
Wed Dec 17 10:11:27 UTC 2014
Referring to my earlier issue where I was able to perform replication on a
master server, but the databases were not updated on the slave server. I
then tried to re-install Bucardo on the slave server but when I do that I
would get an error message saying:
INSTALLATION FAILED! (psql:bucardo:schema:45: ERROR: cannot execute CREATE
FUNCTION in a read-only transaction)
I then removed the recovery.conf file and installed it. But when I
performed replication in Bucardo, when I looked at the Bucardo status in
the slave server (although technically it isn't one anymore), Bucardo then
infromed "No syncs have been created yet."
I then added the recovery.conf file again, reverting the server to a slave
server, and when I invoked the status, I received an error message:
DBD::Pg::db do failed: ERROR: cannot execute LISTEN during recovery at
/usr/local/bin/bucardo line 307
I then went into psql and checked the contents of the database. In the
master server,
the command \dn gives this output:
postgres=#\dn
List of schemas
Name | Owner
bucardo | bucardo
public | postgres
test | postgres
testschema | postgres
And \dt gives the following relations:
Schema | Name | Type | Owner
----------------------------------------------------------
public | example | table | postgres
public | testing | table | postgres
While the slave side gave the following information
Name | Owner
public | postgres
and
Schema | Name | Type | Owner
----------------------------------------------------------
public | rep_test | table | postgres
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141217/c9344748/attachment.html>
More information about the Bucardo-general
mailing list