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

Saurabh Agrawal saurabh.miet at gmail.com
Mon Jun 6 10:48:14 UTC 2011


Hi All,

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.

Did anybody faced same problem, if yes how to solve it?

Thanks

Regards
Saurabh Agrawal


More information about the Pgpool-general mailing list