From: Cédric Villemain <cedric.villemain@dalibo.com>
To: Pascal Heraud <heraud@tatm.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Fresh copy of a PG DB ?
Date: Fri, 28 Dec 2007 10:27:04 +0100
Message-ID: <4774C168.3090609@dalibo.com> (raw)
In-Reply-To: <4774BE99.9010602@tatm.com>
References: <4774BE99.9010602@tatm.com>
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.orgAttachments:cedric.villemain.vcf (text/x-vcard, 264B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cedric.villemain@dalibo.com, heraud@tatm.com
Subject: Re: Fresh copy of a PG DB ?
In-Reply-To: <4774C168.3090609@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox