From: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_hba problem |
Date: | 2005-06-20 21:14:32 |
Message-ID: | 200506202214.32741.simon.windsor@cornfield.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)windsor(at)cornfield(dot)org(dot)uk
Tel: 01454 617689
Mob: 07720 447385
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-06-20 21:30:00 | Re: pg_hba problem |
Previous Message | Akash Garg | 2005-06-20 21:08:04 | Error during pg_dump |