Received: from s2.enthdimension.com.au ([203.36.78.178]) by hub.org (8.10.1/8.10.1) with ESMTP id e847paC90357 for ; Mon, 4 Sep 2000 03:51:37 -0400 (EDT) Received: (from root@localhost) by s2.enthdimension.com.au (8.9.3/8.8.7) id SAA01384 for pgsql-sql@postgresql.org; Mon, 4 Sep 2000 18:50:12 GMT Date: Mon, 4 Sep 2000 18:50:11 +0000 From: Craig May To: pgsql-sql@postgresql.org Subject: Re: pg_hba.conf Message-ID: <20000904185011.A1296@s2.enthdimension.com.au> Reply-To: craig.may@s2.enthdimension.com.au References: <00090419490900.07520@berty> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: x-unknown In-Reply-To: <00090419490900.07520@berty>; from csawtell@xtra.co.nz on Mon, Sep 04, 2000 at 07:47:08 +0000 X-Mailer: Balsa 0.8.0 X-Archive-Number: 200009/10 I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres. The file is located in /usr/lib/pgsql/. I'm still receiving the same error. On Mon, 04 Sep 2000 07:47:08 Christopher Sawtell wrote: > On Tue, 05 Sep 2000, Craig May wrote: > > Hi, > > > > I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database > > XXX." I've modified the pg_hba.conf.sample file to allow all access, however > > still getting the same message. Any suggestions? > you have copied pg_hba.conf.sample to pg_hba.conf havn't you? > > If that dosn't work check the permissions. The file has to readable by the > pgsql server/backend. > > -- > Sincerely etc., > > NAME Christopher Sawtell > CELL PHONE 021 257 4451 > ICQ UIN 45863470 > EMAIL csawtell @ xtra . co . nz > CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz > > -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--