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