Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 93D179FB833 for ; Wed, 4 Apr 2007 17:29:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99719-02-5 for ; Wed, 4 Apr 2007 17:29:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id 39C469FBB5E for ; Wed, 4 Apr 2007 17:29:48 -0300 (ADT) Received: from 81-86-233-75.dsl.pipex.com ([81.86.233.75]:2157 helo=[10.100.9.2]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HZCBf-0005Ir-Fv; Wed, 04 Apr 2007 21:34:35 +0100 Message-ID: <46140AA8.6030701@mailnetwork.co.uk> Date: Wed, 04 Apr 2007 21:29:28 +0100 From: Andy Shellam Reply-To: andy.shellam-lists@mailnetwork.co.uk Organization: www.AndyShellam.EU User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Dave Lazar CC: pgsql-admin@postgresql.org Subject: Re: security question References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/40 X-Sequence-Number: 25104 One quick point - you don't need to alter anything in the template1 database to set user's passwords. In PgAdmin III - use the "Login roles" section to set the passwords - that way everything will get committed correctly. Also, have you restarted PostgreSQL since changing pg_hba.conf? Andy. Dave Lazar wrote: > Hi, > > I have a quick question about my installation that puzzles me. pgsql > 8.2.3 on a debian box. Tested it out the database works. pgadmin III > connects fine too. I used alter table on the template1 database to > give postgres user a password. I changed pg_hba to use md5 on all > connections including local. > > When I use psql -U postgres -d myDataBase to connect to myDataBase I > do not get prompted for a password? When I su postgres and use psql > myDatabase I get prompted for my password? > > Is there some reason why I can login using psql to a database when > postgres is supposed to use passwords for all access? > > Probably a mistake I made somewhere along the line... just not sure > where, usually I get my pgsql install working great! > > Thanks > > Dave > !DSPAM:37,46140a1b89297979110243!