From: Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
To: pgsql-admin@postgresql.org
Subject: Re: Fresh copy of a PG DB ?
Date: Fri, 28 Dec 2007 10:22:01 +0100
Message-ID: <20071228102201.6e6ae6e9@iridium.wars-nicht.de> (raw)
In-Reply-To: <4774BE99.9010602@tatm.com>
References: <4774BE99.9010602@tatm.com>
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
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: adsmail@wars-nicht.de
Subject: Re: Fresh copy of a PG DB ?
In-Reply-To: <20071228102201.6e6ae6e9@iridium.wars-nicht.de>
* 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