Skip site navigation (1) Skip section navigation (2)

Few questions on postgresql (dblink, 2pc, clustering)

From: Jim Worke <jimworke(at)inbox(dot)lv>
To: pgsql-general(at)postgresql(dot)org
Subject: Few questions on postgresql (dblink, 2pc, clustering)
Date: 2004-08-22 02:34:00
Message-ID: 200408221034.00573.jimworke@inbox.lv (view raw or flat)
Thread:
Lists: pgsql-general
Hi list,

My boss would like to convert from MySQL to PostgreSQL, but there are a few 
things that hold us back.

We'd like to have the databases in several physical servers, with referential 
integrity between the tables.  Reading from Oracle articles, their 
referential integrity can be done using their dblink and triggers.  What I'd 
like to ask is whether contrib/dblink is stable?  Seeing dblink in a contrib 
directory does bring a doubt (though we've read many success stories with 
dblink).  And can the Oracle's way of doing referential integrity be used in 
PostgreSQL?  Is it recommended to do that?

I've read the PostgreSQL's TODO list, and I can't find anything about 2-phase 
commit being implemented in 8.0.  Is this correct?  Because I also read 
there's a 2PC patch being implemented (http://snaga.org/pgsql/).  But 
progress seems to have stopped (correct me if I'm wrong).

Basically, our concern is that dblink, 2PC implementation are there, but not 
in the PostgreSQL mainstream.

Another thing that bothers us is that we can't find any multi-master 
clustering solution in PostgreSQL.  We're actually evaluating MySQL's own 
clustering solution, but it's production quality release is still slated for 
MySQL 5.0.

Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 2004-08-22 03:02:05
Subject: Re: Few questions on postgresql (dblink, 2pc, clustering)
Previous:From: Tom LaneDate: 2004-08-22 00:14:53
Subject: Re: Killing a session

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group