pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Schiltknecht <markus@bluegap.ch>
To: anorganic anorganic <anorganicphc@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replication
Date: Thu, 04 Jan 2007 11:07:13 +0100
Message-ID: <459CD1D1.8010002@bluegap.ch> (raw)
In-Reply-To: <f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com>
References: <f616803e0701040100p5958ee2dy56924ee326c23e0d@mail.gmail.com>
	<459CC52A.4030208@bluegap.ch>
	<f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com>

Hi,

anorganic anorganic wrote:
 >> did you check the manual about 'High Availability and Load
 >> Balancing"?
 >> http://www.postgresql.org/docs/8.2/static/high-availability.html
 >
> yes but this was really short i think.

Interesting... where exactly is it to short for you? What else would you 
expect?

> I need that: s1 and s2 must be multimaster replication asyn. but make
> replication in real time. Changes are immediately send to second server.

Slony can probably be used for such a setup, although it's primarily 
designed for single master, async replication.

> OR: s1 is master s2 slave, s1 change some columns on s2, and s2 is 
> master s1
> slave and s2 change another columns in one time.

I don't quite follow what you mean here. I assume you mean rows, not 
columns. Then probably you mean something like what we call data 
partitioning, where each server is a master for a certain subset of the 
data.

> I read about slony but, it looks that's make changes not immediatly but in
> packages = not send one transaction but wait and send package. This 
> could be a problem.

Hm. If that really is a problem, think again about sync vs. async. In 
async replication, there is a delay by definition. But again, I'm not 
sure what Slony can do to minimize that delay.

> I hope slony online system is right for me. And these question
> about slony i have more than one i think it could be rigth way. Somebody 
> who run it could be great person for me :).

Probably ask on the slony mailing list. I'm not exactly a slony expert 
either.

Regards

Markus




view thread (63+ messages)  latest in thread

Message-ID: <459CD1D1.8010002@bluegap.ch>
Permalink:  ../459CD1D1.8010002@bluegap.ch/
Also on:    postgresql.org/message-id/459CD1D1.8010002@bluegap.ch

 · 

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: markus@bluegap.ch, anorganicphc@gmail.com
  Subject: Re: Replication
  In-Reply-To: <459CD1D1.8010002@bluegap.ch>
  References: <f616803e0701040100p5958ee2dy56924ee326c23e0d@mail.gmail.com> <459CC52A.4030208@bluegap.ch> <f616803e0701040140u18e27769r54ac39d79be29519@mail.gmail.com> <459CD1D1.8010002@bluegap.ch>

* 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