選擇 RDS for PostgreSQL 升級的主要版本 - Amazon Relational Database Service

本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。

選擇 RDS for PostgreSQL 升級的主要版本

主要版本升級可能包含無法與舊版資料庫回溯相容的變更。新功能可能導致現有的應用程式停止正確運作。因此,Amazon RDS 不會自動套用主要版本升級。若要執行主要版本升級,請手動修改資料庫。所有升級都務必要經過完整測試,以確認您的應用程式正常運作,再將升級套用至您的生產資料庫。進行 PostgreSQL 主要版本升級時,建議您遵循 如何為 RDS for Postgre 執行主要版本升級SQL 中描述的步驟。

當您將 PostgreSQL 單一可用區域資料庫執行個體或多可用區域資料庫執行個體部署升級到下一個主要版本時,任何與資料庫相關聯的僅供讀取複本也會升級到相同的下一個主要版本。在某些情況下,您可以在升級時跳到更高的主要版本。如果您的升級略過主要版本,僅供讀取複本也會升級至該目標主要版本。跳過其他主要版本直接升級至第 11 版存在某些限制。您可以按照 如何為 RDS for Postgre 執行主要版本升級SQL 所述的步驟中找到詳細資訊。

PostgreSQL 引擎升級時並不會升級大多數的 PostgreSQL 擴充功能。這些擴充功能必須單獨升級。如需詳細資訊,請參閱在 中升級 PostgreSQL 資料庫RDS的 PostgreSQL 延伸模組

您可以執行下列 AWS CLI 查詢,找出 RDS for PostgreSQL 資料庫可用的主要版本:

aws rds describe-db-engine-versions --engine postgres --engine-version your-version --query "DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}" --output text

下表總結了所有可用版本的查詢結果。版本編號上的星號 (*) 表示不再支援版本。如果目前版本不受支援,建議您升級至最新的次要版本升級目標,或該版本的其他可用升級目標之一。

目前來源版本 升級目標
17.5
17.4

17.5

17.3

17.517.4

17.2

17.517.417.3

17.1

17.517.417.3、17.2

16.9

17.5

16.8

17.517.4

16.7

17.517.417.3

16.8

16.6

17.517.417.3、17.2

16.816.7

16.5

17.517.417.317.217.1

16.816.716.6

16.4

17.517.417.317.217.1

16.816.716.616.5

16.3

17.517.417.317.217.1

16.816.716.616.516.4

16.2

17.517.417.317.217.1

16.816.716.616.516.416.3

16.1

17.517.417.317.217.1

16.816.716.616.516.416.316.2

15.13

17.5

16.9

15.12

17.4

16.916.8

15.13

15.11

17.3

16.916.816.7

15.1315.12

15.10

17.2

16.916.816.716.6

15.1315.1215.11

15.9

17.1

16.916.816.716.616.5

15.1315.1215.1115.10

15.8

16.916.816.716.616.516.4

15.1315.1215.1115.1015.9

15.7

16.916.816.716.616.516.416.3

15.1315.1215.1115.1015.915.8

15.6

16.916.816.716.616.516.416.316.2

15.1315.1215.1115.1015.915.815.7

15.5

16.916.816.716.616.516.416.316.216.1

15.1315.1215.1115.1015.915.815.715.6

15.4

16.916.816.716.616.516.416.316.216.1

15.1315.1215.1115.1015.915.815.715.615.5

15.3*

16.916.816.716.616.516.416.316.216.1

15.1315.1215.1115.1015.915.815.715.615.515.4

15.2*

16.916.816.716.616.516.416.316.216.1

15.1315.1215.1115.1015.915.815.715.615.515.4

14.18

17.5

16.9

15.13

14.17

17.4

16.8

15.1315.12

14.18

14.16

17.3

16.7

15.1315.1215.11

14.1814.17

14.15

17.2

16.6

15.1315.1215.1115.10

14.1814.1714.16

14.14

17.1

16.5

15.1315.1215.1115.1015.9

14.1814.1714.1614.15

14.13

16.4

15.1315.1215.1115.1015.915.8

14.1814.1714.1614.1514.14

14.12

16.3

15.1315.1215.1115.1015.915.815.7

14.1814.1714.1614.1514.1414.13

14.11

16.2

15.1315.1215.1115.1015.915.815.715.6

14.1814.1714.1614.1514.1414.1314.12

14.10

16.1

15.1315.1215.1115.1015.915.815.715.615.5

14.1814.1714.1614.1514.1414.1314.1214.11

14.9

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.10

14.8*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.7.*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.6*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.5*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.4*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.3*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.2*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

14.1*

15.1315.1215.1115.1015.915.815.715.615.515.4

14.1814.1714.1614.1514.1414.1314.1214.1114.1014.9

13.21

17.5

16.9

15.13

14.17

13.20

17.4

16.8

15.12

14.1814.17

13.21

13.19

17.3

16.7

15.11

14.1814.1714.16

13.2113.20

13.18

16.6

15.10

14.1814.1714.15

13.2113.2013.19

13.17

16.5

15.9

14.1814.1714.1514.14

13.2113.2013.1913.18

13.16

16.4

15.8

14.1814.1714.1514.1414.13

13.2113.2013.1913.1813.17

13.15

16.3

15.815.7

14.1814.1714.1514.1414.1314.12

13.2113.2013.1913.1813.1713.16

13.14

16.2

15.6

14.1814.1714.1514.1414.1314.1214.11

13.2113.2013.1913.1813.1713.1613.15

13.13

16.1

15.5

14.1814.1714.1514.1414.1314.1214.1114.10

13.2113.2013.1913.1813.1713.1613.1513.14

13.12

15.4

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1513.1413.13

13.11

15.3

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1513.1413.1313.12

13.10*

15.2

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.1213.11

13.9*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.1213.11

13.8*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.1213.11

13.7*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

13.6*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

13.5*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

13.4*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

13.3*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

13.2、13.1*

14.1814.1714.1514.1414.1314.1214.1114.1014.9

13.2113.2013.1913.1813.1713.1613.1413.1313.11

12.22

17.2

16.6

15.10

14.15

13.18

12.21

17.1

16.5

15.9

14.14

13.1813.17

12.22

12.20

16.4

15.8

14.13

13.1813.1713.16

12.2212.21

12.19

16.3

15.7

14.12

13.1813.1713.1613.15

12.2212.2112.20

12.18

16.2

15.6

14.11

13.1813.1713.1613.1513.14

12.2212.2112.2012.19

12.17

16.1

15.5

14.10

13.1813.1713.1613.1513.1413.13

12.2212.2112.2012.1912.18

12.16

15.4

14.9

13.1813.1713.1613.1513.1413.1313.12

12.2212.2112.2012.1912.1812.17

12.15

15.3

14.8

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.16

12.14*

15.2

14.7

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.13*

14.6

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.12*

14.5

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.11*

14.4

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.10*

14.2

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.9*

14.1

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.8*

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.7*

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

12.6*、12.5*、12.4*、12.3*、12.2*

13.1813.1713.1613.1513.1413.1313.1213.11

12.2212.2112.2012.1912.1812.1712.1612.15

11.22

16.1

15.5

14.10

13.13

12.17

11.22-RDS.20240418

* 不再支援此版本。