X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E7A79D1F6F7 for ; Fri, 20 Feb 2004 22:19:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 63375-06 for ; Fri, 20 Feb 2004 18:19:02 -0400 (AST) Received: from localhost.localdomain (webe.ne.client2.attbi.com [24.61.34.112]) by svr1.postgresql.org (Postfix) with ESMTP id C7489D1F74A for ; Fri, 20 Feb 2004 18:18:58 -0400 (AST) Received: from joem (klopfer.mazunetworks.com [4.19.249.110]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id i1KKrmBO028366; Fri, 20 Feb 2004 15:53:48 -0500 Date: Fri, 20 Feb 2004 15:53:17 -0500 To: Mitch Pirtle , jmaldonado@mail.webehosting.biz Subject: Re: database clustering Cc: pgsql-admin@postgresql.org Reply-To: jmaldonado@mail.webehosting.biz References: <403663E2.2090705@spacemonkeylabs.com> From: Joe Maldonado Content-Type: text/plain; format=flowed; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-ID: In-Reply-To: <403663E2.2090705@spacemonkeylabs.com> User-Agent: Opera7.23/Linux M2 build 518 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/319 X-Sequence-Number: 12493 I have looked at this and this is not what I was looking for. Using this the application will need to figure out how to merge records. I was looking to be able to use something like the oracle syntax of host:database:schema:table within sql to service the queries. -Joe On Fri, 20 Feb 2004 14:45:38 -0500, Mitch Pirtle wrote: > 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 -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/