[pgpool-general: 7517] Re: pgpool listen port

Tatsuo Ishii ishii at sraoss.co.jp
Fri Apr 23 19:00:23 JST 2021

> Hi,
> Does anyone know if pgpool can listen on more than one port?

listen_addresses = '*'

However it's not possible to specify particular ports to be listened.

> Is it possible to separate encrypted and non-encrypted connections defining more than one listen port

No. I believe this is not possible with PostgreSQL neither.

> or there is another way to force some connections to be encrypted ?


enable_pool_hba = on

and create appropreate pool_hba.conf entry. For example,

hostssl    all         all          trust
host       all         all          trust

Any connection from is only allowed if the connection is
encrypted with SSL, while is allowed with/without SSL.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list