Skip site navigation (1) Skip section navigation (2)

pg_last_xlog_receive_location()

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_last_xlog_receive_location()
Date: 2011-03-30 01:13:37
Message-ID: 20110330.101337.452091430337865395.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
In my understanding pg_last_xlog_receive_location() returns NULL if
applied to non standby server:

Get last transaction log location received and synced to disk by
streaming replication. While streaming replication is in progress this
will increase monotonically. But when streaming replication is
restarted this will back off to the replication starting position,
typically the beginning of the WAL file containing the current replay
location. If recovery has completed this will remain static at the
value of the last WAL record received and synced to disk during
recovery. If streaming replication is disabled, or if it has not yet
started, the function returns NULL.

However my primary server returns non NULL. Am I missing something?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Responses

pgsql-hackers by date

Next:From: Joseph AdamsDate: 2011-03-30 01:15:11
Subject: Re: Another swing at JSON
Previous:From: Josh BerkusDate: 2011-03-30 01:06:00
Subject: Re: pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group