Re: PITR Backups - Mailing list pgsql-performance

From Simon Riggs
Subject Re: PITR Backups
Date
Msg-id 1182788599.9276.598.camel@silverbirch.site
Whole thread Raw
In response to Re: PITR Backups  (Dan Gorman <dgorman@hi5.com>)
List pgsql-performance
On Mon, 2007-06-25 at 08:28 -0700, Dan Gorman wrote:
> I took several snapshots. In all cases the FS was fine. In one case
> the db looked like on recovery it thought there were outstanding
> pages to be written to disk as seen below and the db wouldn't start.
>
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [9-1] 2007-06-21
> 00:39:43 PDTLOG:  redo done at 71/99870670
> Jun 21 00:39:43 sfmedstorageha001 postgres[3506]: [10-1] 2007-06-21
> 00:39:43 PDTWARNING:  page 28905 of relation 1663/16384/76718 was
> uninitialized

OK, please put log_min_messages = DEBUG2 and re-run the recovery please.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-performance by date:

Previous
From: Dan Gorman
Date:
Subject: Re: PITR Backups
Next
From: Tom Lane
Date:
Subject: Re: PITR Backups