[pgpool-general: 5173] Fwd: pgpool config error

[Kirill Galinurov]

---------- Forwarded message ----------
From: Kirill Galinurov <k.galinurov at gmail.com>
Date: 2016-12-13 8:11 GMT+03:00
Subject: Re: [pgpool-general: 5162] pgpool config error
To: Tatsuo Ishii <ishii at sraoss.co.jp>


I can connect with psql. From one pgpool node to other. And to the
postgresql server's/
[root at SBC-MSK var]# psql -U postgres -h 172.20.200.3 -p 5433
Password for user postgres:
psql (9.6.1)
Type "help" for help.

postgres=# exit
postgres-# \q
[root at SBC-MSK var]# psql -U postgres -h 172.20.200.3 -p 5432
Password for user postgres:
psql (9.6.1)
Type "help" for help.

root at sbc-spb pgpool-II]# psql -h 172.20.200.2 -p 5433 -U postgres
Password for user postgres:
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
psql (9.6.1)
Type "help" for help.

postgres=#

[root at sbc-spb pgpool-II]# psql -h 172.20.200.2 -p 5432 -U postgres
Password for user postgres:
psql (9.6.1)
Type "help" for help.

postgres=#

1-node
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN
     11551/pgpool
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN
     2392/master
tcp        0      0 0.0.0.0:5433            0.0.0.0:*               LISTEN
     1218/postmaster
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
     11552/pgpool: watch
udp        0      0 0.0.0.0:9694            0.0.0.0:*
                          11554/pgpool: heart
udp        0      0 0.0.0.0:54273           0.0.0.0:*
                          11555/pgpool: heart

2-node
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN
     20190/pgpool
tcp        0      0 0.0.0.0:5433            0.0.0.0:*               LISTEN
     14123/postmaster
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
     20191/pgpool: watch
udp        0      0 0.0.0.0:9694            0.0.0.0:*
                          20195/pgpool: heart
udp        0      0 0.0.0.0:54251           0.0.0.0:*
                          20196/pgpool: heart


>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161213/70f1329c/attachment-0001.html>