什么是将Postgres升级到9.2.3的正确方法?
(如果可能,我宁愿不必删除/恢复我的数据库。)
# 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版本:
# cat /etc/redhat-release CentOS release 6.2 (Final)
从#postgresql IRC频道回答:
yum upgrade postgresql92