marmu mu at forsa.de
Fri Aug 19 08:59:26 PDT 2011
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.



More information about the Slony1-general mailing list