Re: Basic question on recovery and disk snapshotting

Поиск
Список
Период
Сортировка
От Jov
Тема Re: Basic question on recovery and disk snapshotting
Дата
Msg-id CADyrUxNceRYH4Gdu0M7t4RPD0tBjRSpkHh61-tKQzn7J33=9Pg@mail.gmail.com
обсуждение исходный текст
Ответ на Basic question on recovery and disk snapshotting  (Yang Zhang <yanghatespam@gmail.com>)
Ответы Re: Basic question on recovery and disk snapshotting
Список pgsql-general
Are you sure the EBS snapshot is consistent? if the snapshot is not consistent,enven on the same volume,you will have prolbems with your backup.

One methed can be try is run pg_start_backup() before take snapshot.




2013/4/27 Yang Zhang <yanghatespam@gmail.com>
We're running on EBS volumes on EC2.  We're interested in leveraging
EBS snapshotting for backups.  However, does this mean we'd need to
ensure our pg_xlog is on the same EBS volume as our data?

(I believe) the usual reasoning for separating pg_xlog onto a separate
volume is for performance.  However, if they are on different volumes,
the snapshots may be out of sync.

Thanks.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




--
Jov

В списке pgsql-general по дате отправления:

Предыдущее
От: Misa Simic
Дата:
Сообщение: Re: Optimizing bulk update performance
Следующее
От: Tobias Oberstein
Дата:
Сообщение: outgoing TCP from custom background worker?