From: Bruce Guenter <bruceg@em.ca>
To: pgsql-general@postgresql.org
Subject: Re: replication
Date: Fri, 22 Sep 2000 09:31:02 -0600
Message-ID: <20000922093102.A1715@em.ca> (raw)
In-Reply-To: <39CB1120.DBEC91AB@haneke.de>
References: <001d01c023ca$e37d9cc0$330a0a0a@Adam>
<39CB1120.DBEC91AB@haneke.de>
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/
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-general@postgresql.org
Cc: bruceg@em.ca
Subject: Re: replication
In-Reply-To: <20000922093102.A1715@em.ca>
* 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