Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id A55DB635CBD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 13:25:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 18863-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 13:25:40 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14])
	by mail.postgresql.org (Postfix) with ESMTP id 14A596352FB
	for <pgsql-admin@postgresql.org>; Fri, 13 Mar 2009 13:25:17 -0300 (ADT)
Received: from nSoft.lt (unknown [217.117.29.29])
	by vilnius.balt.net (Postfix) with ESMTP id 2B5EC3C4350;
	Fri, 13 Mar 2009 18:25:14 +0200 (EET)
Received: from [0.0.0.0] (unknown [192.168.16.104])
	by nSoft.lt (Postfix) with ESMTP id E525A130471;
	Fri, 13 Mar 2009 21:45:54 +0000 (GMT)
Message-ID: <49BA88E7.8010907@nsoft.lt>
Date: Fri, 13 Mar 2009 18:25:11 +0200
From: Julius Tuskenis <julius@nsoft.lt>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
To: Carol Walter <walterc@indiana.edu>
CC: pgsql-admin@postgresql.org
Subject: Re: Default instance?
References: <25E0EE71-B7A7-45F7-B5EF-EBE94F604ECB@indiana.edu>
In-Reply-To: <25E0EE71-B7A7-45F7-B5EF-EBE94F604ECB@indiana.edu>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/168
X-Sequence-Number: 31668

Hi, Carol.

just change  port number in both postgresql.conf files and restart both 
servers.


Carol Walter rašė:
> I'm upgrading my Postgres 8.2.4 instance to 8.3.6.  I will eventually 
> have two instances of 8.3.6, but for a time those databases that will 
> be migrated to the second 8.3.6 instance will need to stay on the 
> 8.2.4.  The 8.2.4 instance is running on port 5432 and the 8.3.6 
> instance is running on port 5433.  The 8.2 is the default instance.  
> Users who connect to it don't have to specify the port number, or the 
> location of the correct version of psql.  I will need to reverse these 
> so that the 8.3 instance is the default, and users who use the 8.2 
> instance will have to specify the port.  How do I make this change?
>
> Thanks,
> Carol
>
> PS  I'm on a Solaris 10 box.
>


-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050