| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Will McCormick <wmccormick(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: - PostgreSQL Replication Types |
| Date: | 2015-12-17 17:20:12 |
| Message-ID: | 5672EECC.60208@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | anj patnaik | 2015-12-17 17:28:18 | how to create dump of selected rows from a table |
| Previous Message | Will McCormick | 2015-12-17 16:43:38 | Re: - PostgreSQL Replication Types |