Re: [GENERAL] Detect streaming replication failure

2014-07-17 Thread wd
you can run select * from pg_stat_replication on master to check all the salve stats. On Fri, Jul 18, 2014 at 6:50 AM, Lists wrote: > For reference: > https://wiki.postgresql.org/wiki/Streaming_Replication > > Assume a master -> slave streaming replication configuration, Postgresql > 9.2. > Ass

[GENERAL] Detect streaming replication failure

2014-07-17 Thread Lists
For reference: https://wiki.postgresql.org/wiki/Streaming_Replication Assume a master -> slave streaming replication configuration, Postgresql 9.2. Assume that the master has been chugging away, but the slave PG service has been offline for a while and the wal archive has updated enough that th