Tue Nov 8 22:55:51 PST 2005
- Previous message: [Slony1-general] Slony1 1.1.2 does not compile on postgresql-8.1.0
- Next message: [Slony1-general] Circular replication problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I am trying to implement the following replication schema(s) _rep_schema1 HOST = office_cpu -> SLAVE=satellite_cpu DB = main_db -> DB =slave_db _rep_schema2 HOST = satellite_cpu -> SLAVE=office_cpu DB = slave_db -> DB =duplicate_db The intent is to have the slave replicate back all changes to main_db to the duplicate_db on the master. When I execute the script to implement this, it aborts with [postgres at slv postgres]$ ./slony_reverse.sh <stdin>:105: loading of file /usr/local/pgsql/share//xxid.v74.sql: PGRES_FATAL_ERROR ERROR: current transaction is aborted, commands ignored until end of transaction block ERROR: current transaction is aborted, commands ignored until end of transaction block Is there something about a slony slave_db that prevents it from being replicated to another database? I do note that _rep_schema2 is created properly on the 2nd HOST (satellite_cpu), but it is not created on the SLAVE (office_cpu). Does anyone have a short example script for this circular replication?
- Previous message: [Slony1-general] Slony1 1.1.2 does not compile on postgresql-8.1.0
- Next message: [Slony1-general] Circular replication problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list