Slony1 PostgreSQL Replication - SQL query for "acks outstanding"

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

SQL query for "acks outstanding"

Xavier Romero

2005-09-29, 11:24 am

I would like to monitor replication status, looking somewhere to get
something like "acks outstanding" shown in pgAdmin.
So my question is: whats the right SQL query to get that value ??

I know there are plugins for nagios etc, but i would like to use that
query to integrate on our own monitoring system.

Thank you,
Xavi.

Andreas Pflug

2005-09-29, 11:24 am

Xavier Romero wrote:
> I would like to monitor replication status, looking somewhere to get
> something like "acks outstanding" shown in pgAdmin.
> So my question is: whats the right SQL query to get that value ??

Enable SQL logging in pgAdmin and look at the log file to learn what the
query looks like.

Regards,
Andreas

Sponsored Links