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@xxxxxxxx>
To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@xxxxxxxxxxx>
CC: operationsengineer1@xxxxxxxxx, pgsql-php@xxxxxxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
