Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40997=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UXdZO-0005fM-2s
	for pgsql-admin@arkaria.postgresql.org; Wed, 01 May 2013 20:24:06 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40997=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UXdZN-0000VM-J7
	for pgsql-admin@arkaria.postgresql.org; Wed, 01 May 2013 20:24:05 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UXdZM-0000UX-KK
	for pgsql-admin@postgresql.org; Wed, 01 May 2013 20:24:04 +0000
Received: from mail2.reptiles.org ([198.96.210.226])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UXdZK-0005Jf-Eg
	for pgsql-admin@postgresql.org; Wed, 01 May 2013 20:24:04 +0000
Received: from localhost by mailbox.reptiles.org
	via sendmail with STDIO (2337 bytes) (sender: <jim@reptiles.org>)
	(ident <jim> using UNIX) id <m1UXdZJ-000tAGC@mailbox.reptiles.org>
	for <pgsql-admin@postgresql.org>;
	Wed, 1 May 2013 16:24:01 -0400 (EDT)
	(Smail-3.2.0.121 2005-Nov-17 #10 built 2010-Jul-16)
Date: Wed, 1 May 2013 16:24:01 -0400
From: Jim Mercer <jim@reptiles.org>
To: Benjamin Krajmalnik <kraj@servoyant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installing multiple instances of Postgred on one
 FreeBSD server
Message-ID: <20130501202401.GA36654@reptiles.org>
References: <F4E6A2751A2823418A21D4A160B6898892BCE0@fletch.stackdump.local>
	<20130501202021.GA36302@reptiles.org>
	<F4E6A2751A2823418A21D4A160B6898892BCE2@fletch.stackdump.local>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <F4E6A2751A2823418A21D4A160B6898892BCE2@fletch.stackdump.local>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -4.5 (----)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Wed, May 01, 2013 at 02:21:44PM -0600, Benjamin Krajmalnik wrote:
> So essentially we would have to run jails on this - does that affect
> performance?

i would say minimal impact.

> 
> 
> -----Original Message-----
> From: Jim Mercer [mailto:jim@reptiles.org] 
> Sent: Wednesday, May 01, 2013 2:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Installing multiple instances of Postgred on one
> FreeBSD server
> 
> On Wed, May 01, 2013 at 01:58:21PM -0600, Benjamin Krajmalnik wrote:
> > I would like to install PG 9.2 on the same server and use Slony to 
> > replicate the databases, and once everything is up take the 9.0 
> > cluster down.
> 
> allocate a new ip to the server.
> reconfigure/restart 9.0 to listen on the main IP (not "all" as default)
> 
> use ezjail to create a freebsd jail on thenew IP
> 
> install 9.2 in the jail
> 
> treat it them as two servers.
> 
> point clients at new ip.
> 
> once migrated, delete all 9.0 from the main server.
> 
> if you need to upgrade again, add another jail.
> 
> stop and delete the old jail whe the next upgrade is complete.
> 
> repeat as often as you want to upgrade.
> 
> i'm pretty sure this can be adapted to linux, but i forget what their
> jail equivilent is.
> 
> the overhead is minimal
> 
> 
> 
> -- 
> Jim Mercer     Reptilian Research      jim@reptiles.org    +1 416
> 410-5633
> "He who dies with the most toys is nonetheless dead"

-- 
Jim Mercer     Reptilian Research      jim@reptiles.org    +1 416 410-5633
"He who dies with the most toys is nonetheless dead"


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin