Received: from israel.diaspora.gen.nz (mail@israel.diaspora.gen.nz [202.50.109.65]) by hub.org (8.10.1/8.10.1) with ESMTP id e6JLkqh27264 for ; Wed, 19 Jul 2000 17:46:52 -0400 (EDT) Received: from rodgerd by israel.diaspora.gen.nz with local (Exim 3.12 #1 (Debian)) id 13F1fv-0008TL-00; Thu, 20 Jul 2000 09:46:43 +1200 Date: Thu, 20 Jul 2000 09:46:43 +1200 To: pgsql-sql@postgresql.org Subject: Re: Database authentication and configuration Message-ID: <20000720094643.A32547@diaspora.gen.nz> Reply-To: rodgerd@diaspora.gen.nz References: <3973BA8A.4FD285F9@kss.net.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: <3973BA8A.4FD285F9@kss.net.au>; from carolyn@kss.net.au on Tue, Jul 18, 2000 at 12:01:46PM +1000 From: Rodger Donaldson X-Archive-Number: 200007/184 On Tue, Jul 18, 2000 at 12:01:46PM +1000, Carolyn Lu Wong wrote: > Are there anywhere to configure so that whenever I call 'psql dbname', > it'll always prompt for user authentication instead of getting into the > database directly? Take a look at the configuration of your pg_hba.conf file. You will most likely find that you're set up to trust local users. You can force authentication by changing this to password, crypt, or kerberos based authentication. -- Rodger Donaldson rodgerd@diaspora.gen.nz "Forgive us if we bite your head off; we were led to assume you weren't using it in the first place" --Jim Allenspach, in comp.lang.perl.misc