Re: what Linux to run - Mailing list pgsql-general

On 03/03/12 7:01 PM, Chris Travers wrote:
> On the negative, I have seen a yum-based upgrade between versions
> happily upgrade the binaries from 8.4.x to 9.0.x....

I haven't.

the PG 9.x yum packages not only have a different name, they install
into different directories.   here I have dead stock centos 6, with the
fedora epel and the postgres developers group 9.0 repositories added.
you can run several versions of postgresql side by side on different
ports and data directories..


# yum list postgres\*
Loaded plugins: auto-update-debuginfo, fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
  * base: mirror.san.fastserv.com
  * epel: linux.mirrors.es.net
  * extras: centos.mirrors.hoobly.com
  * updates: mirror.5ninesolutions.com
Installed Packages
postgresql90.x86_64                        9.0.7-1PGDG.rhel6
@pgdg90
postgresql90-contrib.x86_64                9.0.7-1PGDG.rhel6
@pgdg90
postgresql90-devel.x86_64                  9.0.7-1PGDG.rhel6
@pgdg90
postgresql90-libs.x86_64                   9.0.7-1PGDG.rhel6
@pgdg90
postgresql90-server.x86_64                 9.0.7-1PGDG.rhel6
@pgdg90
Available Packages
postgresql.i686                            8.4.9-1.el6_1.1
base
postgresql.x86_64                          8.4.9-1.el6_1.1
base
postgresql-contrib.x86_64                  8.4.9-1.el6_1.1
base
postgresql-devel.i686                      8.4.9-1.el6_1.1
base
postgresql-devel.x86_64                    8.4.9-1.el6_1.1
base
postgresql-docs.x86_64                     8.4.9-1.el6_1.1
base
postgresql-ip4r.x86_64                     1.05-1.el6
epel
postgresql-jdbc.x86_64                     8.4.701-3.el6
base
postgresql-libs.i686                       8.4.9-1.el6_1.1
base
postgresql-libs.x86_64                     8.4.9-1.el6_1.1
base
postgresql-odbc.x86_64                     08.04.0200-1.el6
base
postgresql-plparrot.x86_64                 0.04-5.el6
epel
postgresql-plperl.x86_64                   8.4.9-1.el6_1.1
base
postgresql-plpython.x86_64                 8.4.9-1.el6_1.1
base
postgresql-pltcl.x86_64                    8.4.9-1.el6_1.1
base
postgresql-server.x86_64                   8.4.9-1.el6_1.1
base
postgresql-test.x86_64                     8.4.9-1.el6_1.1
base
postgresql90-debuginfo.x86_64              9.0.7-1PGDG.rhel6
pgdg90
postgresql90-docs.x86_64                   9.0.7-1PGDG.rhel6
pgdg90
postgresql90-jdbc.x86_64                   9.0.802-1PGDG.rhel6
pgdg90
postgresql90-jdbc-debuginfo.x86_64         9.0.802-1PGDG.rhel6
pgdg90
postgresql90-libs.i686                     9.0.7-1PGDG.rhel6
pgdg90
postgresql90-odbc.x86_64                   09.00.0310-1PGDG.rhel6
pgdg90
postgresql90-odbc-debuginfo.x86_64         09.00.0310-1PGDG.rhel6
pgdg90
postgresql90-plperl.x86_64                 9.0.7-1PGDG.rhel6
pgdg90
postgresql90-plpython.x86_64               9.0.7-1PGDG.rhel6
pgdg90
postgresql90-pltcl.x86_64                  9.0.7-1PGDG.rhel6
pgdg90
postgresql90-python.x86_64                 4.0-2PGDG.rhel6
pgdg90
postgresql90-python-debuginfo.x86_64       4.0-2PGDG.rhel6
pgdg90
postgresql90-tcl.x86_64                    1.9.0-1.rhel6
pgdg90
postgresql90-tcl-debuginfo.x86_64          1.9.0-1.rhel6
pgdg90
postgresql90-test.x86_64                   9.0.7-1PGDG.rhel6
pgdg90
postgresql_autodoc.noarch                  1.40-1.rhel6
pgdg90

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast