Re: BAcking up a Postgres Database

Поиск
Список
Период
Сортировка
От Ragnar Kjørstad
Тема Re: BAcking up a Postgres Database
Дата
Msg-id 20010111090336.A21679@vestdata.no
обсуждение исходный текст
Ответ на BAcking up a Postgres Database  (D Johnson <dspectra@home.com>)
Список pgsql-admin
On Wed, Jan 10, 2001 at 05:57:21AM -0600, D Johnson wrote:
> Will the postgres community ever consider creating a decent backup
> capability. Currently the way to create backups is through a Cron job.
> For Postgres to ever be considered a true production systen then some
> sort of transactional tracing has to be done. Otherwise you risk the
> potential of losing quite a bit of data.


You can take a snapshot of the database-device (while the database is
down), and backup from the snapshot to avoid this problem.

You need a volum-manager that support snapshot, but AFAIK most do.



--
Ragnar Kjørstad
BigStorage

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

Предыдущее
От: "Dr. Hans-Christian Waldmann"
Дата:
Сообщение: Re: BAcking up a Postgres Database
Следующее
От: "Thomas Heller"
Дата:
Сообщение: FATAL 1: Memory exhausted in AllocSetAlloc()