Re: Restore - Mailing list pgsql-general

-----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??

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"


Bob

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general