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






view thread (63+ messages)  latest in thread

Message-ID: <4210E27A.60203@olympus.net>
Permalink:  ../4210E27A.60203@olympus.net/
Also on:    postgresql.org/message-id/4210E27A.60203@olympus.net

 · 

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