Re: Newbie: pg_hba.conf question - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Newbie: pg_hba.conf question
Date
Msg-id Pine.LNX.4.21.0011151739280.779-100000@peter.localdomain
Whole thread Raw
In response to Newbie: pg_hba.conf question  (Marc Poinot <Marc.Poinot@onera.fr>)
List pgsql-admin
Marc Poinot writes:

> marcvs> psql
> psql: No pg_hba.conf entry for host localhost, user marcvs, database marcvs
>
> The pg_hba.conf in the PGDATA actually contains a line with:
>
> local all trust

"local" is not the same a "localhost".  The former refers to a Unix domain
socket connection, the latter to a TCP/IP connection, which requires a
"host" record in pg_hba.conf.  To use a "local" connection you need to
unset the PGHOST environment variable, in case you have it set.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: Serge Canizares
Date:
Subject: Re: Losing data from Postgres
Next
From: Alfred Perlstein
Date:
Subject: Re: Losing data from Postgres