Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4BB662E317B for ; Fri, 28 Dec 2007 05:30:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 24933-02-2 for ; Fri, 28 Dec 2007 05:29:55 -0400 (AST) Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id 375382E3355 for ; Fri, 28 Dec 2007 05:27:11 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id CAA2857806D; Fri, 28 Dec 2007 10:27:09 +0100 (CET) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Jui+LQcbXHKx; Fri, 28 Dec 2007 10:27:09 +0100 (CET) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id A0F2D578072; Fri, 28 Dec 2007 10:27:09 +0100 (CET) Received: from [192.168.0.11] (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by pyrrha.dalibo.net (Postfix) with ESMTP id EAC6357806D; Fri, 28 Dec 2007 10:27:06 +0100 (CET) Message-ID: <4774C168.3090609@dalibo.com> Date: Fri, 28 Dec 2007 10:27:04 +0100 From: =?ISO-8859-1?Q?C=E9dric_Villemain?= Organization: Dalibo User-Agent: Mozilla-Thunderbird 2.0.0.6 (X11/20071009) MIME-Version: 1.0 To: Pascal Heraud CC: pgsql-admin@postgresql.org Subject: Re: Fresh copy of a PG DB ? References: <4774BE99.9010602@tatm.com> In-Reply-To: <4774BE99.9010602@tatm.com> Content-Type: multipart/mixed; boundary="------------090003010609050008020808" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/229 X-Sequence-Number: 27746 This is a multi-part message in MIME format. --------------090003010609050008020808 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Pascal Heraud a écrit : > 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 ? Sure ! As ou can read in the doc, here : http://www.postgresql.org/docs/8.2/static/high-availability.html > > 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. You have not the lastest version wich is 8.2.5. You are running a production site on a Gentoo??? You need to replicate asap, sure ! > > Thanks for any clue :) > > Pascal > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org --------------090003010609050008020808 Content-Type: text/x-vcard; charset=utf-8; name="cedric.villemain.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="cedric.villemain.vcf" begin:vcard fn;quoted-printable:C=C3=A9dric Villemain n;quoted-printable:Villemain;C=C3=A9dric org:Dalibo email;internet:cedric.villemain@dalibo.com title:Consultant PostgreSQL tel;cell:+33 (0)6 74 15 56 53 x-mozilla-html:FALSE url:dalibo.com version:2.1 end:vcard --------------090003010609050008020808--