Re: backup postgresql with snapshot AWS - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: backup postgresql with snapshot AWS
Date
Msg-id D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com
Whole thread Raw
In response to Re: backup postgresql with snapshot AWS  (flumbador@virgilio.it)
List 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
sharethe 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.




pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Re: Too many WAL archive files
Next
From: Peter Eisentraut
Date:
Subject: Re: Upgrade and re-synchronization with logical replication(pglogical and PG 10)