From: | Sevo Stille <sevo(at)ip23(dot)net> |
---|---|
To: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Question about tape backup of online database. |
Date: | 2000-07-06 00:16:03 |
Message-ID: | 3963CFC3.4C1C409D@ip23.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Robert B. Easter" wrote:
>
> I'd like to know what hardware and software people use to perform tape backup
> of an online database on Linux. I would imagine the following might work(?):
>
> 1. Use RAID mirroring of the disk the db is on onto 2 two or more other
> disks.
> 2. When it is time to do the backup, disconnect one of the disks from the
> mirror and then dump the whole disk partition to a tape(s).
That won't do unless you take the database down for the disconnect - a
live database's file image may not be consistent over a backup. pg_dump
is the only supplied way to dump a live database.
> 3. Reconnect the disk back to the mirror and let it begin rebuilding.
>
> Right now, I don't even have SCSI! If you can tell me your setup and
> backup procedure, I'd be grateful.
If you do not want to take the database offline or save to a temporary
file, I'd suggest something like "mt rewind ; pg_dump -o -z >
/dev/tape". There is a new pg_dump/pg_restore out in beta now as
pg_backupXXX_latest on the PostgreSQL site which appears to be neater
than the dumper supplied in the PostgreSQL tarball.
Sevo
--
Sevo Stille
sevo(at)ip23(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Jennis | 2000-07-06 00:17:12 | Re: responses to licensing discussion |
Previous Message | Jeffery Collins | 2000-07-06 00:07:54 | Re: lztext and compression ratios... |