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 9DAF4D1E12D for ; Fri, 20 Feb 2004 19:45:44 +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 16600-04 for ; Fri, 20 Feb 2004 15:45:40 -0400 (AST) Received: from out008.verizon.net (out008pub.verizon.net [206.46.170.108]) by svr1.postgresql.org (Postfix) with ESMTP id AD2D6D1DDA5 for ; Fri, 20 Feb 2004 15:45:38 -0400 (AST) Received: from spacemonkeylabs.com ([68.161.140.190]) by out008.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20040220194539.FTVT10003.out008.verizon.net@spacemonkeylabs.com>; Fri, 20 Feb 2004 13:45:39 -0600 Message-ID: <403663E2.2090705@spacemonkeylabs.com> Date: Fri, 20 Feb 2004 14:45:38 -0500 From: Mitch Pirtle Organization: Spacemonkey Laboratories User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031115 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: jmaldonado@mail.webehosting.biz Cc: pgsql-admin@postgresql.org Subject: Re: database clustering References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Authentication-Info: Submitted using SMTP AUTH at out008.verizon.net from [68.161.140.190] at Fri, 20 Feb 2004 13:45:39 -0600 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/309 X-Sequence-Number: 12483 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