| From: | "Steve Poe" <steve(dot)poe(at)gmail(dot)com> |
|---|---|
| To: | "Vivek Khera" <vivek(at)khera(dot)org> |
| Cc: | "Pgsql-General(at)Postgresql(dot)Org general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Fast backup/restore |
| Date: | 2006-10-17 18:35:15 |
| Message-ID: | 721b21dc0610171135p640d87ebg1654f345e4966a8c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)khera(dot)org> wrote:
>
>
> On Oct 17, 2006, at 10:43 AM, mengel(at)notes(dot)cc(dot)sunysb(dot)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.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2006-10-17 18:43:28 | Re: Fast backup/restore |
| Previous Message | Shane Ambler | 2006-10-17 18:09:02 | Re: Database users Passwords |