59、Zero-downtime Upgrades for PostgreSQL

最新推荐文章于 2025-10-22 09:32:07 发布

grape

最新推荐文章于 2025-10-22 09:32:07 发布

阅读量60

点赞数

CC 4.0 BY-SA版权

分类专栏： PostgreSQL 12高可用性实战指南文章标签： PostgreSQL zero-downtime upgrades pglogical

本文链接：https://blog.youkuaiyun.com/grape/article/details/150567060

PostgreSQL 12高可用性实战指南专栏收录该内容

60 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

Zero-downtime Upgrades for PostgreSQL

1. Simplified Table Registration

If all tables have primary keys, there’s an easier way to handle table registration. You can use the following function to automatically register every table in each schema with pglogical for the default replication set:

SELECT pglogical.replication_set_add_all_tables(
         set_name := 'default',
         schema_names := array_agg(nspname)
       )
  FROM schema_list;

2. Handling Sequences

2.1 Why Use pglogical for Sequences

Sequences are a primary reason to use pglogical for major PostgreSQL version upgrades. They are separate objects, often overlooked in logical replication as there are no insert, update, o