X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 81DF832A126 for ; Thu, 7 Oct 2004 16:56:23 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10765-09 for ; Thu, 7 Oct 2004 15:56:05 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id B9965329F66 for ; Thu, 7 Oct 2004 16:56:04 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i97Fu4Jm013788 for ; Thu, 7 Oct 2004 15:56:04 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i97FTWah005245 for pgsql-admin@postgresql.org; Thu, 7 Oct 2004 15:29:32 GMT X-Newsgroups: comp.databases.postgresql.admin From: JEDIDIAH Subject: Re: Multiple WALs for PITR ? References: <28292295$109709783341646269224fa2.08260020@config19.schlund.de> Message-ID: User-Agent: slrn/0.9.8.0 (Linux) Date: Thu, 07 Oct 2004 10:29:31 -0500 Lines: 36 X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.19 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200410/144 X-Sequence-Number: 15137 On 2004-10-06, simon@2ndquadrant.com wrote: > > Michael Kleiser wrote on 06.10.2004, 16:29:08: >> I wan`t to use Point in Time Recovery >> I allread read http://developer.postgresql.org/docs/postgres/backup-online.html#BACKUP-ARCHIVING-WAL >> > > Good! > >> But I still wonder, if it is possible for PostgreSQL 8.0 to write multiple, redundant WAL-Files >> like Oracles with its redo-log-groups ? > > Not currently. > > That was something I considered, though in the end lacked both > implementation time and justification for. WAL archival is more decoupled from WAL generation. You can use this to exploit more IO parallelism so that the same disk isn't being written to and read from at the same time. Now, the concept of WAL groups would provide an extra level of redundancy for your crash recovery files. On some of the cheaper sort of systems that I've seen postgres deployed on this could be very useful. [deletia] -- Negligence will never equal intent, no matter how you attempt to distort reality to do so. This is what separates ||| the real butchers from average Joes (or Fritzes) caught up in / | \ events not in their control.