[pgpool-general: 4066] find_primary_node: not in streaming replication mode

Giles Gomes giles.gomes at retailephant.com
Tue Sep 15 22:56:32 JST 2015


Dear Tatsuo,

I have configured pgpool according to following document.

http://www.keyup.eu/en/blog/89-replication-and-load-balancing-with-postgresql-and-pgpool2

But there log file it is saying that "find_primary_node: not in streaming
replication mode"

I am using pgpool-II-3.4.3 and PostgreSQL 9.3.9 on Ubuntu 14.04.2 LTS.

Please also give me a guidance how to test pgpool is working properly.

pgpool-II log,  pgpool.conf and PostgreSQL log is attached with the mail.

Regards,
Giles.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150915/f596c58b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pcp.conf
Type: application/octet-stream
Size: 902 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150915/f596c58b/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 2832 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150915/f596c58b/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql-9.3-main.master.log
Type: application/octet-stream
Size: 4670 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150915/f596c58b/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql-9.3-main.slave.log
Type: application/octet-stream
Size: 1916 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150915/f596c58b/attachment-0003.obj>


More information about the pgpool-general mailing list