PostgreSQL pg_upgrade 过程文档说明更新 - 插件、字典、同义词等文件说明

作者

digoal

日期

2021-08-05

标签

PostgreSQL , pg_upgrade

pg_upgrade是PG提供的大版本升级工具, 可以非常方便、高速的升级大版本, PG 15提供了大版本软件部署的一些文档说明更新:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5090d709f172ecd00b16b6e336c8c149a3f3d33d

安装old cluster已有的插件, 拷贝全文检索相关的自定义字典, 同义词等文件.

如果还有其他定制文件, 也需要拷贝过去.

+     Many extensions and custom modules, whether from  
+     <filename>contrib</filename> or another source, use shared object  
+     files (or DLLs), e.g., <filename>pgcrypto.so</filename>.  If the old  
+     cluster used these, shared object files matching the new server binary  
+     must be installed in the new cluster, usually via operating system  
+     commands.  Do not load the schema definitions, e.g., <command>CREATE  
+     EXTENSION pgcrypto</command>, because these will be duplicated from  
+     the old cluster.  (Extensions with available updates can be processed  
+     later using <literal>ALTER EXTENSION ... UPDATE</literal>.)  
+    </para>  
+   </step>  
+  
+   <step>  
+    <title>Copy custom full-text search files</title>  
+  
+    <para>  
+     Copy any custom full text search files (dictionary, synonym,  
+     thesaurus, stop words) from the old to the new cluster.  

PostgreSQL 许愿链接

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.

9.9元购买3个月阿里云RDS PostgreSQL实例

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.