Re: Restore - Mailing list pgsql-general

From Bob Pawley
Subject Re: Restore
Date
Msg-id 3B7BB92C660E4BFA82CE5B111FEC2FF6@BobPC
Whole thread Raw
In response to Re: Restore  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Restore
List pgsql-general
I attempted loading earlier version of my backup database, using PDW# \I
PDW_May_2010  and it worked.

Looks as tho the June version may have been corrupt.

Thanks again for all of the help.

Bob

-----Original Message-----
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore

On 12/24/2010 08:15 PM, Bob Pawley wrote:
>
> -----Original Message----- From: Adrian Klaver
> Sent: Friday, December 24, 2010 8:08 PM
> To: Bob Pawley
> Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore
>
> On 12/24/2010 08:03 PM, Bob Pawley wrote:
>> I am installing 8.4 as I had problems with 8.3.
>>
>> Bob
>
> Well that would have been nice to have known at the beginning of this.
> At this point what versions do you have installed? As to errors have you
> looked at the Postgres log?
>
>
> Version 8.4.1 is installed.
>
> The same log as I sent before.
>
> 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"
>

Your computer clock is correct? The last entry is for 18:19:05 PST where
the time is currently Fri Dec 24 20:19:47 PST 2010. At any rate I am
going to have to bow for now, the elves are getting cranky:)

--
Adrian Klaver
adrian.klaver@gmail.com

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


pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Re: Restore
Next
From: Alban Hertroys
Date:
Subject: Re: Restore