pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.org

Attachments:

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

view thread (5+ messages)  latest in thread

Message-ID: <4774C168.3090609@dalibo.com>
Permalink:  ../4774C168.3090609@dalibo.com/
Also on:    postgresql.org/message-id/4774C168.3090609@dalibo.com

 · 

reply

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