[GENERAL] pg_hba problem

2005-06-20 Thread Simon Windsor 
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  DATABASEUSERCIDR-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.255ident   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: [EMAIL PROTECTED]
Tel: 01454 617689
Mob: 07720 447385

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] pg_hba problem

2005-06-20 Thread Tom Lane 
Simon Windsor [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 8: explain analyze is your friend