X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A9B5D9471 for ; Thu, 29 Sep 2005 06:31:29 -0300 (ADT) 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 39121-10 for ; Thu, 29 Sep 2005 09:31:22 +0000 (GMT) Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by svr1.postgresql.org (Postfix) with ESMTP id 63786D9414 for ; Thu, 29 Sep 2005 06:31:22 -0300 (ADT) Received: from frontend1.internal (mysql-sessions.internal [10.202.2.149]) by frontend1.messagingengine.com (Postfix) with ESMTP id 0B1ABCCF85C for ; Thu, 29 Sep 2005 05:31:25 -0400 (EDT) Received: from web3.messagingengine.com ([10.202.2.212]) by frontend1.internal (MEProxy); Thu, 29 Sep 2005 05:31:25 -0400 Received: by web3.messagingengine.com (Postfix, from userid 99) id 431B1BB27; Thu, 29 Sep 2005 05:31:25 -0400 (EDT) Message-Id: <1127986285.4281.244017516@webmail.messagingengine.com> X-Sasl-Enc: jWUilR5I9Q2+pndoDAbEfOTwX36dYjAEoVHjOE8qjL0B 1127986285 From: "W" To: pgsql-admin@postgresql.org Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MIME::Lite 1.5 (F2.73; T1.15; A1.64; B3.05; Q3.03) Subject: Database protection - restore to the point of failure Date: Thu, 29 Sep 2005 11:31:25 +0200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.059 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05, RAZOR2_CF_RANGE_51_100=1.485, RAZOR2_CHECK=0.15] X-Spam-Level: ** X-Archive-Number: 200510/16 X-Sequence-Number: 19088 Is it possible to do something like that (taken from Oracle world): I have two phisical disc (diskA and diskB). I would like to put: - database data files on diskA, - database WAL on diskA and diskB (dual logging), - database archive logs on diskA and diskB. With this kind of configuration, I could restore data in database to the point of any hard disk failure (assuming regular backups of database are beening done). Actually, if diskA fails, the procedure bellow should be done, if diskB fails, database should continue to operate normaly. So the recovery procedure would be something like this: - restore database, - apply archive logs, - apply WAL, - open/start database. Is this possible in PostgreSQL? Are there any other ways to achive same level of protection with PostgreSQL? WWeneto -- W wweneto@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin