[pgpool-general: 9366] Re: pgpool 4.5.5 can't reach stand by server

Tatsuo Ishii ishii at postgresql.org
Sat Feb 15 09:42:13 JST 2025


> Hi Tatsuo
> 
> At least it works.
> 
> I've changed backend_hostname0 to its IP address, then again I've attached
> manually the secondary server and I could connect to pgpool
> 
> *[postgres at buda pgpool-II]$ pcp_attach_node -p 9898 -h 192.168.1.160 -n 1
> -U maufer -W*
> Password:
> pcp_attach_node -- Command Successful
> [postgres at buda pgpool-II]$
> 
> *[postgres at buda pgpool-II]$ psql -p 9999*Contraseña para usuario postgres:
> psql (17.2)
> Digite «help» para obtener ayuda.

Next time you start pgpool, you don't need to execute pcp_attach_node
because now pgpool recognizes that node 1 is online (it's recorded in
pgpool_status file).

> This is the first part, I pretend to test pgpool as a load balancer and
> connection pooler, after that I would try fail / switch over
> 
> Thank you very much for the support

You are welcome!
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list