From: Michael Klatt <lists.tcimk@olympus.net>
To: pgsql-admin@postgresql.org
Subject: Re: replication
Date: Mon, 14 Feb 2005 09:40:10 -0800
Message-ID: <4210E27A.60203@olympus.net> (raw)
In-Reply-To: <m3y8drpbcs.fsf@knuth.knuth.cbbrowne.com>
References: <1108378262.3800.51.camel@localhost.localdomain>
<m3y8drpbcs.fsf@knuth.knuth.cbbrowne.com>
Christopher Browne wrote:
> The world rejoiced as fred.blaise@excilan.com (Fred Blaise) wrote:
>
>>Hello
>>
>>I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
>>is a failover. I would like to implement a master-slave replication
>>process.
>>
>>I believe replication has been included in the base package since 7.3.x.
>>
>>Do you have any good pointers/how-to to direct me to?
>
>
> For such cases, I believe that Slony-I is the preferred solution these
> days. The comprehensive documentation may be found in CVS at gborg;
> it may be found online at the URL below.
Hi Christopher,
I've taken a look at Slony-I and found some limitations. Unless I'm
mistaken, Slony-I can't be used to replicate users/groups, and it must
be set up for each individual database. So, for a server where users
and databases are added and removed often, then it seems like Slony-I
may not be the best choice. For simply replicating data in a limited
number of databases, then Slony-I probably performs much better than
pgpool (which has many issues of its own).
We're considering using Slony-I for some applications (where performance
is an issue and user/databases don't change often) and pgpool for others
(where we just need everything replicated).
Michael
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: lists.tcimk@olympus.net
Subject: Re: replication
In-Reply-To: <4210E27A.60203@olympus.net>
References: <1108378262.3800.51.camel@localhost.localdomain> <m3y8drpbcs.fsf@knuth.knuth.cbbrowne.com> <4210E27A.60203@olympus.net>
* 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