| 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: | Whole Thread | Raw Message | 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? |