From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Hot Backup |
Date: | 2002-10-22 14:34:42 |
Message-ID: | 20021022103442.C4016@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-22 14:36:57 | Re: IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough memory |
Previous Message | Tom Lane | 2002-10-22 14:31:09 | Re: problem with escaping " |
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB SD | 2002-10-22 14:35:46 | Re: autocommit vs TRUNCATE et al |
Previous Message | Andrew Sullivan | 2002-10-22 14:29:12 | Re: [HACKERS] Hot Backup |