Joe Maldonado wrote:
> Hello,
> I am planning a postgres database cluster. Each database will be on
> it's own machine and I wanted to enable one as the frontend to the
> rest. This is so that applications do not need to know which database
> contains what data. Is there a way to configure postgres to
> communicate to other dbs via sql so as to be transparent to the user?
> I know this can be done in Oracle though I'd rather not go through
> that experience if I do not need to.
Perhaps this is something that would benefit from the use of sql relay:
http://sqlrelay.sourceforge.net/
Very neat ideas, and might be another approach for your problem.
-- Mitch