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.lists@xxxxxxxxxxxxxxxx> wrote: > > On Wed, Nov 11, 2009 at 12:51 PM, akp geek <akpgeek@xxxxxxxxx> 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general