Received: from smartt.com (ktk6.smartt.com [209.52.5.253]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAK1Ism94250 for ; Mon, 19 Nov 2001 20:18:55 -0500 (EST) (envelope-from drfrog@smartt.com) Received: from nomad.localdomain (alpnb13234.smarttadsl.com [209.52.133.234]) by smartt.com (8.11.1/8.11.1) with SMTP id fAK1VmT09272; Mon, 19 Nov 2001 17:31:48 -0800 (PST) Message-Id: <200111200131.fAK1VmT09272@smartt.com> Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit Mime-Version: 1.0 From: "Clayton Cottingham aka drfrog" To: Peter Eisentraut Cc: "pgsql-sql@postgresql.org" Subject: Re: [OT?] permissions X-Mailer: Pronto v2.2.5 On linux/Pg Date: 19 Nov 2001 17:20:18 PST Reply-To: "Clayton Cottingham aka drfrog" In-Reply-To: References: X-Archive-Number: 200111/275 X-Sequence-Number: 5657 Thanks Peter: On Mon, 19 Nov 2001 15:40:12 +0100 (CET), Peter Eisentraut said: > > so i try > > > > #local ident not avail! right? > > host all 127.0.0.1 255.255.255.255 ident postgres > > > > and get this > > psql: No pg_hba.conf entry for host localhost, user postgres, database postgres > > even though it says 'all' > > I don't know if it's the cause of the message, but 'ident postgres' > doesn't seem right. The word after ident is not a user name. > doh! ok those names are just mappings for pg_ident.conf correct or the special name sameuser are there any other keywords i should know? > > one would think there should be an extra option on this of user to connect > > > > like > > > > local mydb password passwd myuser > > host mydb 127.0.0.1 255.255.255.255 password passwd > > myuser > > There is: You only list the users you want to be able to get in in the > 'passwd' file. > ah yes as soon as i read this i was oh yeah sort of like apache ! Thanks Again