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