| From: | girish R G peetle <giri(dot)anamika0(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | PostgreSQL File System Based Backup Restartability |
| Date: | 2015-02-17 06:06:20 |
| Message-ID: | CAKKd065Vd-+5AZgc82XRpkefo28aGXpYtVrM7cWu7vgSgqEX9g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2015-02-17 10:56:57 | Re: PostgreSQL File System Based Backup Restartability |
| Previous Message | Scott Marlowe | 2015-02-16 16:55:15 | Re: tuning my db |