将 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)
答案1
来自#postgresql IRC 频道的回答:
yum upgrade postgresql92