Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id EB569475C63 for ; Wed, 10 Jul 2002 23:00:00 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g6B2xqj26852; Wed, 10 Jul 2002 22:59:52 -0400 (EDT) From: Bruce Momjian Message-Id: <200207110259.g6B2xqj26852@candle.pha.pa.us> Subject: Re: postgres authentication In-Reply-To: <1026334114.3d2c9da2be9e0@webmail.mit.edu> To: acchung@mit.edu Date: Wed, 10 Jul 2002 22:59:51 -0400 (EDT) Cc: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200207/172 X-Sequence-Number: 4858 acchung@mit.edu wrote: > 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! That file is used for secondary passwords. It is going away in 7.3 so I suggest using ALTER USER PASSWORD to set the password for the user in the pg_shadow table. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026