Re: pg_hba.conf file - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pg_hba.conf file
Date
Msg-id Pine.LNX.4.30.0103031131570.937-100000@peter.localdomain
Whole thread Raw
In response to pg_hba.conf file  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
Martin A. Marques writes:

> local   all                                             trust
> host    all     127.0.0.1       255.255.255.255         password
> host    all     168.96.132.31   255.255.255.0           password
> host    all     170.210.8.31    255.255.255.0           password
>
> What do you people hear think of this? I'm consurned about the local enterie,
> but when I put password instead of trust, I can't login with PHP to the
> database.

Apparently, your PHP application connects through the 'local' (Unix domain
socket) connection.  That means the 'host' entries are irrelevant.  Of
course if you set the authentication method to 'password' and don't
actually provide a (correct) password then things aren't going to work.

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


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Can you list the text of a proc in psql?
Next
From: Peter Eisentraut
Date:
Subject: Re: Error message on pg_dumpall