Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 24E379FBC1D for ; Wed, 30 May 2007 08:22:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 09345-07 for ; Wed, 30 May 2007 08:21:59 -0300 (ADT) X-Greylist: delayed 00:23:41.177673 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7D34A9FBB7C for ; Wed, 30 May 2007 08:22:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.dsa-ac.de (mail.dsa-ac.de [62.112.80.99]) by svr4.postgresql.org (Postfix) with ESMTP id 5B2625AF039 for ; Wed, 30 May 2007 10:58:20 +0000 (GMT) Received: from localhost (unknown [127.0.0.1]) by mail.dsa-ac.de (Postfix) with ESMTP id 339023D04F for ; Wed, 30 May 2007 10:58:14 +0000 (UTC) Received: from mail.dsa-ac.de ([127.0.0.1]) by localhost (mailserver [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09787-05; Wed, 30 May 2007 12:58:13 +0200 (CEST) Received: from [172.29.16.67] (PCPH.dsa-ac.de [172.29.16.67]) by mail.dsa-ac.de (Postfix) with ESMTP id 62E683C3E3 for ; Wed, 30 May 2007 12:58:13 +0200 (CEST) Message-ID: <465D58B3.6020408@dsa-ac.de> Date: Wed, 30 May 2007 12:57:55 +0200 From: Peter Hausmann User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.3) Gecko/20070326 Thunderbird/2.0.0.0 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Desaster Recovery from failover using SLONY-I Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at dsa-ac.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/314 X-Sequence-Number: 25634 Hi, After a node is dropped due to failover, it takes days to recover the database, because it is build up from scratch. We would prefer another approach: Make an Online Backup of the Provider database. The provider database continues writing new data and the Slony-Logs. The Backup is restored to the failed system. The slony cluster is dropped from the restored system and the system is defined as Slony-subscriber. How can we setup this system to recover from the status of the backup time? Thank you for any hint. -- Mit freundlichen Gruessen / With best regards Dipl.-Inform. Peter Hausmann DSA Daten- und Systemtechnik GmbH Pascalstrasse 28 D-52076 Aachen Germany Phone: +49 (0) 2408 / 9492- 779 Fax: +49 (0) 2408 / 9492- 92