471,108 Members | 1,264 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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

Nov 23 '05 #1
2 4371
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)

Nov 23 '05 #2
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)

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Miguel Guzman Miranda | last post: by
16 posts views Thread by Michal Hlavac | last post: by
reply views Thread by Sally Sally | last post: by
4 posts views Thread by Glen Eustace | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.