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
>>> Slony1-general at lists.slony.info
>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>>
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>
>>
>