Re: Fast backup/restore

Поиск
Список
Период
Сортировка
От Steve Poe
Тема Re: Fast backup/restore
Дата
Msg-id 721b21dc0610171135p640d87ebg1654f345e4966a8c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fast backup/restore  (Vivek Khera <vivek@khera.org>)
Ответы Re: Fast backup/restore  (Vivek Khera <vivek@khera.org>)
Список pgsql-general
Vivek,

What methods of backup do you recommend for medium to large databases? In our example, we have a 20GB database and it takes 2 hrs to load from a pg_dump file.

Thanks.

Steve Poe

On 10/17/06, Vivek Khera <vivek@khera.org> wrote:

On Oct 17, 2006, at 10:43 AM, mengel@notes.cc.sunysb.edu wrote:

We just tar/gzip the entire data directory.  It takes all of 20 sec.  We've successfully restored from that also.  The machine you are restoring to *must* be running the save version of postgresql you backed up from.  

If you successfully backed up in 20 seconds, then you have a tiny DB.  Also, if you successfully restored from that style backup, your DB must not be written to much, or you were extremely lucky to get a consistent state.



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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Database users Passwords
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Fast backup/restore