[EMAIL PROTECTED] 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
