#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2001
    Location
    Murcia
    Posts
    6
    Rep Power
    0

    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!!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13
    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/...rojdisplay.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.

IMN logo majestic logo threadwatch logo seochat tools logo