Re: Problem with Online-Backup

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem with Online-Backup
Date: 2007-02-02 00:04:44
Message-ID: 45C2801C.2080600@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Tarring hot database files still gives me the willies. But then, I
> wear belt and suspenders.

I understand. A list of "file changed while we read it" errors is just
a little unnerving at first!

I did quite a few end to end backup/PITR tests, and no matter what I did
to the DB during backup, no matter how many errors tar or cpio produced,
I have been unable to find any problems with the end result.

OTOH, I still take a full base backup every night and keep ten days
worth of WAL files on our backup server, so I guess maybe I don't
*completely* trust it :-)

-Glen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Walker 2007-02-02 00:22:07 Re: How to allow users to log on only from my application not from pgadmin
Previous Message Paul Lambert 2007-02-01 23:28:43 Re: How to allow users to log on only from my application not from pgadmin