Hi, I am trying to get slony to replicate a single table from an existing database.
My initial test is using a backup of that table in a separate database (different servers actually) I am able to run the pgbench example okay. When I use my own data, the master will start up fine, but the subscriber node always says: [EMAIL PROTECTED]:~/proj/slony]$ ./start_cdr_slave.sh 2006-11-29 14:35:02 MST CONFIG main: slon version 1.1.5 starting up 2006-11-29 14:35:02 MST CONFIG main: local node id = 1 2006-11-29 14:35:02 MST CONFIG main: launching sched_start_mainloop 2006-11-29 14:35:02 MST CONFIG main: loading current cluster configuration 2006-11-29 14:35:02 MST CONFIG storeSet: set_id=1 set_origin=1 set_comment='test cdr table' 2006-11-29 14:35:02 MST CONFIG main: configuration complete - starting threads 2006-11-29 14:35:02 MST DEBUG1 localListenThread: thread starts 2006-11-29 14:35:02 MST FATAL localListenThread: "select "_cdr01".cleanupNodelock(); insert into "_cdr01".sl_nodelock values ( 1, 0, "pg_catalog".pg_backend_pid()); " - ERROR: duplicate key violates unique constraint "sl_nodelock-pkey" 2006-11-29 14:35:02 MST DEBUG1 slon: shutdown requested [EMAIL PROTECTED]:~/proj/slony]$ I found some notes about the duplicate key error, but they talk about a 2nd slon process, which I am sure is not running. 1> What causes this when I create the the master and slave db's from scratch? 2> Is there a way to fix it in place - without dropping the replca and starting all over? Thanks for any help!! -- aloha, dave _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
