[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