Date: Sat, 29 Sep 2012 19:43:07 +0200 From: Axel Rau <Axel.Rau@chaos1.de> To: Palle Girgensohn <girgen@FreeBSD.org> Cc: freebsd-ports@freebsd.org, Alexander Pyhalov <alp@rsu.ru>, Chris Rees <utisoft@gmail.com>, pgsql@FreeBSD.org Subject: Re: Question about postgresql 9 and pg_upgrade Message-ID: <49D19A07-C83D-4966-B8DE-03D09CA42401@chaos1.de> In-Reply-To: <5066CEA3.1000803@FreeBSD.org> References: <4C985BA2.5060906@rsu.ru> <3000A63E-F860-45B1-B2C4-EAC7F0BF9BA3@Chaos1.DE> <CADLo83_t_=CaV_8UBUAK1WNoV3dDo8SH=BAhSMjAGELvxCjXAg@mail.gmail.com> <5066CEA3.1000803@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
=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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49D19A07-C83D-4966-B8DE-03D09CA42401>