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 <[email protected]> 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 > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
