From: | Palle Girgensohn <girgen(at)pingpong(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, kudo(at)pingpong(dot)net |
Subject: | Re: lost data, possible playback? |
Date: | 2007-12-06 17:34:58 |
Message-ID: | 944C667FD85B40CE6350DB41@rambutan.pingpong.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
--On torsdag, december 06, 2007 12.22.45 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:
> Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
>> Is the real reason for the negative answer that there is a "hole" in the
>> pg_xlogs from 3 am - 9 am?
>
> That's half of it. The other half is that what you have from 3am is a
> pg_dump, not a filesystem-level snapshot of the database, and you'd need
> the latter to be able to replay the WAL log against.
OK, my assumptions where correct. Thanks.
/Palle
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-12-06 17:51:17 | Re: lost data, possible playback? |
Previous Message | Tom Lane | 2007-12-06 17:22:45 | Re: lost data, possible playback? |