Re: - PostgreSQL Replication Types

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