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?
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 |