Home > Archive > Slony1 PostgreSQL Replication > January 2006 > Re: How do I know that the machines are connected









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: How do I know that the machines are connected
Darcy Buskermolen

2006-01-18, 11:24 am

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.


>
> Regards,
>
> Aaron
>
> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general


--
Darcy Buskermolen
Wavefire Technologies Corp.

http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com