From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: Hot Backup
Date: Tue, 22 Oct 2002 10:34:42 -0400
Message-ID: <20021022103442.C4016@mail.libertyrms.com> (raw)
In-Reply-To: <1034084444.6801.12.camel@camel>
References: <3DA323B1.3732.155CAB4F@localhost>
<1034084444.6801.12.camel@camel>
On Tue, Oct 08, 2002 at 09:40:44AM -0400, Robert Treat wrote:
> Is it me or do doomsdays scenarios sometimes seem a little silly? I'd
Not if your contract requires five-nines reliablility and no more
than 180 minutes of downtime _ever_. Is five-nines realistic? For
most purposes, probably not, according to recent pronouncements (see,
e.g. <http://www.bcr.com/bcrmag/2002/05/p22.asp;). But it's in
lots of contracts anyway.
> like to ask just where are you storing your "incremental backups" with
> Oracle/m$ sql ?? If it's on the same drive, then when you drive craps
The more or less standard way of doing this is to stream the
PITR-required stuff to another device on another controller -- lots
of people stream to tape. People have been doing this for ages,
partly because disks used to be (a) expensive and (b) unreliable.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andrew@libertyrms.info, pgsql-general@postgresql.org
Subject: Re: Hot Backup
In-Reply-To: <20021022103442.C4016@mail.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox