[pgpool-general: 3539] Re: Add new node weirdness (master slave)

[Tatsuo Ishii]

> Hi,
> 
> I have a working master/slave setup (streaming) with two nodes (db1,
> db2) and added a third (db3). This is with pgpool II 3.3.2 on Ubuntu
> 14.04. The topology is:
> - host web1: pgpool2
> - host db1-3: postgres 9.3 (package with pgpool functions)
> 
> As I understand it I should do:
> 
> - install postgres on the db3, stop the postgres service
> - edit pgpool.conf to add the db3
> - reload pgpool2 service
> - recover db3

Correct.

> I found that in fact I had to:
> - reload db3 - observe that db3 *not* detected.

Works for me. What did you add to pgpool.conf exactly?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> - restart pgpool2 service - observe that new connections crash with
> - 'unable to initialize'
> - restart pgpool2 service two more times - observe that *now* I can
> - connect to db1,db2 ok and db3 is detected
> - recover db3
> 
> 
> I'm doing the 'reload' with:
> 
> $ sudo service pgpool2 reload
> 
> ...and not seeing anything new appearing in the log - I'm wondering if
> 'reload' is actually doing anything here...
> 
> I'll remove db3 and then add it again to see if I can reproduce the
> connection crash and et more detail.
> 
> Regards
> 
> Mark
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general