Re: PITR Backups

From: Dan Gorman <dgorman(at)hi5(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Koichi Suzuki" <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp>, "Toru SHIMOGAKI" <shimogaki(dot)toru(at)oss(dot)ntt(dot)co(dot)jp>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PITR Backups
Date: 2007-06-25 16:05:12
Message-ID: BEE0B157-956B-41D3-8904-643F30E317BF@hi5.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg,

PG 8.2.4

Regards,
Dan Gorman

On Jun 25, 2007, at 9:02 AM, Gregory Stark wrote:

> "Dan Gorman" <dgorman(at)hi5(dot)com> writes:
>
>> 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
>
> What version of Postgres did you say this was?
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2007-06-25 16:23:18 Re: PITR Backups
Previous Message Gregory Stark 2007-06-25 16:02:53 Re: PITR Backups