Re: autentication problem

From: "JUAN ERNESTO FLORES BELTRAN" <juanernestof(at)hotmail(dot)com>
To: gmr(at)ehpg(dot)net
Cc: operationsengineer1(at)yahoo(dot)com, pgsql-php(at)postgresql(dot)org
Subject: Re: autentication problem
Date: 2005-10-14 20:54:32
Message-ID: BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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(at)ehpg(dot)net>
>To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof(at)hotmail(dot)com>
>CC: operationsengineer1(at)yahoo(dot)com, pgsql-php(at)postgresql(dot)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

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message operationsengineer1 2005-10-15 00:00:12 Re: autentication problem
Previous Message pippo 2005-10-14 20:05:21 login problem