Re: PITR Backups

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