Thanks for helping out. I figured all out and "updated" my earlier post above (on nabble) To sumk it up again:
select * FROM _databasename.sl_status; - works! I added the subscriptions with pgAdmin (my scripts didn't work) by right clicking on "subscriptions" and adding one. Then they both appeared under "slony replication" - replication startet immediately. I still don't know why the subscription didn't work with my scripts, but now it works and I am happy. Importing more data now :) Thanks again to everyone who helped my solving my slony issues! Cheers, Marcus Steve Singer-3 wrote: > > On 11-08-22 07:52 AM, marmu wrote: >> >> Hello guys, >> >> I am back at solving my slony problems. >> >>>> You could also check the sl_status table to see what the lag is and >> confirm >>>> that events + confirmations are flowing. >> >> Both of my databases do not contain a table called "sl_status": >> server:~> psql -d databasename >> databasename=# select * from sl_status; >> --> ERROR: relation "sl_status" does not exist >> >> Why is the sl_status table missing? What other slony tables should be >> there >> and where should they be located? Is every slony table to be found in any >> database which is set up for replication? >> Even on the old server, where slony works, I couldn't "select * from >> sl_status;"... >> > > A complete list of the slony tables are at > http://www.slony.info/documentation/2.0/schema.html > > You might have to specify the slony schema as part of the table name. > Try > select * FROM _fquest.sl_status; > > > >> further I am now using pgAdmin 1.14 RC1. But pgAdmin is not the problem, >> since it shows the subscriptions on the other slony-server, but not on >> the >> newly configured. Hence the problem is the slony configuration on the new >> server I'm working on. >> >> So the question remains. What went wrong during the slony setup, which >> causes no subscriptions to be made? How could I check for the configured >> subscriptions without using pgAdmin? >> >> Help is highly appreciated, since I am stuck for weeks now. Thanks for >> any >> hints. >> >> Have a great day, >> Marcus >> >> >> Steve Singer-2 wrote: >>> >>> 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 >>> >>> >> > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > > -- View this message in context: http://old.nabble.com/no-subscriber-listed-in-pgAdmin%2C-how-to-check-if-slony-is-set-up-correctly--tp32296496p32320482.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
