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 EE300D1E0C7 for ; Fri, 20 Feb 2004 15:03:18 +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 99105-06 for ; Fri, 20 Feb 2004 11:03:17 -0400 (AST) Received: from localhost.localdomain (webe.ne.client2.attbi.com [24.61.34.112]) by svr1.postgresql.org (Postfix) with ESMTP id 99A96D1E078 for ; Fri, 20 Feb 2004 11:03:11 -0400 (AST) Received: from joem (klopfer.mazunetworks.com [4.19.249.110]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id i1KF3iBO028042 for ; Fri, 20 Feb 2004 10:03:44 -0500 Reply-To: jmaldonado@mail.webehosting.biz To: pgsql-admin@postgresql.org Subject: database clustering From: Joe Maldonado Content-Type: text/plain; format=flowed; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Date: Fri, 20 Feb 2004 10:03:11 -0500 Message-ID: User-Agent: Opera7.23/Linux M2 build 518 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/298 X-Sequence-Number: 12472 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. Thanks, -Joe -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/