[Pgpool-general] ERROR: check_replication_time_lag: SELECT pg_last_xlog_receive_location() returns no data

[Saurabh Agrawal]

Hi Tatsuo,

How to check that slave is working as standby or not? All ddl and dml
changes are taking effect on slave db and SELECT
pg_last_xlog_replay_location() is also returning data.

Regards
Saurabh Agrawal

On Mon, Jun 6, 2011 at 5:26 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> I have setup pgpool-II with Master-Slave replication via streaming but
>> in pgpool log file I am getting error:
>>
>> "ERROR:         pid     8779:   check_replication_time_lag: SELECT
>> pg_last_xlog_receive_location() returns no data"
>>
>> I executed the above query manually on slave also but no data returned
>> and when i executed SELECT pg_last_xlog_replay_location() it returns
>> data.
>
> It seems your slave actually does not act as standby.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>