Re: backup postgresql with snapshot AWS

Поиск
Список
Период
Сортировка
Искать
От
Rui DeSousa
Тема
Re: backup postgresql with snapshot AWS
Дата
Msg-id
D2F8D51E-F50F-42CF-B216-A3CE0161302E@icloud.com
Ответ на
Re: backup postgresql with snapshot AWS (flumbador@virgilio.it)
Список
Дерево обсуждения
backup postgresql with snapshot AWS flumbador@virgilio.it
Re: backup postgresql with snapshot AWS David Steele <david@pgmasters.net>
Re: backup postgresql with snapshot AWS Karl Denninger <karl@denninger.net>
Re: backup postgresql with snapshot AWS Rui DeSousa <rui.desousa@icloud.com>
Re: backup postgresql with snapshot AWS Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: backup postgresql with snapshot AWS Karl Denninger <karl@denninger.net>
Re: backup postgresql with snapshot AWS Rui DeSousa <rui.desousa@icloud.com>
Re: backup postgresql with snapshot AWS flumbador@virgilio.it
Re: backup postgresql with snapshot AWS Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: backup postgresql with snapshot AWS flumbador@virgilio.it
Re: backup postgresql with snapshot AWS Rui DeSousa <rui.desousa@icloud.com>
Re: backup postgresql with snapshot AWS Pritam Barhate <pritambarhate@gmail.com>
Re: backup postgresql with snapshot AWS Rui DeSousa <rui.desousa@icloud.com> 
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.
В списке pgsql-admin по дате отправления
Предыдущее
От: pavan95
Дата:
Сообщение: Re: Too many WAL archive files
Следующее
От: Peter Eisentraut
Дата:
FAQ