1.修復的CVE ·CVE-2020-1720 描述：PostgreSQL是Postgresql組織的一套自由的對象關系型數據庫管理系統。該系統支持大部分SQL標準并且提供了許多其他特性，例如外鍵、觸發器、視圖等。PostgreSQL中的‘ALTER ... DEPENDS ON EXTENSION’存在安全漏洞，該漏洞源于子命令未執行授權檢查。攻擊者可利用該漏洞刪除對象（如函數、觸發器等），進而導致數據庫損壞。以下產品及版本受到影響：PostgreSQL 12.2之前版本，11.7之前版本，10.12之前版本，9.6.17之前版本。 2.受影響的軟件包 ·銀河麒麟高級服務器操作系統 V10 SP1 ·aarch64架構: postgresql、postgresql-contrib、postgresql-devel、postgresql-help、postgresql-libs、postgresql-plperl、postgresql-plpython3、postgresql-pltcl、postgresql-server、postgresql-static、postgresql-test、postgresql-test-rpm-macros ·mips64el架構: postgresql、postgresql-contrib、postgresql-devel、postgresql-help、postgresql-libs、postgresql-plperl、postgresql-plpython3、postgresql-pltcl、postgresql-server、postgresql-static、postgresql-test、postgresql-test-rpm-macros ·x86_64架構: postgresql、postgresql-contrib、postgresql-devel、postgresql-help、postgresql-libs、postgresql-plperl、postgresql-plpython3、postgresql-pltcl、postgresql-server、postgresql-static、postgresql-test、postgresql-test-rpm-macros 3.軟件包修復版本 ·銀河麒麟高級服務器操作系統 V10 SP1 (aarch64、mips64el、x86_64) postgresql-10.5-23.p02.ky10或以上版本 postgresql-contrib-10.5-23.p02.ky10或以上版本 postgresql-devel-10.5-23.p02.ky10或以上版本 postgresql-help-10.5-23.p02.ky10或以上版本 postgresql-libs-10.5-23.p02.ky10或以上版本 postgresql-plperl-10.5-23.p02.ky10或以上版本 postgresql-plpython3-10.5-23.p02.ky10或以上版本 postgresql-pltcl-10.5-23.p02.ky10或以上版本 postgresql-server-10.5-23.p02.ky10或以上版本 postgresql-static-10.5-23.p02.ky10或以上版本 postgresql-test-10.5-23.p02.ky10或以上版本 postgresql-test-rpm-macros-10.5-23.p02.ky10或以上版本 4.修復方法 方法一：配置源進行升級安裝 1.打開軟件包源配置文件，根據倉庫地址進行修改。 倉庫源地址： 銀河麒麟高級服務器操作系統 V10 SP1 aarch64:https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/ mips64el:https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/ x86_64:https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/ 2.配置完成后執行更新命令進行升級，命令如下： yum update Packagename 方法二：下載安裝包進行升級安裝 通過軟件包地址下載軟件包，使用軟件包升級命令根據受影響的軟件包 列表進行升級安裝, 命令如下： yum install Packagename 3.升級完成后是否需要重啟服務或操作系統： CVE-2020-1720:無需重啟操作系統與服務即可使漏洞修復生效。 5.軟件包下載地址 ·銀河麒麟高級服務器操作系統 V10 SP1 postgresql(aarch64)軟件包下載地址: https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-contrib-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-devel-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-help-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-libs-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-plperl-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-plpython3-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-pltcl-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-server-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-static-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-test-10.5-23.p02.ky10.aarch64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/aarch64/Packages/postgresql-test-rpm-macros-10.5-23.p02.ky10.aarch64.rpm postgresql(mips64el)軟件包下載地址: https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-contrib-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-devel-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-help-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-libs-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-plperl-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-plpython3-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-pltcl-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-server-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-static-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-test-10.5-23.p02.ky10.mips64el.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/mips64el/Packages/postgresql-test-rpm-macros-10.5-23.p02.ky10.mips64el.rpm postgresql(x86_64)軟件包下載地址: https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-contrib-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-devel-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-help-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-libs-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-plperl-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-plpython3-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-pltcl-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-server-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-static-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-test-10.5-23.p02.ky10.x86_64.rpm https://update.cs2c.com.cn/NS/V10/V10SP1.1/os/adv/lic/updates/x86_64/Packages/postgresql-test-rpm-macros-10.5-23.p02.ky10.x86_64.rpm 注：其他相關依賴包請到相同目錄下載 6.修復驗證 使用軟件包查詢命令，查看相關軟件包版本是否與修復版本一致，如果版本一致，則說明修復成功。 sudo rpm -qa | grep Packagename