X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 78853D891E for ; Fri, 14 Oct 2005 17:54:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03163-03 for ; Fri, 14 Oct 2005 20:54:29 +0000 (GMT) Received: from hotmail.com (bay14-f11.bay14.hotmail.com [64.4.49.11]) by svr1.postgresql.org (Postfix) with ESMTP id DAA85D76E9 for ; Fri, 14 Oct 2005 17:54:30 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 14 Oct 2005 13:54:32 -0700 Message-ID: Received: from 201.242.103.50 by by14fd.bay14.hotmail.msn.com with HTTP; Fri, 14 Oct 2005 20:54:32 GMT X-Originating-IP: [201.242.103.50] X-Originating-Email: [juanernestof@hotmail.com] X-Sender: juanernestof@hotmail.com In-Reply-To: From: "JUAN ERNESTO FLORES BELTRAN" To: gmr@ehpg.net Cc: operationsengineer1@yahoo.com, pgsql-php@postgresql.org Subject: Re: autentication problem Date: Fri, 14 Oct 2005 20:54:32 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 14 Oct 2005 20:54:32.0517 (UTC) FILETIME=[7A319750:01C5D101] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.212 required=5 tests=[AWL=-0.538, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/37 X-Sequence-Number: 3305 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" >To: "JUAN ERNESTO FLORES BELTRAN" >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