pg_hba problem

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

Responses

Browse pgsql-general by date

  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