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.klaver@aklaver.com