Hi
I have a postgresql in Cloud AWS and I want to build the backup strategy described below.
The postgresql has PGDATA, Tablespace and XLOG on a Physical Volume, mapping a single EBS disk.
The WAL archive filesystem is on a separate Physical Volume, mapping a separate EBS disk.
OS is SLES 11sp4 and PG is 9.4
The Backup procedure is:
1) Start Backup
2) "AWS EBS Snapshot" of the Physical Volume containing PGDATA, Tablespace and XLOG
3) Stop Backup
4) "AWS EBS Snapshot" of the Physical Volume containing WAL archived
To allow PITR the WAL archive are also archived with a filesystem backup
Is someone using a similar backup strategy?
Are there tips or warning that I should be aware of?
Thanks & Regards
Gabriele Fagnani