Re: backing up a PostGRES DB

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: backing up a PostGRES DB
Дата
Msg-id 6643.1238601943@sss.pgh.pa.us
обсуждение исходный текст
Ответ на backing up a PostGRES DB  (Richard Sickler <richard.sickler@avagotech.com>)
Список pgsql-admin
Richard Sickler <richard.sickler@avagotech.com> writes:
> The entire web app, (Tomcat and PostGRES), will be run in a virtual
> machine.  I was thinking about quiescing the DB, then copying the files that
> make up the virtual machine to some network attached backup store.  This
> will be done once a day.

This is really only attractive if you are prepared to *shut down* the
DB during the copy, not just "quiesce" it.  Otherwise there's
considerable risk of getting a corrupted copy.  Read the manual's
chapter about backup strategies.

            regards, tom lane

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

Предыдущее
От: "Scott Whitney"
Дата:
Сообщение: Re: backing up a PostGRES DB
Следующее
От: Félix Sánchez Rodríguez
Дата:
Сообщение: Without schemas