[pgpool-general: 9344] Re: pgpool connection

[Tatsuo Ishii]

> environment->
> linux os:rel8
> postgresql : postgresql 15.9
> pgpool : pgpool-II-4.5.0
> 
>   After installing pgpool, I encountered a problem when trying to start
> pgpool. When I use the command #pgpool, there is no error. However, when I
> check with # ps aux | grep pgpool, the following information appears.
> 
>   root      219469 51.0  1.7 209876 137340 ?       Ss   16:02   0:01 pgpool
> root      219470  0.0  0.0  76104  1348 ?        S    16:02   0:00 pgpool:
> PgpoolLogger
> root      219472  0.0  0.0 209876  2860 ?        S    16:02   0:00 pgpool:
> wait for connection request
[snip]
> root      219507  0.0  0.0 221948  1144 pts/0    S+   16:02   0:00 grep
> --color=auto pgpool
> 
> When I use the following command,
> # psql -p 9999 -Upostgres -h <local_ip> test
> 
> the following result appears.
> psql: error: connection to server at "<local_ip>", port 9999 failed: 連線被拒絕
>         Is the server running on that host and accepting TCP/IP connections?
> 
> I added the following to my pool_hba.conf.
> host    all         all             0/0               md5
> 
> and I pgpool.conf connections
> listen_addresses = '*'
> port = 9999
> unix_socket_directories = '/tmp'
> 
>   I have also set up the connection parameters for my psql, but I still
> can't connect. What areas should I check?

netstat -a|grep 9999

will show how pgpool is accepting connections.

Also you want check one of followings work for you.

psql -p 9999 -Upostgres  test
psql -p 9999 -Upostgres  -h localhost test
psql -p 9999 -Upostgres  -h 127.0.0.1 test

Can you share the pgpool.log at the pgpool start up? There is info
regarding which port pgpool is accepting.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp