Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 452E7477013 for ; Wed, 22 Jan 2003 17:35:21 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E3F704769C6 for ; Wed, 22 Jan 2003 16:55:55 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0MLtr5u024537; Wed, 22 Jan 2003 16:55:53 -0500 (EST) To: Frans Haarman Cc: pgsql-admin@postgresql.org Subject: Re: Problems with authentication In-reply-to: <20030121191456.GA54282@a.mail.synantics.nl> References: <20030121191456.GA54282@a.mail.synantics.nl> Comments: In-reply-to Frans Haarman message dated "Tue, 21 Jan 2003 20:14:56 +0100" Date: Wed, 22 Jan 2003 16:55:53 -0500 Message-ID: <24536.1043272553@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/253 X-Sequence-Number: 7095 Frans Haarman writes: > 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. You could tell the pg_ctl script not to try to check whether the postmaster started; then it won't need to connect and so won't need a password. I forget the switch for this, but it's in the docs. But in general, password auth is a pain in the neck for all admin duties. I agree with Bruno Wolff's suggestion to look at alternative auth methods. "ident" on local connections is secure, if your operating system supports it. regards, tom lane