Fri Aug 19 08:59:26 PDT 2011
- Previous message: [Slony1-general] "fetch 500 from LOG" consuming a lot of CPU
- Next message: [Slony1-general] no subscriber listed in pgAdmin, how to check if slony is set up correctly?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello guys, my slony setup is progressing. First what is working: 1) I can start my slony master and slave slons (on one machine, goal: some tables of master-DB should be replicated to the slave-DB) 2) no erros in the logs 3) runnnig "perl test_slony_state-dbi.pl -d catimaster -h localhost -u postgres -c fquest" says "all good" 4) runnnig "perl test_slony_state-dbi.pl -d fquest -h localhost -u postgres -c fquest" says "all good" But I still can't figure out some things: 1) why isn't there any subscription listed in pgAdmin (on another server there are 2 subscriptions, one on the master-DB and one on the slave-DB) Any hints to why subscriptions are not listed / set up correctly? 2) how can I test if slony is set up correctly? I guess I should insert something and check if the data is replicated. Any other possibilities? The scripts I am using are at pastebin: /etc/slony-I/setup-slonik_master: http://pastebin.com/rZ2r9hnS /etc/slony-I/setup-slon_master: http://pastebin.com/G4PHctat /etc/slony-I/setup-slonik_slave: http://pastebin.com/gyBj349Z /etc/slony-I/setup-slon_slave: http://pastebin.com/F5xY0GfR The slave script is already altered, I added: "subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);" I am struggling to set up the slony replication for weeks. Thanks a lot for your help in advance. Cheers, Marcus -- View this message in context: http://old.nabble.com/no-subscriber-listed-in-pgAdmin%2C-how-to-check-if-slony-is-set-up-correctly--tp32296496p32296496.html Sent from the Slony-I -- General mailing list archive at Nabble.com.
- Previous message: [Slony1-general] "fetch 500 from LOG" consuming a lot of CPU
- Next message: [Slony1-general] no subscriber listed in pgAdmin, how to check if slony is set up correctly?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list