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

Re: database clustering

From: Mitch Pirtle <mitchy(at)spacemonkeylabs(dot)com>
To: jmaldonado(at)mail(dot)webehosting(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: database clustering
Date: 2004-02-20 19:45:38
Message-ID: 403663E2.2090705@spacemonkeylabs.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: Jeremy SmithDate: 2004-02-20 20:05:07
Subject: Re: "DELETE FROM" protection
Previous:From: Jeremy SmithDate: 2004-02-20 19:12:19
Subject: Re: PosgreSQL hogging resources?

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