Re: replication - Mailing list pgsql-general

From Bruce Guenter
Subject Re: replication
Date
Msg-id 20000922093102.A1715@em.ca
Whole thread Raw
In response to Re: replication  (Elmar Haneke <elmar@haneke.de>)
Responses Re: replication  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Sep 22, 2000 at 09:58:24AM +0200, Elmar Haneke wrote:
> Adam Lang wrote:
> > Are there any type of replication features in postgresql 7.0?

I've been thinking that one way to emulate replication would be to run a
pgsql "shim" that would redirect queries to two back-ends
simultaneously, creating transactions for update commands, and aborting
when necessary.  The shim would be a long-running gateway process, that
could check for data consistency when it started up.  This is all off
the top of my head, so is this at all a reasonable idea?

I am running into a similar situation, where I want to set up two live
redundant sites, where nightly updates aren't an option.
--
Bruce Guenter <bruceg@em.ca>                       http://em.ca/~bruceg/

Attachment

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: one more word about rules
Next
From: Charles Sigler
Date:
Subject: Why does IE5 give me a "No suitable driver" error?