| From: | Aditya <aditya(at)grot(dot)org> |
|---|---|
| To: | chulat(at)mail(dot)com |
| Cc: | sfpug(at)postgresql(dot)org |
| Subject: | Re: Backup suggestions |
| Date: | 2003-08-13 22:07:40 |
| Message-ID: | 20030813220740.GB39274@mighty.grot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
On Wed, Aug 13, 2003 at 02:16:35PM -0700, LN Cisneros wrote:
>
> Does anyone have recommendations for backing up a postgresql database on a nightly basis.
>
> My system:
>
> AMD XP 1800+
> Two IDE HDs (80GB ea.)
>
> Is there a good tape drive out there or some other recommendation?
>
> Size of database could be in gigabytes once all the different year's data is loaded.
use pg_dump and dump a table at a time to a file (or are you tables
multi-gigabytes big?) and then use rsync to copy it across the network to
another drive.
Aditya
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Alban | 2003-08-14 20:47:17 | SIG-BEER-WEST this Saturday 8/16 in San Francisco |
| Previous Message | David Fetter | 2003-08-13 21:19:53 | Re: Backup suggestions |