Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9543747657D for ; Tue, 22 Oct 2002 10:34:38 -0400 (EDT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 0249447657C for ; Tue, 22 Oct 2002 10:34:38 -0400 (EDT) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18407G-0001UV-00 for ; Tue, 22 Oct 2002 10:34:42 -0400 Date: Tue, 22 Oct 2002 10:34:42 -0400 From: Andrew Sullivan To: "pgsql-general@postgresql.org" Subject: Re: Hot Backup Message-ID: <20021022103442.C4016@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , "pgsql-general@postgresql.org" References: <3DA323B1.3732.155CAB4F@localhost> <1034084444.6801.12.camel@camel> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <1034084444.6801.12.camel@camel>; from xzilla@users.sourceforge.net on Tue, Oct 08, 2002 at 09:40:44AM -0400 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/969 X-Sequence-Number: 31967 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. ). 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 M2P 2A8 +1 416 646 3304 x110