pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Help me find a suitable replication solution
Date: Thu, 5 Jul 2007 14:47:26 -0400
Message-ID: <20070705184726.GK17424@phlogiston.dyndns.org> (raw)
In-Reply-To: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com>
References: <91320d220707021715m7c2bc604ge274cdcf815ef018@mail.gmail.com>

On Tue, Jul 03, 2007 at 08:15:35AM +0800, Yuan HOng wrote:
> sites shall update these tables, and the link is over a WAN, it seems
> the most appropriate replication solution would be a multi-master,
> asynchronous solution.

Yes, that would be best.

> be to use a separate table for order on web server and replicate it
> back to inhouse server. But then I have two tables for order, which
> will make the applicate much complicated.

Yep.

> Finding no suitable soluiton for my case, I am wondering whether I
> have made a mistake in my database design. Havent' others experienced
> similiar situation as I do? Or do I have some misunderstanding of the
> capabilities of the existing solutions? Am I overlooking something?

There simply isn't anything that implements this now.  It's possible
to bodge it up using Slony, as you point out, but that makes things
more complicated.  If you need this now, though, that's your only
option AFAIK.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful 
than reformatting your hard drive when it gets out of whack.
		--Scott Morris



view thread (3+ messages)

Message-ID: <20070705184726.GK17424@phlogiston.dyndns.org>
Permalink:  ../20070705184726.GK17424@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20070705184726.GK17424@phlogiston.dyndns.org

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: Help me find a suitable replication solution
  In-Reply-To: <20070705184726.GK17424@phlogiston.dyndns.org>

* 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