Re: Problem with Online-Backup - Mailing list pgsql-general

From Ron Johnson
Subject Re: Problem with Online-Backup
Date
Msg-id 45C2958D.3050702@cox.net
Whole thread Raw
In response to Re: Problem with Online-Backup  (Glen Parker <glenebob@nwlink.com>)
Responses Re: Problem with Online-Backup  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/01/07 18:04, Glen Parker wrote:
>> 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 :-)

Or you don't trust tape to be 100% reliable.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFwpWNS9HxQb37XmcRAtUhAKDavPVEGP4UiqNh8Wn4yM87+8YwGgCeJ0XM
QMLq3wgjA1LiVTi+a8xwkI0=
=xVi1
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Paul Lambert
Date:
Subject: Re: How to allow users to log on only from my application not from pgadmin
Next
From: truewise@hotmail.com
Date:
Subject: sqldetach (porting from Informix to PostgreSQL)