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

[Tatsuo Ishii]

> 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