Re: Restore

-----Original Message-----
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:49 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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"

Following is the copy of the command prompt

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Bob>cd c:\program files (x86)\postgresplus\8.4ss\bin

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password: calgary0623

psql: FATAL: password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password:

psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW -U postgres <
PDW_June_2_
2010.sql
psql: warning: extra command-line argument "postgres" ignored
Password for user -U: calgary0623

psql: FATAL: password authentication failed for user "-U"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -h localhost -U psql -d
PDW <
PDW_June_2_2010.backup
Password for user psql: calgary0623

psql: FATAL: password authentication failed for user "psql"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -u postgres PDW <
PDW_June_2_
2010.sql
psql: illegal option -- u
Try "psql --help" for more information.

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW <
PDW_June_2_
2010.sql
Password for user postgres: calgary0623

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password:

psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres -d PDW -f
PDW_Jun
e_2_2010.sql
Password for user postgres:

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U
postgres -fPDW_June_2_2010
.sql
Password for user postgres:
psql: FATAL: password authentication failed for user "postgres"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgresql
Password for user postgresql:
psql: FATAL: password authentication failed for user "postgresql"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>
c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW
<PDW)June_2_2
010.sql
The system cannot find the file specified.

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW
<PDW_June_2_2
010
The system cannot find the file specified.

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U PDW
<PDW_June_2_2010.sql
Password for user PDW: calgary0823

psql: FATAL: password authentication failed for user "PDW"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW
<PDW_June_2_2
010.sql
Password for user postgres: calgary0623

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -Upostgres PDW <
PDW_June_2_2
010.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW <
PDW_June_2_
2010.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -Upostgresql PDW
<PDW_June_2_
2010.sql
Password for user postgresql: calgary0623

psql: FATAL: password authentication failed for user "postgresql"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -Upostgres PDW
<PDW_June_2_20
10.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres PDW <
PDW_June_2_
2010.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql PDW < PDW_June_2_2010.sql
Password: calgary0623

psql: FATAL: password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres -d PDW -U
postgre
s -f PDW_June_2_2010.sql

c:\Program Files
(x86)\PostgresPlus\8.4SS\bin>psql -Upostgres -dPDW -fPDW_June_2
_2010.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql -U postgres -d PDW -f
PDW_Jun
e_2_2010.sql

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql \I
Password:
psql: FATAL: password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql \I
Password:
psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql
Password:
psql: fe_sendauth: no password supplied

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql
Password:
psql: FATAL: password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>psql \I
Password:
psql: FATAL: password authentication failed for user "Bob"

c:\Program Files (x86)\PostgresPlus\8.4SS\bin>