Slony1 PostgreSQL Replication - 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

Aaron Randall

2006-01-19, 7:24 am

Thanks to everyone for their replies.

Where can I get "test_slony_state.pl" from?

Thanks

Aaron Randall
VisionOSS Ltd.
Providing excellence in OSS architecture and solutions consultancy
Email: aaron.randall- LJ+G6BnwIY2akBO8gow8
eQ@public.gmane.org
Mobile: +44 (0)7742 432165

Christopher Browne wrote:
> Aaron Randall <aaron.randall- LJ+G6BnwIY2akBO8gow8
eQ@public.gmane.org> writes:
>
>
> Well, you can get some implicit "all is running well" if you run
> select * from _cluster.sl_status;
>
> If it shows all the nodes you expect, and shows that they are only an
> event or two behind, then replication should be functioning well.
>
> That's about the best metric I can think of without looking at the
> logs.
>
> You could also run the script test_slony_state.pl (or the DBI
> version); that checks a number of things about how things are running.
>

Sponsored Links