| From: | Rui DeSousa <rui(dot)desousa(at)icloud(dot)com> |
|---|---|
| To: | flumbador(at)virgilio(dot)it |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: backup postgresql with snapshot AWS |
| Date: | 2018-01-23 15:04:19 |
| Message-ID: | D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Yes the single EBS volume will work. As long as a filesystem only spans a single EBS volume and in your case they all share the same single EBS volume.
If each had there own volume; that too would work using multiple snapshots as one coherent backup.
i.e.
pg_start_backup()
take snapshot: /pgsql/pdbabe/data
take snapshot: /pgsql/pdbabe/tsdata
take snapshot: /pgsql/pdbabe/tsindex
take snapshot: /pgsql/pdbabe/tstemp
take snapshot: /pgsql/pdbabe/xlog
Pg_stop_backup()
And of course the associated WALs and future WALs.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2018-01-23 17:36:48 | Re: Upgrade and re-synchronization with logical replication (pglogical and PG 10) |
| Previous Message | pavan95 | 2018-01-23 13:35:22 | Re: Too many WAL archive files |