Re: - PostgreSQL Replication Types - Mailing list pgsql-general

From Adrian Klaver
Subject Re: - PostgreSQL Replication Types
Date
Msg-id 5672EECC.60208@aklaver.com
Whole thread Raw
In response to Re: - PostgreSQL Replication Types  (Will McCormick <wmccormick@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: - PostgreSQL Replication Types
Next
From: Merlin Moncure
Date:
Subject: Re: Index contains unexpected zero page at block