[Pgpool-general] Error in Master/Slave Replication

Tatsuo Ishii ishii at sraoss.co.jp
Sun Nov 7 09:12:15 UTC 2010


> Hi guys,
> I try to setup a Master/Slave replication via streaming. If I activate
> replication without Master/Slave everything works fine, but in the
> Master/Slave mode it is somehow messed up. I always get this one error
> and I have no idea where to look, at the master postgres side, master
> pgpool side or somewhere at the slave. Has anybody seen something like
> this?
> 
> "2010-11-04 16:11:59 ERROR: pid 3339: check_replication_time_lag:
> SELECT pg_last_xlog_receive_location() returns no data"

The error indicates that your standby server (192.168.1.3) is not
configured properly as a standby server. Are you sure that it's
running as a standby server?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list