From: Zach Bagnall [mailto:zach(dot)bagnall(at)bulletinwireless(dot)com]
Sent: Wednesday, January 04, 2006 4:42 AM
Subject: Re: [HACKERS] Incremental Backup Script
>Gregor: can you explain how to identify the current file? I had
>implemented a backup and restore script for PITR but stumbled at this
>point. The page above does not specify how this is to be done.
I have found a way from http://archives.postgresql.org/pgsql-admin/2005-10/msg00059.php. I have not tried it, but it seems straightforward.
>I appreciate the addition of PITR - it's better than nothing (nothing
>being full dumps) in some respects. Ideally, we need to be able to dump
>deltas for a single database.
Yes, it is not a replacement for an incremental backup, especially due to the fact that WALs may be orders of magnitude larger than a delta.
>In practice, restoration using the PITR
>method is awkward.
Yes, what I am planning to do:
1) drop the corrupted database
2) restore the base backup
3) replay all incremental backups (in the sense of my original mail)
LUCAS Product Development
Torex Retail Solutions GmbH
Schwedenstr. 9, D-13359 Berlin
Tel. +49 (0) 30 49901-243
Fax +49 (0) 30 49901-139
pgsql-hackers by date
|Next:||From: Stephen Frost||Date: 2006-01-04 11:51:02|
|Subject: Re: TRUNCATE, VACUUM, ANALYZE privileges|
|Previous:||From: Rick Gigger||Date: 2006-01-04 07:52:08|
|Subject: Re: Incremental Backup Script|