Monitoring streaming replication from standby on Windows

From: Yamen LA <iyamen(at)live(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Monitoring streaming replication from standby on Windows
Date: 2012-12-14 01:36:50
Message-ID: SNT135-W137A2209D96A461C99072EB44D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I would like to know how to check the status of the streaming replication from standby server on Windows. Apparently from the master I can use the pg table "pg_stat_replication". This table is, however, empty on the standby since it contains information about WAL sender processes and not WAL receiver. pg_last_xlog_replay_location and pg_last_xlog_receive_location also continue to be valid even when the streaming replication is down, so they don't help in this case.
From online tutorials and PostgreSQL wiki the only way I found is by checking the running processes for wal sender and wal receiver using ps command on Unix systems. The problem is that on Windows, all those processes carry the same name, postgresql.exe.

I suppose there should be some parameter to get the db engine as it realizes when the streaming replication is down and it logs that in pg_log files, but I can't seem to find such a parameter.

Thank you for your help.

-Yamen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl Denninger 2012-12-14 01:43:53 Re: Monitoring streaming replication from standby on Windows
Previous Message Kevin Grittner 2012-12-14 00:36:25 Re: pg_restore error with out of memory