query replication status when WAL-E is used

From: Valery Sizov <valery(at)gitlab(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: query replication status when WAL-E is used
Date: 2018-10-18 16:56:29
Message-ID: CAK=zUS3LrYPUL1i_iYgQoLD-2YRzLoLOS=2xzmhG6FL3etMH9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2018-10-18 21:13:28 Re: convert real to numeric.
Previous Message Tom Lane 2018-10-18 16:29:33 Re: BUG: Incorrect working with POSIX locale if database in UTF-8 encoding