Re: disk backups

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: disk backups
Дата
Msg-id 395B4DB6.4B745039@cupid.suninternet.com
обсуждение исходный текст
Ответ на disk backups  (mikeo <mikeo@spectrumtelecorp.com>)
Ответы Re: disk backups
Список pgsql-general
Stephen Lawrence Jr. wrote:
>
> I think the way most people do that is to have pg_dump or pg_dumpall make a
> dump of the databases into the postgres directory each nite. That way, when
> you do a full disk backup, the database dumps would be backed up as well.

Is there a better way? Here pg_dumping the DB takes over half an hour
(mainly because pg_dump chews all available memory). It would be nicer
if we knew that tarring it up would work also...

> ----- Original Message -----
> From: "mikeo" <mikeo@spectrumtelecorp.com>
> Subject: [GENERAL] disk backups
>
> > hi,
> >   would someone be so kind as to comment on restoring a database from
> > file backups?

--
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/

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

Предыдущее
От: Nico D
Дата:
Сообщение: ORDBMS vs OODBMS
Следующее
От: "Knut Aksel Røysland"
Дата:
Сообщение: Non-blocking LOCK