Re: Hot Backup

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

In response to

Responses

Browse pgsql-general by date

  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 "

Browse pgsql-hackers by date

  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