| From: | Bob Hatfield <bobhatfield(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Are file system level differential/incremental backups possible? |
| Date: | 2011-10-12 21:30:00 |
| Message-ID: | CAKikJc+B+B5sd97JstiDxiu58LsmgL_4jBoYHoW4YU0neJ3tFQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is it possible to do a full file system level backup of the data
directory, say once a week, and differentials or incrementals daily?
I'm wondering if there are files that would normally be removed that a
restore: Full then diff/inc would not remove and perhaps
corrupt/confuse things.
Process:
Saturday: Full backup (reset archive bits) of data dir with database shutdown
Sunday: Differential (don't reset archive bits) of data dir with
database shutdown
Monday: Differential (don't reset archive bits) of data dir with
database shutdown
Wednesday: Restore to test server using Saturday's Full and Monday's
Differential.
Obviously this works for regular files/file systems; however, I'm not
sure this is a good method with postgresql as the resulting data dir
*may* (?) contain extra files (or other issues)?
Note: our database is 850GB (Windows 2008 R2 pg version 8.3.12)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2011-10-12 21:40:05 | Re: Using constraint exclusion with 2 floats |
| Previous Message | Simon Riggs | 2011-10-12 21:23:05 | Re: pg 8.3 replication causing corruption |