Andreas Pflug pgadmin
Wed Jan 18 08:46:33 PST 2006
Darcy Buskermolen wrote:
> On Wednesday 18 January 2006 05:00, Aaron Randall wrote:
> 
>>Hi Everyone :)
>>
>>I have a question similar to one that was raised a little while ago titled
>>- "How do I know when a subscriber has caught up?".
>>
>>Is there a flag somewhere that confirms that the master and slave are
>>connected (regardless of whether they are currently transmitting data) to
>>show that Slony is running successfully on both.  At the moment, the only
>>was I can check is by tailing the Slony logs, but ideally I would like to
>>use some kind of database field that could confirm/deny the master and
>>slave(s) are connected successfully.
> 
> 
> The _custername.sl_status view can be used for this purpose.

pgAdmin displays this too in the node statistics.

Regards,
Andreas



More information about the Slony1-general mailing list