query replication status when WAL-E is used

[Valery Sizov <valery@xxxxxxxxxx>]

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?