postgres mirroring (real-time)

[Sally Sally]

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/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Andrew Sullivan]

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 | aj*@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Andrew Sullivan]

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 | aj*@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)