Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 628C42E3117 for ; Fri, 28 Dec 2007 05:15:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 59246-07 for ; Fri, 28 Dec 2007 05:15:42 -0400 (AST) Received: from tatm.com (unknown [83.145.126.57]) by postgresql.org (Postfix) with ESMTP id AC89F2E3106 for ; Fri, 28 Dec 2007 05:15:44 -0400 (AST) X-MDSPF-Result: softfail (WWW4) Received-SPF: softfail (WWW4: domain of transitioning heraud@tatm.com does not designate 84.98.104.125 as permitted sender) x-spf-client=MDaemon.PRO.v8.1.1.R receiver=WWW4 client-ip=84.98.104.125 envelope-from= helo=[192.168.1.2] Received: from [192.168.1.2] (125.104.98-84.rev.gaoland.net [84.98.104.125]) by pilotage-modelisme.com (WWW4) (MDaemon.PRO.v8.1.1.R) with ESMTP id md50001338746.msg for ; Fri, 28 Dec 2007 10:15:34 +0100 Message-ID: <4774BE99.9010602@tatm.com> Date: Fri, 28 Dec 2007 10:15:05 +0100 From: Pascal Heraud User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Fresh copy of a PG DB ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Processed: WWW4, Fri, 28 Dec 2007 10:15:34 +0100 (not processed: message from valid local sender) X-Lookup-Warning: MAIL lookup on heraud@tatm.com does not match 84.98.104.125 X-MDRemoteIP: 84.98.104.125 X-Return-Path: heraud@tatm.com X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/227 X-Sequence-Number: 27744 Hello all, I want to have a fresh copy of my postgres database on another server in order to provide a simple mechanism of failover. My current solution is to backup the database every hour and re-create from scratch on the other side. Currently the database is small and its not an issue but when the size will be bigger, it can become an issue as you can guess :) What are the other solution to provide this service in a incremental manner ? Is there any "dupplication" tool or mechanism provided to allow such a repplication ? We looked at the way of using a replication solution but it seems very coupled to the version of the database we use. We are using PGSQL 8.2.4 on a Gentoo Linux OS. Thanks for any clue :) Pascal