pg_upgrade 版本升级

最新推荐文章于 2024-10-03 09:00:00 发布

rudy_gao

最新推荐文章于 2024-10-03 09:00:00 发布

阅读量2.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： postgresql 文章标签： postgresql

本文链接：https://blog.youkuaiyun.com/rudygao/article/details/51479211

本文详细介绍了如何使用pg_upgrade工具进行PostgreSQL的大版本升级，强调了小版本可以直接替换二进制文件而大版本需要通过导出与导入。pg_upgrade允许在不进行数据dump/reload的情况下升级数据，但要求内部存储格式不变。升级过程包括检查集群兼容性、初始化新数据库、修改配置、停用老库、执行pg_upgrade以及后续处理。在升级中需要注意数据完整性、兼容性检查以及符号链接的处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--对于小版本的升级，内部存储格式是兼容的，大版本不一定兼容
--小版本可以直接替换二进制文件，大版本需要导出与导入升级
Minor releases never change the internal storage format and are always compatible with earlier and later minor releases of the same major version number, e.g., 8.4.2 is compatible with 8.4,8.4.1 and 8.4.6. 
To update between compatible versions, you simply replace the executables while the server is down and restart the server. The data directory remains unchanged — minor upgrades are that simple.
For major releases of PostgreSQL, the internal data storage format is subject to change, thus complicating upgrades. The traditional method for moving data to a new major version is to dump and reload the
database, though this can be slow. A faster method is pg_upgrade. Replication methods are also available, as discussed below.

--在使用pg_dumpall进行长级时，注意要保持数据的完整性
If making a backup, make sure that your database is not being updated. This does not affect the integrity of the backup, but the changed data would of course not be included. 
If necessary, edit the permissions in the file pg_hba.conf (or equivalent) to disallow access from everyone except you



--pg_upgrade用于大版本的升级，但对于小版本的升级不起作用
pg_upgrade allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically req