On Wed, Nov 11, 2009 at 12:51 PM, akp geek <[email protected]> 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
