[pgpool-general: 273] Re: Authentication help?

[Tatsuo Ishii]

> Hey I'm working on a new PGPool setup for our PG 9.1 environment. Right now we have 1 master server and 3 slaves. I've got PGPool only setup in Load Balancing mode, and only listing the slaves at the moment ― I'll be adding the master in later today. 
> 
> I'm not sure how PGPool is handling auth... If I connect to pgpool's port with the 'postgres' user it works just fine. However, if I connect with any other user I immediately get kicked out (I see a 'psql: ' line, then get kicked out). I've tried with and without enable_pool_hba.
> 
> Our backends all have a line like this in pg_hba.conf:
> 
>> hostssl all all 10.0.0.0/8 password
>> hostssl replication all 10.0.0.0/8 password
> 
> and our pgpool is configured to connect as 'postgres' for healthchecks and replication checks. Can someone explain how I need to configure pgpool so that I can auth with our role accounts?

Pgpool version? Can you please show me the pgpool log when psql was kicked out?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp