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.
# cat /etc/redhat-release CentOS release 6.2 (Final)