Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 52164477096 for ; Wed, 22 Jan 2003 15:19:08 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 7423847669D for ; Wed, 22 Jan 2003 14:47:45 -0500 (EST) Received: (qmail 7399 invoked by uid 500); 22 Jan 2003 20:00:17 -0000 Date: Wed, 22 Jan 2003 14:00:17 -0600 From: Bruno Wolff III To: Frans Haarman Cc: pgsql-admin@postgresql.org Subject: Re: Problems with authentication Message-ID: <20030122200017.GA7375@wolff.to> Mail-Followup-To: Frans Haarman , pgsql-admin@postgresql.org References: <20030121191456.GA54282@a.mail.synantics.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030121191456.GA54282@a.mail.synantics.nl> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/251 X-Sequence-Number: 7093 On Tue, Jan 21, 2003 at 20:14:56 +0100, Frans Haarman wrote: > Hi, > > I am building a webapplication for school, as a project. > > Basicly I want users to connect with their postgresql password an > username. > > I tried: > local all password > > but then it asks for a password when booting the server, and I would > like to have this done automaticly. > > Basicly I want everybody to require a password, and have the server > startup automaticly. In 7.3 there is a user column in the hba file that you can use to except the web account from a password check. Since you are using local, you might also consider using ident authentication. If people aren't sharing accounts, this probably gives you what you want.