rpm centos 9.1.9 upgrade

From: dx k9 <bitsandbytes88(at)hotmail(dot)com>
To: posgres support <pgsql-admin(at)postgresql(dot)org>
Subject: rpm centos 9.1.9 upgrade
Date: 2013-06-11 20:27:56
Message-ID: SNT145-W77BB003E50B297B95F44FCD1850@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)myserver:~> pgsql -V
-bash: pgsql: command not found
postgres(at)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


Browse pgsql-admin by date

  From Date Subject
Next Message Alejandro Brust 2013-06-11 20:57:15 postgres 9.2 error whit apostrophes
Previous Message Viru Kanjilal 2013-06-10 17:30:05 How do you use PostgreSQL ?