| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Combined PITR/pg_dump backups? |
| Date: | 2008-01-02 17:42:32 |
| Message-ID: | 17192.1199295752@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Brian Hurt <bhurt(at)janestcapital(dot)com> writes:
> The question I have is: can I do both? Not as in "backing up the
> database twice", but as a combined process. What I'm thinking of is the
> following process:
> - I do normal WAL loging as in PITR.
> - When I want to start a backup, I do a pg_start_backup(...), like PITR.
> - Instead of taring up the files on the filesystem, I instead do a
> pg_dump
> - When the pg_dump completes, I do a pg_end_backup(), like PITR.
No, this will *not* work. You need an exact file-level image of the
database in order to do PITR restore against, and a pg_dump dump cannot
recreate that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Cocks | 2008-01-03 18:54:06 | Re: Setting a FK to look at only selected rows in the 'look-up' table... |
| Previous Message | Brian Hurt | 2008-01-02 17:32:51 | Combined PITR/pg_dump backups? |