Re: Restore

On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
>
>
> -----Original Message----- From: Scott Marlowe
> Sent: Friday, December 24, 2010 6:23 PM
> To: Bob Pawley
> Cc: bricklen ; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Restore
>
> On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley <rjpawley(at)shaw(dot)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
> 2010-12-24 11:08:49 PSTLOG:  database system is ready to accept connections
> 2010-12-24 11:08:49 PSTLOG:  autovacuum launcher started
> 2010-12-24 11:21:25 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:35 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:39 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:50 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:21:54 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:22:05 PSTWARNING:  pgstat wait timeout
> 2010-12-24 11:32:38 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 12:11:09 PSTFATAL:  password authentication failed for user "-U"
> 2010-12-24 12:18:50 PSTFATAL:  password authentication failed for user
> "psql"
> 2010-12-24 15:27:40 PSTFATAL:  password authentication failed for user
> "postgres"
> 2010-12-24 15:41:10 PSTFATAL:  password authentication failed for user
> "postgresql"
> 2010-12-24 15:44:15 PSTFATAL:  password authentication failed for user "PDW"
> 2010-12-24 15:50:13 PSTFATAL:  password authentication failed for user
> "postgresql"
> 2010-12-24 16:08:49 PSTFATAL:  password authentication failed for user "Bob"
> 2010-12-24 18:13:34 PSTFATAL:  password authentication failed for user "Bob"
> 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"