公告ID（KYSA-202305-1041）
公告ID：KYSA-202305-1041
公告摘要：postgresql安全漏洞
等級(jí)：Low
發(fā)布日期：2023-05-30
詳細(xì)介紹
1.修復(fù)的CVE
·CVE-2020-1720
描述：PostgreSQL是Postgresql組織的一套自由的對(duì)象關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)。該系統(tǒng)支持大部分SQL標(biāo)準(zhǔn)并且提供了許多其他特性，例如外鍵、觸發(fā)器、視圖等。PostgreSQL中的‘ALTER ... DEPENDS ON EXTENSION’存在安全漏洞，該漏洞源于子命令未執(zhí)行授權(quán)檢查。攻擊者可利用該漏洞刪除對(duì)象（如函數(shù)、觸發(fā)器等），進(jìn)而導(dǎo)致數(shù)據(jù)庫(kù)損壞。以下產(chǎn)品及版本受到影響：PostgreSQL 12.2之前版本，11.7之前版本，10.12之前版本，9.6.17之前版本。
2.受影響的軟件包
·銀河麒麟高級(jí)服務(wù)器操作系統(tǒng) V10 SP1
·aarch64架構(gòu):
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架構(gòu):
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架構(gòu):
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.軟件包修復(fù)版本
·銀河麒麟高級(jí)服務(wù)器操作系統(tǒng) 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.修復(fù)方法
方法一：配置源進(jìn)行升級(jí)安裝
1.打開(kāi)軟件包源配置文件，根據(jù)倉(cāng)庫(kù)地址進(jìn)行修改。
倉(cāng)庫(kù)源地址：
銀河麒麟高級(jí)服務(wù)器操作系統(tǒng) 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.配置完成后執(zhí)行更新命令進(jìn)行升級(jí)，命令如下：
yum update Packagename
方法二：下載安裝包進(jìn)行升級(jí)安裝
通過(guò)軟件包地址下載軟件包，使用軟件包升級(jí)命令根據(jù)受影響的軟件包
列表進(jìn)行升級(jí)安裝, 命令如下：
yum install Packagename
3.升級(jí)完成后是否需要重啟服務(wù)或操作系統(tǒng)：
CVE-2020-1720:無(wú)需重啟操作系統(tǒng)與服務(wù)即可使漏洞修復(fù)生效。
5.軟件包下載地址
·銀河麒麟高級(jí)服務(wù)器操作系統(tǒng) 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
注：其他相關(guān)依賴包請(qǐng)到相同目錄下載
6.修復(fù)驗(yàn)證
使用軟件包查詢命令，查看相關(guān)軟件包版本是否與修復(fù)版本一致，如果版本一致，則說(shuō)明修復(fù)成功。
sudo rpm -qa | grep Packagename
