[pgpool-general: 2980] Re: health check failed
Wolf Schwurack
wolf at uen.org
Thu Jun 26 23:15:17 JST 2014
Yes the backend is working? The application is able to connect.
I set in /etc/hosts postgres servers IP and hostname on the pgpool servers
and on postgres servers I set pgpool IP and hostname in /etc/hosts. its
all on the same network so there should be any network issues.
It doesn¹t go through a firewall
Here shows the connection from pgpool to postgres
pgprod-con1 ~ pgpool $ psql -p 9999
psql (9.2.6)
Type "help" for help.
postgres=#
Show nodes
postgres=# show pool_nodes;
node_id | hostname | port | status | lb_weight | role
---------+------------+------+--------+-----------+---------
0 | pgprod-db | 5432 | 2 | 0.500000 | primary
1 | pgprod-rep | 5432 | 2 | 0.500000 | standby
(2 rows)
I¹m not getting the error in my dev environment and in my RC environment I
only see the error on my standby pgpool server.
Our setup for all of our environments
2 pgpool servers (primary/standby)
2 postgres server (primary with streaming standby)
Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
Wolf at uen.org
On 6/25/14, 9:04 PM, "Yugo Nagata" <nagata at sraoss.co.jp> wrote:
>Hi,
>
>Please confirm the below;
>
>- The backend is actually working? Hostname and port number are right?
>- The network between pgpool and postgres is healty?
> Can you connect postgres from pgpool server by psql command?
>- Firewall configuration is right? SELinx etc. might cause.
>
>If all is ok, pgpool configuration might be wrong. Could you please
>send all pgpool log and pgpool.conf?
>
>On Wed, 25 Jun 2014 13:39:30 +0000
>Wolf Schwurack <wolf at uen.org> wrote:
>
>> I keep getting this error in my pgpool.log file
>> ERROR: pid 1250: health check failed. 0 th host pgprod-db at port 5432
>>is down
>>
>> Servers: Ubuntu 10.04.4 LTS
>> Postgres: psql (9.2.6)
>> Pgpool: pgpool-II version 3.3.3 (tokakiboshi)
>>
>> Wolfgang Schwurack
>> Database/System Administrator
>> Utah Education Network
>> 801-587-9444
>> Wolf at uen.org
>>
>
>
>--
>Yugo Nagata <nagata at sraoss.co.jp>
More information about the pgpool-general
mailing list