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

Reply via email to