[pgpool-general: 4868] Re: pgpool 3.5.3 - psql \connect hangs

[Tatsuo Ishii]

> 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