From owner-freebsd-ports@FreeBSD.ORG Sat Sep 29 19:04:41 2012 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 386F9106566C; Sat, 29 Sep 2012 19:04:41 +0000 (UTC) (envelope-from Axel.Rau@Chaos1.DE) Received: from mailout4.lrau.net (mailout4.lrau.net [IPv6:2a02:d40:2:2::73]) by mx1.freebsd.org (Postfix) with ESMTP id B8B4D8FC0A; Sat, 29 Sep 2012 19:04:40 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=chaos1.de; s=email; h=To:References:Message-Id:Content-Transfer-Encoding:Cc:Date:In-Reply-To:From:Content-Type:Mime-Version:Subject; bh=9KAC/2oIrrOM2ofK3m4qt+uBGNHFQH1aWXai1C2ZGEs=; b=iY7zE8aFiuaN/f9pJLmVEhpjVRHrWAbhPtpWhsJP9aatTGD32mUPvYv/WzE3lGLe3h0V9J5P3O0ciVX4ULvfJ3hChJ6vJIrMkPbLZMBQjN9ZQfSZ5C5Fj7ncFgWUlWXHuYyy8bz4eEV5G+8jy10OYVfv192jTcj7MXrE3DRhmyM=; Received: from [91.216.35.74] (helo=imap.lrau.net) by mailout4.lrau.net with esmtp (Exim 4.80_DBL (FreeBSD)) (envelope-from ) id 1TI2LA-000NyR-D6; Sat, 29 Sep 2012 19:04:40 +0000 Received: from axel.rau@chaos1.de by imap.lrau.net (Archiveopteryx 3.1.4) with esmtpsa id 1348940601-68241-68240/7/78; Sat, 29 Sep 2012 17:43:21 +0000 Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: text/plain; charset=utf-8 From: Axel Rau In-Reply-To: <5066CEA3.1000803@FreeBSD.org> Date: Sat, 29 Sep 2012 19:43:07 +0200 Content-Transfer-Encoding: quoted-printable Message-Id: <49D19A07-C83D-4966-B8DE-03D09CA42401@chaos1.de> References: <4C985BA2.5060906@rsu.ru> <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> <5066CEA3.1000803@FreeBSD.org> To: Palle Girgensohn X-Pgp-Agent: GPGMail 1.3.3 X-Mailer: Apple Mail (2.1085) Cc: freebsd-ports@freebsd.org, Alexander Pyhalov , Chris Rees , pgsql@FreeBSD.org Subject: Re: Question about postgresql 9 and pg_upgrade X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Sep 2012 19:04:41 -0000 =2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 29.09.2012 um 12:34 schrieb Palle Girgensohn: > You should be able to install into a chrooted/jailed environment as per >=20 > 1. install new version to a chroot/jail >=20 > 2. stop postgres >=20 > 3. use pgupgrade and use chrooted installation as the new binary > installation >=20 > 4. upgrade the "real" postgresql to the new major version >=20 > 5. start postgres >=20 > This is a bit of a hassle with the chroot stuff, but it should work in > theory. >=20 > Or perhaps you could just take a package of the new postgresql version > and untar is somewhere. For pg_upgrade, all you need is both binaries > available at the same time on you hard disk. You could build the = package > somewhere else. >=20 > Sadly though, the wet dream if installing different versions side by > side has the draw back that it hard to come up with a scheme that won't > require current setups to migrate at upgrade, as Chris points out. >=20 As my server itself runs in a jail, this won't work, I think. Axel - --- PGP-Key:29E99DD6 =E2=98=80 +49 151 2300 9283 =E2=98=80 computing @ = chaos claudius =2D----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.19 (Darwin) Comment: GPGTools - http://gpgtools.org iQEcBAEBAgAGBQJQZzMyAAoJEMFz9+6bacTRM+oH/19S/o6TGvgkjcEp+aQn+AKb XvPqIiG8T05Lyb7o50dCp178VTgy4Iz/RqehhDNNy3No5Eb6u0ADXELIJ5f4yDbQ 2/PuFQw3mkD3GzeajF2KsgvdV3fVpu4qP3U0XnXaCjTVauuwIHwOq4/6eowclRtH 2gw+6Y+0yivOmAqm8yESdhVe0+aM87+YzH8ySDXJZavGBl7pu2MPvGJSDvf6QvRB LLnnknsmypHXlEQ9Q4RGRwCwKfZIkN/E5L3NsA1yRGZUChTtZFy44yo+JuIWK2Is lX5JudQjHrrpkPVr9EuiFONa4z4KMW6LWsSm/hjnViuzcWYEi8PZt78B6uEAJMk=3D =3Dw8pQ =2D----END PGP SIGNATURE-----