Re: How do I recover from>> pg_xlog/0000000000000000 (log

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: alvherre(at)dcc(dot)uchile(dot)cl (Alvaro Herrera)
Cc: p(dot)willis(at)telus(dot)net (pw), pgsql-general(at)postgresql(dot)org
Subject: Re: How do I recover from>> pg_xlog/0000000000000000 (log
Date: 2004-10-20 00:16:08
Message-ID: 200410200016.i9K0G9hP011353@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henry Combrinck 2004-10-20 00:27:29 Where clause limited to 8 items?
Previous Message Alvaro Herrera 2004-10-19 23:56:46 Re: How do I recover from>> pg_xlog/0000000000000000 (log