[pgpool-hackers: 2927] SCRAM: 2 x backend
Jesper Pedersen
jesper.pedersen at redhat.com
Thu Aug 9 22:18:40 JST 2018
Hi,
When I'm using SCRAM-SHA256 authentication with the SCRAM_AUTH branch
I'm seeing that 2 times the number backends are created per client.
pg_hba.conf
-----------
host all all 127.0.0.1/32 scram-sha-256
pool_hba.conf
-----------
host all all 127.0.0.1/32 scram-sha-256
pgpool.conf:
------------
num_init_children = 100
max_pool = 1
Then connect to the database
psql -h localhost -p 9999 -U myuser mydb
and exit (\q). ps aux | grep postgres will show 2 active backends.
Connecting with a MD5 based user only creates 1 active backend.
SCRAM_AUTH as of August 9, 2018.
Best regards,
Jesper
More information about the pgpool-hackers
mailing list