On 12/17/2015 08:43 AM, Will McCormick wrote:
Almost forgot this:
SELECT pg_current_xlog_location();
I was not paying attention earlier that should be:
pg_last_xlog_receive_location()
from:
http://www.postgresql.org/docs/9.1/interactive/functions-admin.html
Table 9-58. Recovery Information Functions
ERROR: recovery is in progress
HINT: WAL control functions cannot be executed during recovery.
bms=> SELECT pg_current_xlog_location();
ERROR: recovery is in progress
HINT: WAL control functions cannot be executed during recovery.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general