Postgres Pro
Downloads
Home   >   mailing lists

Thread: query replication status when WAL-E is used

query replication status when WAL-E is used

From
Valery Sizov
Date:
Hi all,

I need to have a way to query a streaming replication status from the client (Web app), on a secondary node.  It can be easily done now by performing a query "select pid, status from pg_stat_wal_receiver". The problem is that sometimes we need to use WAL-E replication and in this case, it's impossible to get the status using SQL command. As WAL-E essentially uses archive_command/restore_command, I would like to be able to see the content of the restore_command in recovery.conf file using SQL command. Keep in mind that I CAN see the archive_command value by using whether "SELECT ALL" or "SELECT * FROM pg_settings"
What do you think?