[pgpool-general: 4868] Re: pgpool 3.5.3 - psql \connect hangs
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Aug 5 07:55:16 JST 2016
> I did some more testing, and \connect hangs when I'm running pgpool with
> the -ndD options.
>
> However when I run in normal daemon mode, \connect works correctly.
Works for me.
t-ishii at localhost: + /usr/local/bin/pgpool -d -D -n -f /home/t-ishii/work/pgpool-II/current/aaa/etc/pgpool.conf -F /home/t-ishii/work/pgpool-II/current/aaa/etc/pcp.conf -a /home/t-ishii/work/pgpool-II/current/aaa/etc/pool_hba.conf
t-ishii at localhost: psql -p 11000 test
Pager usage is off.
psql (9.5.3)
Type "help" for help.
test=# show pool_version;
pool_version
-------------------
3.5.3 (ekieboshi)
(1 row)
test=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+---------+-------+-------------------------
postgres | t-ishii | UTF8 | C | C |
template0 | t-ishii | UTF8 | C | C | =c/"t-ishii" +
| | | | | "t-ishii"=CTc/"t-ishii"
template1 | t-ishii | UTF8 | C | C | =c/"t-ishii" +
| | | | | "t-ishii"=CTc/"t-ishii"
test | t-ishii | UTF8 | C | C |
(4 rows)
test=# \connect postgres
You are now connected to database "postgres" as user "t-ishii".
postgres=# show pool_nodes;
node_id | hostname | port | status | lb_weight | role | select_cnt
---------+----------+-------+--------+-----------+---------+------------
0 | /tmp | 11002 | 2 | 0.333333 | primary | 1
1 | /tmp | 11003 | 2 | 0.333333 | standby | 0
2 | /tmp | 11004 | 2 | 0.333333 | standby | 0
(3 rows)
postgres=#
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list