Re: How do I recover from>> pg_xlog/0000000000000000 (log - Mailing list pgsql-general

From Mike Nolan
Subject Re: How do I recover from>> pg_xlog/0000000000000000 (log
Date
Msg-id 200410200016.i9K0G9hP011353@gw.tssi.com
Whole thread Raw
In response to Re: How do I recover from>> pg_xlog/0000000000000000 (log  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: How do I recover from>> pg_xlog/0000000000000000 (log  (pw <p.willis@telus.net>)
List pgsql-general
> On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
>
> > I set up a cron job to pg_dump and gzip every hour and
> > dump any backup gz files older than 1 week.
>
> Huh ... be sure to keep some older backup anyway!  There was just
> someone on a list (this one?) whose last two weeks of backups contained
> no data (a guy with OpenACS or something).

Also, if you don't routinely test your backups every now and then,
how can you be sure they'll work when you NEED them to?
--
Mike Nolan


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: How do I recover from>> pg_xlog/0000000000000000 (log
Next
From: "Henry Combrinck"
Date:
Subject: Where clause limited to 8 items?