I am trying to set up a simple 3 node rep schema.
Server A -> Slave 1-> Slave2
db1( tbl1) db1(tbl1) db1(tbl1)
I have no problem implementing Server A -> Slave 1, but when I
try with the 3rd node, (Slave 2), I get
[EMAIL PROTECTED] 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
Does anyone have a simple script demonstrating this with just one set
and 1 table?
This is supposed to be possible based on
http://redivi.com/~bob/oscon2005_pgsql_pdf/slony-talk.pdf
however, the only the concept is discussed, no script is given.
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general