Fri Nov 11 22:02:21 PST 2005
- Previous message: [Slony1-general] unique constraint on sl_table-pkey
- Next message: [Slony1-general] Slony 3 node problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 [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 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.
- Previous message: [Slony1-general] unique constraint on sl_table-pkey
- Next message: [Slony1-general] Slony 3 node problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list