Re: [GENERAL] psql: FATAL: missing or erroneous pg_hba.conf file

2006-04-21 Thread Tom Lane
Mark Sargent <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] ~]$ psql template1 > psql: FATAL: role "racket" does not exist > Which confuses me, as local all all trust should allow me to connect, > no? No, it allows you to claim that you are any database user you want to claim you are. The def

Re: [GENERAL] psql: FATAL: missing or erroneous pg_hba.conf file

2006-04-21 Thread Mark Sargent
Tom Lane wrote: That's short one "all": you need type, database, user, method columns (but no address column for "local"). Hi All, yes, Tom, you're correct. Someone mailed me directly(thank you), with a link to their site's tut on authentication, and I picked up on it straight away. Seems t

Re: [GENERAL] psql: FATAL: missing or erroneous pg_hba.conf file

2006-04-21 Thread Tom Lane
Mark Sargent <[EMAIL PROTECTED]> writes: > # TYPE DATABASEUSERCIDR-ADDRESS METHOD > # "local" is for Unix domain socket connections only > local all trust That's short one "all": you need type, database, user, method columns (but no address column for "local").

Re: [GENERAL] psql: FATAL: missing or erroneous pg_hba.conf file

2006-04-21 Thread Mark Sargent
Harald Armin Massa wrote: Mark, and what exactly is there in server log? LOG: missing field in file "/var/lib/pgsql/data/pg_hba.conf" at end of line 67 FATAL: missing or erroneous pg_hba.conf file HINT: See server log for details. psql: FATAL: missing or erroneous pg_hba.conf file

Re: [GENERAL] psql: FATAL: missing or erroneous pg_hba.conf file

2006-04-21 Thread Harald Armin Massa
Mark,and what exactly is there in server log? psql: FATAL:  missing or erroneous pg_hba.conf file HINT:  See server log for details. Reading your words I assume you made a typing error while editing pg_hba.confHarald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202