postgres mirroring (real-time)
Does anyone know of a good way of implementing postgres real-time mirroring?
Whether it's a program that's already out there or whether it is something
that can be done by the DBA? I know there is one in contrib called dbmirror
but does it actually work well (it seems to also require pgperl)
Thanks much
Sally
_________________________________________________________________
Express yourself with the new version of MSN Messenger! Download today -
it's FREE! http://messenger.msn.com/go/onm00200471ave/direct/01/
On Wed, May 05, 2004 at 03:17:02PM +0000, Sally Sally wrote:
Does anyone know of a good way of implementing postgres real-time
mirroring? Whether it's a program that's already out there or whether it is
something that can be done by the DBA? I know there is one in contrib
called dbmirror but does it actually work well (it seems to also require
pgperl)
Plenty of people are using it. It's not _exactly_ real time, though.
What do you mean by "real-time mirroring"?
If you are not yet in production and are looking for something
that'll be ready in the next six months, you might want to check out
the Slony-I project on gborg.postgresql.org. But even that is not
"real time", in that there is a gap between when a tuple is COMMITTED
on the primary node and when it appears on other nodes.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner