| 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: | Whole Thread | Raw Message | 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 |