Re: Incrementally Updated Backups

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Incrementally Updated Backups
Дата
Msg-id 201009112243.o8BMhJD23646@momjian.us
обсуждение исходный текст
Ответ на Re: Incrementally Updated Backups  (Gabe Nell <gabe@kikini.com>)
Ответы Re: Incrementally Updated Backups  ("J. Roeleveld" <joost@antarean.org>)
Список pgsql-general
Gabe Nell wrote:
> > That section has been removed from the current 9.0 docs because we are
> > unsure it works.
>
> Hmm. So the only way to make a consistent backup from a standby server
> is to shut down the standby first? Or is even that problematic?
>
> Would it change anything if we are able to guarantee that the
> filesystem is snapshotted as a point-in-time snapshot by using LVM or
> on Amazon EC2 by snapshotting an EBS volume?

I believe a snapshot of the standby is fine even if it is running, just
like on the master.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

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

Предыдущее
От: Gabe Nell
Дата:
Сообщение: Re: Incrementally Updated Backups
Следующее
От: sunpeng
Дата:
Сообщение: Fwd: how to write the sql if i want to find a geometry's d-distance neighbors?