Re: Restore - Mailing list pgsql-general

-----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
> 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>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general