PostgreSQL File System Based Backup Restartability - Mailing list pgsql-admin

From girish R G peetle
Subject PostgreSQL File System Based Backup Restartability
Date
Msg-id CAKKd065Vd-+5AZgc82XRpkefo28aGXpYtVrM7cWu7vgSgqEX9g@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL File System Based Backup Restartability
Re: PostgreSQL File System Based Backup Restartability
List pgsql-admin
Hi 
Is PostgreSQL file system based backup restart-ability possible ?

Steps
- Database size is 1 TB
- I'll execute pg_start_backup('label');
- I will traverse through the DATA directory to get the list of directories and files. 
- I will start moving the files to backup media. ( over network )
- When I'm half way (500GB done), network error happens. So movement of files is halted.
- Network issue is resolve after 30 minutes (In this time files might have got deleted or added with creation/deletion of database/tables )
- I'll resume moving the files to backup media from where it had halted.
- When movement of files is done, I'll execute pg_stop_backup()
- I'll move all the transaction logs that got archived to backup media.

Is PostgreSQL server recovery to a consistent state possible with backup content obtained from above steps ?


Thanks
Girish

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: tuning my db
Next
From: Albe Laurenz
Date:
Subject: Re: PostgreSQL File System Based Backup Restartability