Re: Incremental Backups in postgres

Got it almost. Thanks a lot. One final question, please bear with me.

1. select pg_start_backup('label') ==> 10 AM
2. PGDATA folder backup ==> 10:05 AM
3. select pg_stop_backup => 10.10AM
4. The archiving will start writing files
5. If the disc crashes at 11AM, what will happen to the data between
10:10AM and 11:00AM, since we issued a pg_stop_backup at 10:10AM

Appreciate your help

Regards

On Wed, Nov 11, 2009 at 2:58 PM, Scott Mead
<scott(dot)lists(at)enterprisedb(dot)com> wrote:
>
> 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
>