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
|
| Список | 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
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 по дате отправления: