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
