Re: Re: Is it possible to mirror the db in Postgres? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Re: Is it possible to mirror the db in Postgres?
Date
Msg-id 3AE17286.7778FB06@tm.ee
Whole thread Raw
In response to Re: Is it possible to mirror the db in Postgres?  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-hackers
Thomas Lockhart wrote:
> 
> > Joel Burton suggested the rserv utility. I don't know how well it would
> > work over a wide network.
> 
> It should work well over a WAN for what it can do. However, that is
> async one-way replication, which was not your initial requirement.
> 
> Of course, requirements sometimes adjust in the face of reality ;)

If it is a low-update mostly-analyze DB then updating on central db and 
then doing async one-way replication from there may be a good strategy.

-------------
Hannu


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Is it possible to mirror the db in Postgres?
Next
From: Peter Eisentraut
Date:
Subject: setuid(geteuid());?