Re: [GENERAL] Re: replication - Mailing list pgsql-general

From Jeff Hoffmann
Subject Re: [GENERAL] Re: replication
Date
Msg-id 383192A9.AA3E25C4@propertykey.com
Whole thread Raw
In response to Re: pgsql-general-digest V1 #529  (Manuel Cabido <manny@tinago.msuiit.edu.ph>)
Responses Re: [GENERAL] Re: replication  ("Aaron J. Seigo" <aaron@gtv.ca>)
List pgsql-general
"Aaron J. Seigo" wrote:

> >    I would like to inquire if with PostgreSQL 6.5.3.x I can put the same
> > database on two or more different Linux server such that each update will
> > be replicated on all database backends...
>
> right now, you can jury rig your own system up using network file systems,
> periodic updates of local filesystems, etc... this is limited in
> usefulness...

my favorite hack is to wrap the c/c++ api so you can set up a group of
mirror database connections and then calling the wrapped functions will
call the original function on each of the mirror database connections.
i've really never thought of it as something that should be part of the
library, though, since that's pretty easy to implement in the
application.

pgsql-general by date:

Previous
From: "Aaron J. Seigo"
Date:
Subject: Re: replication
Next
From: John Hyland
Date:
Subject: create type question again