Re: Restore - Mailing list pgsql-general

On Fri, Dec 24, 2010 at 8:09 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
>
>
> -----Original Message----- From: Scott Marlowe
> Sent: Friday, December 24, 2010 6:49 PM
> To: Bob Pawley
> Cc: bricklen ; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore
>
> On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
>>
>>
>> -----Original Message----- From: Scott Marlowe
>> Sent: Friday, December 24, 2010 6:23 PM
>> To: Bob Pawley
>> Cc: bricklen ; pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] Restore
>>
>> On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley <rjpawley@shaw.ca> 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.