Question about postgresql 9 and pg_upgrade

[Axel Rau]

-----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
> 
> 1. install new version to a chroot/jail
> 
> 2. stop postgres
> 
> 3. use pgupgrade and use chrooted installation as the new binary
> installation
> 
> 4. upgrade the "real" postgresql to the new major version
> 
> 5. start postgres
> 
> This is a bit of a hassle with the chroot stuff, but it should work in
> theory.
> 
> 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.
> 
> 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.
> 

As my server itself runs in a jail, this won't work, I think.

Axel
- ---
PGP-Key:29E99DD6  ☀ +49 151 2300 9283  ☀ computing @ chaos claudius

-----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=
=w8pQ
-----END PGP SIGNATURE-----