X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0478A9FB33C for ; Fri, 14 Jul 2006 14:43:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76468-03 for ; Fri, 14 Jul 2006 14:43:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id E99EF9FB33B for ; Fri, 14 Jul 2006 14:43:25 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id b2so257734nfe for ; Fri, 14 Jul 2006 10:43:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=e6CRBn/xTIX3E/Xajf1MlpsRVhTYzkWiD8fIzy3SI2IqTD9V1nF9Dx7tWCYeiTvxkCFFrlbYdRh0TyMiGxO6HnlzV4/rVqJ70hZ2NTfxaCmg7P4z1kaOQDrQKzgWvTyH7CuKw7H1ik7UvQukoI89PqeXuLlgiRnxHrmpwPk5a/w= Received: by 10.78.151.15 with SMTP id y15mr1829334hud; Fri, 14 Jul 2006 10:43:24 -0700 (PDT) Received: by 10.78.29.15 with HTTP; Fri, 14 Jul 2006 10:43:24 -0700 (PDT) Message-ID: Date: Fri, 14 Jul 2006 12:43:24 -0500 From: "Aaron Bono" To: "Spiegelberg, Greg" Subject: Re: *** How can I install two postgresqls in the same machine? ***** Cc: kitaeda , pgsql-admin@postgresql.org In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90126C421@POSTOFFICE.cranel.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31134_16711255.1152899004222" References: <82E74D266CB9B44390D3CCE44A781ED90126C421@POSTOFFICE.cranel.local> X-Google-Sender-Auth: 195bec10ca79bbe9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/119 X-Sequence-Number: 22365 ------=_Part_31134_16711255.1152899004222 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/14/06, Spiegelberg, Greg wrote: > > > We've also wrapped the psql command with our own script which takes a > database name as a parameter, determines what IP & port to connect to > and also determines the version of postgres running so the proper psql > client is invoked. I don't know if it's a must but you'll be warned if > you try to connect to a 8.1 using a 7.4 client. Care to share that script or at least show us how it works? This sounds like a great way to gradually upgrade applications to new database versions, especially when you have many clients on a machine and upgrade only some of them at a time. Thanks! Aaron ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com ================================================================== ------=_Part_31134_16711255.1152899004222 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/14/06, Spiegelberg, Greg <gspiegelberg@cranel.com> wrote:

We've also wrapped the psql command with our own script which takes a
database name as a parameter, determines what IP & port to connect to
and also determines the version of postgres running so the proper psql
client is invoked.  I don't know if it's a must but you'll be warned if
you try to connect to a 8.1 using a 7.4 client.

 
Care to share that script or at least show us how it works?  This sounds like a great way to gradually upgrade applications to new database versions, especially when you have many clients on a machine and upgrade only some of them at a time.

Thanks!
Aaron

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
================================================================== ------=_Part_31134_16711255.1152899004222--