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

[Giles Gomes]

Hello Tatuo,

Thanks for your response.

After setting following parameters 'backend no 0'  seems OK.


master_slave_mode = on
master_slave_sub_mode = 'stream'

But there are some new error as following:
------------------------------------------------------------------
..............
..............
2015-09-16 03:30:51: pid 15478: DEBUG:  SSL is requested but SSL support is
not available
2015-09-16 03:30:51: pid 15478: ERROR:  failed to authenticate
2015-09-16 03:30:51: pid 15478: DETAIL:  invalid authentication message
response type, Expecting 'R' and received 'E'
2015-09-16 03:30:51: pid 15478: LOG:  find_primary_node: checking backend
no 1
2015-09-16 03:30:51: pid 15478: DEBUG:  SSL is requested but SSL support is
not available
2015-09-16 03:30:51: pid 15478: ERROR:  failed to authenticate
2015-09-16 03:30:51: pid 15478: DETAIL:  invalid authentication message
response type, Expecting 'R' and received 'E'
2015-09-16 03:30:51: pid 15478: DEBUG:  find_primary_node: no primary node
found
-------------------------------------------------------------------

I have attached the pgpool.conf and pgpool-II log with this email.

Best Regards,
Giles.

On 16 September 2015 at 07:13, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > 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.
>
> I did not write the blog and I am not in the position of speaking for it.
> It's best you directly contact to the author of the blog.
>
> Anyway, my guess is you do not set:
>
> master_slave_mode = on
> master_slave_sub_mode = 'stream'
>
> See the manual for more details.  This is just a guess because you did
> not attach pgpool.conf, though.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150916/49c23eaa/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 33379 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150916/49c23eaa/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 3524 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150916/49c23eaa/attachment-0003.obj>