What is the correct way to upgrade Postgres to 9.2.3?

(I would prefer not to have to delete/restore my databases if possible.)

# rpm -qi postgresql92-server
Name        : postgresql92-server          Relocations: (not relocatable)
Version     : 9.2.2                             Vendor: (none)
Release     : 1PGDG.rhel6                   Build Date: Mon 10 Dec 2012 07:41:24 GMT
Install Date: Thu 20 Dec 2012 02:49:30 GMT      Build Host: koji-sl6-x86-64-pg92
Group       : Applications/Databases        Source RPM: postgresql92-9.2.2-1PGDG.rhel6.src.rpm
Size        : 15648007                         License: PostgreSQL
Signature   : DSA/SHA1, Mon 10 Dec 2012 07:41:29 GMT, Key ID 1f16d2e1442df0f8
URL         : http://www.postgresql.org/
Summary     : The programs needed to create and run a PostgreSQL server
Description :
The postgresql92-server package includes the programs needed to create
and run a PostgreSQL server, which will in turn allow you to create
and maintain PostgreSQL databases.  PostgreSQL is an advanced
Object-Relational database management system (DBMS) that supports
almost all SQL constructs (including transactions, subselects and
user-defined types and functions). You should install
postgresql92-server if you want to create and maintain your own
PostgreSQL databases and/or your own PostgreSQL server. You also need
to install the postgresql package.

CentOS version:

# cat /etc/redhat-release
CentOS release 6.2 (Final)
  • We're missing some details. Which version of CentOS are you running? Can you provide the output of yum repolist and rpm -qi postgresql-server? – ewwhite Feb 7 '13 at 16:35
  • Thanks, I have added the info to the question above - if you need to know anything else just le me know. – A4J Feb 7 '13 at 16:48
  • The CORRECT way to upgrade any version of Postgres to any other version of Postgres is to read the release notes for each intermediate version, and follow the appropriate steps. The CentOS way may differ substantially from this, particularly if you're using their packages (and the latest version may simply not be available as a package yet), but that's where you should start... – voretaq7 Feb 7 '13 at 16:56
  • Hi Voretaq, could you kindly point out where the 'appropriate steps' are please? – A4J Feb 7 '13 at 17:09
  • That text in blue is a link. Click on it. – Michael Hampton Feb 7 '13 at 18:28

Answer from the #postgresql IRC channel:

yum upgrade postgresql92


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.