Re: Fresh copy of a PG DB ?

From: Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fresh copy of a PG DB ?
Date: 2007-12-28 09:22:01
Message-ID: 20071228102201.6e6ae6e9@iridium.wars-nicht.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

On Fri, 28 Dec 2007 10:15:05 +0100 Pascal Heraud wrote:

> 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 ?

One solution is "Slony" to replicate tables to another database.
Or you can use PITR do copy every WAL logfile to your second machine
and apply all changes as far as you have logfiles.

> 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.

Uh? At least a replication with PITR is straightforward, some config
modifications, a script to archive the logfile, one to restore the
logfile and something to transfer the logfile to your other machine.
Basically, that should be all you need.
Not so long ago i created such a setup and the replication itself was
the easy part. It got much worse the time we had to integrate the
replication into RH cluster software.

Kind regards

--
Andreas 'ads' Scherbaum
German PostgreSQL User Group

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Cédric Villemain 2007-12-28 09:27:04 Re: Fresh copy of a PG DB ?
Previous Message Pascal Heraud 2007-12-28 09:15:05 Fresh copy of a PG DB ?