pg_hba problem

Started by Simon Windsoralmost 21 years ago2 messagesgeneral
Jump to latest
#1Simon Windsor
simon.windsor@cornfield.org.uk

Hi

I have just installed 8.0.3, and my standard pg_hba config no longer works.

I usually enable the postgres accound using

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all postgres ident sameuser

and use other lines for named datbases.

However, with 8.0.3, the format appears to have changed to

# host DBNAME IP_ADDRESS ADDRESS_MASK AUTHTYPE [AUTH_ARGUMENT]
# local DBNAME AUTHTYPE [AUTH_ARGUMENT]

with no mention of USER. I have tried to use pg_ident to get round this,

pg_ident
map1 postgres postgres

pg_hba
host all 127.0.0.1 255.255.255.255 ident map1

but I keep getting the error

psql: No pg_hba.conf entry for host localhost, user postgres, database
template1

Any ideas how I can safely provide global access to the postgres account?

Simon

--
Simon Windsor
Email: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07720 447385

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Simon Windsor (#1)
Re: pg_hba problem

Simon Windsor <simon.windsor@cornfield.org.uk> writes:

However, with 8.0.3, the format appears to have changed to

# host DBNAME IP_ADDRESS ADDRESS_MASK AUTHTYPE [AUTH_ARGUMENT]
# local DBNAME AUTHTYPE [AUTH_ARGUMENT]

Better check again ... it hasn't looked like that since PG 7.2.

regards, tom lane