On Fri, Dec 24, 2010 at 8:09 PM, Bob Pawley <rjpawley@xxxxxxx> wrote: > > > -----Original Message----- From: Scott Marlowe > Sent: Friday, December 24, 2010 6:49 PM > To: Bob Pawley > Cc: bricklen ; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Restore > > On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley <rjpawley@xxxxxxx> wrote: >> >> >> -----Original Message----- From: Scott Marlowe >> Sent: Friday, December 24, 2010 6:23 PM >> To: Bob Pawley >> Cc: bricklen ; pgsql-general@xxxxxxxxxxxxxx >> Subject: Re: Restore >> >> On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley <rjpawley@xxxxxxx> wrote: >>> >>> When I type psql I am asked for a password. When I attempt to enter a >>> password the cursor doesn't move. >> >> It's not supposed to, so don't worry about that. >> How exactly are you running psql? Can you show us what you typed in? >> >>> When I click enter I get failed password for - my computer name. >> >> Hmmm. Again, please copy and paste exactly what it says. >> >>> When I type psql \I - I get the same as above. >> >> Yeah, until you can log in psql \l isn't going to work. Once you can >> log in it should work. >> >> So, yeah. cut and paste your psql session first, k? >> >> Is this what you meant by psql session?? > > No, that's the pgsql log, which is also quite useful. So, when you > bring up a command prompt and type in psql -U bob wwwdb or something > like that and it says something about a password failure, that's the > stuff I'd like you to cut and paste. The accompanying postgresql like > this one here would be useful too. > >> >> 2010-12-24 11:08:46 PSTLOG: database system was shut down at 2010-12-24 >> 11:07:13 PST >> 2010-12-24 11:08:46 PSTFATAL: the database system is starting up >> 2010-12-24 11:08:47 PSTFATAL: the database system is starting up >> 2010-12-24 11:08:48 PSTFATAL: the database system is starting up SNIP >> 2010-12-24 18:17:25 PSTFATAL: password authentication failed for user >> "Bob" >> 2010-12-24 18:19:05 PSTFATAL: password authentication failed for user >> "Bob" > > > Following is the copy of the command prompt > > Microsoft Windows [Version 6.1.7600] > Copyright (c) 2009 Microsoft Corporation. All rights reserved. SNIP > c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql > Password: > psql: FATAL: password authentication failed for user "Bob" So have you at any time before this set a password for any user within postgres (remember, a postgres account and password are not the same as an OS user and password. Have you issued a command that went through in pgadmin or psql that changed / set a password for any account? Do this if you can: Change pg_hba.conf to change all methods from md5 or ident to trust. Save the original file. restart pgsql. If it won't restart, then show us the changes from the file before and after you edited it. If it does work, then try to log in as postgres: psql -U postgres postgres First arg is db, second is user. See if that works. If it doesn't, copy and paste that psql terminal session for us to look at. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
