|
yum install postgresql91-server didn't do the
trick to update 9.1.4 to 9.1.9.
The pgdg-91-centos.repo points to rhel, so maybe since we run centos 6.3 yum install command bombs when it can't find rhel. Maybe, yum doesn't know to look in /usr/pgsql-9.1. Maybe it was because my base version was 8.4.12. We did use yum install postgresql91-server to install 9.1.14 originally. ####################### [pgdg91] name=PostgreSQL 9.1 $releasever - $basearch baseurl=http://yum.postgresql.org/9.1/redhat/rhel-$releasever-$basearch enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG [pgdg91-source] name=PostgreSQL 9.1 $releasever - $basearch - Source failovermethod=priority baseurl=http://yum.postgresql.org/srpms/9.1/redhat/rhel-$releasever-$basearch enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG postgres@myserver:~> pgsql -V -bash: pgsql: command not found postgres@myserver:~> /usr/pgsql-9.1/bin/psql -V psql (PostgreSQL) 9.1.4 contains support for command-line editing ############################# In order to upgrade from 9.1.4 I'm planning on running rpm -U manually, It looks like centos uses the rhel rpms. postgresql91-contrib-9.1.9-1PGDG.rhel6.x86_64.rpm postgresql91-server-9.1.9-1PGDG.rhel6.x86_64.rpm I'm hoping it will install right over the current version in /usr/pgsql-9.1, but I'm not sure how to guarantee that in the rpm command, but I thought the default was /var/lib/pgsql/9.1/ . Thanks for any help/confirmations in advance, ~DjK |
