Postgres real time mirroring

Hi, some days ago i did some tests with a SQL Server in order to create a distributed enviorement based on distributors, publishers and so on. But, i mostly work with Linux and i´d like to know if exists some comercial or non comercial tool to make real time mirroring of a database with Postgresql servers.

Note: Ifam and Imon are not valid solutions.

Thanks!!

Yes there is. There is a current working solution for real time mirroring in Postgres. Note that this is a commercial solution. You would need to work with PostgreSQL Inc. to get it:

http://www.pgsql.com/

There are also several non commerical solutions, but they are quite difficult to setup, or are not full real time. Off the top of my head:

usogres

http://usogres.good-day.net/

There is also a "close to real time" solution as designed by Dr. Carter, that uses Heartbeat and rsync:

http://www.taygeta.com/ha-postgresql.html

There is also a tool called, "dbmirror" in the postgres source tree, under /contrib, but I have no experience with this and I think it is not real time mirroring.


The main userland replication tool is under development, but is not fully ready:

http://gborg.postgresql.org/project...projdisplay.php

Postgres replication is fully possible, but will take some work to get it going, it won't be seamless like a commerical product like SQLServer or Oracle.

One thing that you might find interesting, is that the .INFO registry runs on a Postgres replicated database, and the .ORG registry is moving to a Postgres replicated database.