| From: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com> |
|---|---|
| To: | akp geek <akpgeek(at)gmail(dot)com> |
| Cc: | Alan Hodgson <ahodgson(at)simkin(dot)ca>, Greg Stark <gsstark(at)mit(dot)edu>, Jing Tan <jing(at)iheavy(dot)com>, Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Incremental Backups in postgres |
| Date: | 2009-11-11 19:58:50 |
| Message-ID: | d3ab2ec80911111158m2bb70654gb9de9deaa27772e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 11, 2009 at 12:51 PM, akp geek <akpgeek(at)gmail(dot)com> wrote:
> Hi All -
> I have read the document got a reasonable
> understanding of the WAL process. I have some confusion regarding the
> process.
>
> 1. I have set up the archiving process. Now the archive file are going
> to a different mount point.
> 2. I set up job to create a back up of the PGDATA directory
>
Before you backup PGDATA, you either need to stop the database or use
pg_start_backup('label');
After your backup, you would need to run: pg_stop_backup();
>
> Are the 2 above steps enough for recovery. My confusion is why we need
> to have Making a Base Backup. When you have time can you please
> clarify?
>
Remember, an 'incremental' backup is an increment to an original full
backup. That's why you need to make a backup of the PGDATA.
--Scott
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2009-11-11 20:23:07 | Re: Editor for sgml files |
| Previous Message | John R Pierce | 2009-11-11 19:05:32 | Re: Postgres Clustering Options |