hi everyone, i tried as explained at:
http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#AUTH-PG-HBA-CONF
i searched the file pg_hba.conf at: /usr/local/pgsql/data/pg_hba.conf
.......................................................................................................................................................................................
Client authentication is controlled by the file pg_hba.conf in the data
directory, e.g., /usr/local/pgsql/data/pg_hba.conf. (HBA stands for
host-based authentication.) A default pg_hba.conf file is installed when the
data directory is initialized by initdb.
.......................................................................................................................................................................................
However, i didnt find any pg_hba.conf ahywhere in my computer. So how can i
access to this information in order to configure my database system?
I tried both, posgresql running mode and stopped. No pg_hba.conf file
found.....
/etc/init.d/postgresql stop and
/etc/init.d/postgresql start
What should i do next?
Thanks for your help
Juan
>From: "Gavin M. Roy" <gmr@ehpg.net>
>To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com>
>CC: operationsengineer1@yahoo.com, pgsql-php@postgresql.org
>Subject: Re: [PHP] autentication problem
>Date: Fri, 14 Oct 2005 12:41:00 -0700
>
>http://www.postgresql.org/docs/7.4/interactive/client-
>authentication.html#AUTH-PG-HBA-CONF
>
>^^ should have everything you need to know :)
>
>Gavin
>
>On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES BELTRAN wrote:
>
>>Sorry for the english message, i will translate it as follows:
>>
>>"Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL:
>>autentification has failed for postgres user in /srv/
>>www/htdocs/Prototipo/opciones.php on line 51"
>>
>>any other suggesttion?
>>what shoudl i modify to pg_hba.conf?
>>
>>regards