Received: from websnail.mit.edu (WEBSNAIL.MIT.EDU [18.7.21.99]) by postgresql.org (Postfix) with ESMTP id 8B8A14758F8 for ; Wed, 10 Jul 2002 16:48:34 -0400 (EDT) Received: (from www@localhost) by websnail.mit.edu (8.9.3) id QAA12068; Wed, 10 Jul 2002 16:48:35 -0400 (EDT) From: acchung@mit.edu Received: from e52bps588r.mit.edu ( [e52bps588r.mit.edu]) as user acchung@MIT.EDU by webmail.mit.edu with HTTPS; Wed, 10 Jul 2002 16:48:34 -0400 Message-ID: <1026334114.3d2c9da2be9e0@webmail.mit.edu> Date: Wed, 10 Jul 2002 16:48:34 -0400 To: pgsql-admin@postgresql.org Subject: postgres authentication MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 18.170.4.86 X-Originating-Host: e52bps588r.mit.edu X-MIT-WebMail-Sender: X-MIT-WebMail-User-Browser: Mozilla/5.0 (compatible; Konqueror/3.0.0-10; Linux) X-Archive-Number: 200207/168 X-Sequence-Number: 4854 Hi, I changed my pg_hba.conf file so that I am authenticating using md5 from passwdfile which is a file i created to hold my passwords. I didn't add postgres onto that file but when I type psql template1 under postgres, it prompts me for my password. i type it in and it gives me psql: FATAL 1: Password authentication failed for user "postgres" I only have one password for postgres which I used perfectly fine to log into linux. I also use the same password to switch between postgres and other non-root users in the bash shell. i tried adding postgres into the passwdfile file but to no avail. How do I correct this password bug for postgres so that I can do stuff as a superuser? HELP! Alex