X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1289F55117 for ; Mon, 28 Feb 2005 23:57:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00618-02 for ; Mon, 28 Feb 2005 23:57:36 +0000 (GMT) Received: from mail0.lsil.com (mail0.lsil.com [147.145.40.20]) by svr1.postgresql.org (Postfix) with ESMTP id 2F559565B6 for ; Mon, 28 Feb 2005 23:57:31 +0000 (GMT) Received: from milmhbs0.lsil.com (mhbs.lsil.com [147.145.1.30]) by mail0.lsil.com (8.12.8/8.12.8) with ESMTP id j1SNt1Jg001288 for ; Mon, 28 Feb 2005 15:55:01 -0800 (PST) Received: from pop-gresham.gresham.lsil.com (pop-gresham.gresham.lsil.com [172.16.28.1]) by milmhbs0.lsil.com (8.12.11/8.12.11) with ESMTP id j1SNvWa1012615 for ; Mon, 28 Feb 2005 15:57:33 -0800 Received: from [172.16.194.177] (gr194p177.gresham.lsil.com [172.16.194.177]) by pop-gresham.gresham.lsil.com (8.12.11/8.12.11) with ESMTP id j1SNvWrj019234 for ; Mon, 28 Feb 2005 15:57:32 -0800 (PST) Message-ID: <4223AFEC.3050401@lsil.com> Date: Mon, 28 Feb 2005 15:57:32 -0800 From: Balaji Ganesan Organization: LSI Logic Corporation User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Running multiple postmaster instances in the same machine Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.39 X-Scanned-By: MIMEDefang 2.41 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/16 X-Sequence-Number: 16514 Hi, I'm trying to run multiple postmaster instances on the same machine. I want to start and stop the server from inside of my application. However, for each of these instances, I want to specify a different "storage cluster". I understand that I can do that while initializing (initdb -D ). But after I start multiple instances, how do I let psql know which server I'd like to connect to. Since they all run on the same port, whenever I run psql it only connects to the last server for which I called initdb on. Since psql doesn't take -D , I'm not sure how I can accomplish this. Any help is welcome. Thanks -BG