On Fri, 19 Aug 2011, marmu wrote: > 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?
Inserting data and waiting to see it replicated is the best way to be sure. You could also check the sl_status table to see what the lag is and confirm that events + confirmations are flowing. > > 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. > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
