X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3B901565E0 for ; Fri, 11 Mar 2005 06:51:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09931-08 for ; Fri, 11 Mar 2005 06:51:16 +0000 (GMT) Received: from web54004.mail.yahoo.com (web54004.mail.yahoo.com [206.190.36.228]) by svr1.postgresql.org (Postfix) with SMTP id BDDCE565E9 for ; Fri, 11 Mar 2005 06:51:14 +0000 (GMT) Received: (qmail 30531 invoked by uid 60001); 11 Mar 2005 06:51:15 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Kj9tmhuvayarvT/+su5jyeyNCpP57dMYCbzmaX28mdag1r73QyP9Z9RR6NTbcypyqjfd2KZDH8B+gHkDNnVdqpoEmV9+0ByGMb6jWl7vAkzM61Cs4U3GGvoatehWjCY/jRfomlTJ+D6fJkqT34hb4BOGjdvoWW/7HSmBvl2XVdA= ; Message-ID: <20050311065114.30529.qmail@web54004.mail.yahoo.com> Received: from [64.7.29.43] by web54004.mail.yahoo.com via HTTP; Thu, 10 Mar 2005 22:51:14 PST Date: Thu, 10 Mar 2005 22:51:14 -0800 (PST) From: Tom Wallick Subject: How to enable automatic md5 password prompting when connecting to PostgreSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.287 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/171 X-Sequence-Number: 16669 How can I automatically have PostgreSQL prompt for a password everytime I do the following to connect to my sample databaase 'movies'? I installed the database correctly to exact instructions in the INSTALL doc in the PostgreSQL source directory in /usr/local and it is now registered as a daemon in the LINUX run level scripts started when the system boots. I assigned a password to the Administrator account which is by default 'postgres' and to a second user ( the second was created with 'createuser tomwallick' command which successfully echoed with the CREATE USER message. However, no password was issued for the new user 'tomwallick' when I initially created the user. Then in the administrator handbook, I saw that I could create a password after the fact with the ALTER USER command. I used md5 password authentication, rather than the un encryped regular password athentication when issuing the passwords for both 'postgres' and 'tomwallick' users. Here is how I did this, which works but I must pass the -W flag to the psql command to startup the database in order to be prompted to type in a password. EXAMPLE: psql -d movies -U tomwallick -W I was simply expecting to simply just type: EXAMPLE: psql -d movies -U tomwallick and as a result have the password: prompt request the password AUTOMATICALLY. How can I clean/flush out the md5 passwords I originally created and start over alter the two user accounts 'postgres' and 'tomwallick' to simply have regular password athentication. Keep in mind 'postgres' account is actually the administrator. Or is it normal for my database to force me to type in the -W flag to force me to enter in my password. Help on this subject please. Tom Wallick __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/