Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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)
share|improve this question
    
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

1 Answer 1

Answer from the #postgresql IRC channel:

yum upgrade postgresql92

share|improve this answer
    
Good answer, but you'll need to have correct PGDG repository package installed. –  Tometzky Feb 7 '13 at 22:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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