Re: Fresh copy of a PG DB ?

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