pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
To: gmr@ehpg.net
Cc: operationsengineer1@yahoo.com
Cc: pgsql-php@postgresql.org
Subject: Re: autentication problem
Date: Fri, 14 Oct 2005 20:54:32 +0000
Message-ID: <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl> (raw)
In-Reply-To: <A1225E90-3611-4131-804F-3FD7C369A1DE@ehpg.net>

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





view thread (9+ messages)  latest in thread

Message-ID: <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl>
Permalink:  ../BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl/
Also on:    postgresql.org/message-id/BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: juanernestof@hotmail.com, gmr@ehpg.net, operationsengineer1@yahoo.com
  Subject: Re: autentication problem
  In-Reply-To: <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl>
  References: <A1225E90-3611-4131-804F-3FD7C369A1DE@ehpg.net> <BAY14-F1118E217D009DDAE1D3748CD7D0@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox