1. 修復的CVE

CVE-2021-3393

PostgreSQL 存在安全漏洞，攻擊者可利用該漏洞可以通過分區約束繞過對數據的訪問限制，以獲取敏感信息。

2. 受影響的操作系統及軟件包

·銀河麒麟桌面操作系統V10 SP1

x86_64 架構：

libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12

arm64 架構：

libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12

mips64el 架構：

libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12

loongarch64 架構：

libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12

3. 軟件包修復版本

·銀河麒麟桌面操作系統V10 SP1

12.9-0kylin0.20.04.1k1

4. 修復方法

方法一：配置源進行升級安裝

打開軟件包源配置文件，根據倉庫地址進行修改。

10.0 SP1:

http://archive.kylinos.cn/kylin/KYLIN-ALL 10.1 main restricted universe multiverse

配置完成后執行更新命令進行升級

$sudo apt update

$sudo apt install postgresql-12

方法二：下載軟件包進行升級安裝

通過軟件包地址下載軟件包，使用軟件包升級命令根據受影響的軟件包列表升級相關的組件包。

$sudo dpkg -i /Path1/Package1 /Path2/Package2 /Path3/Package3……

注：Path 指軟件包下載到本地的路徑，Package指下載的軟件包名稱，多個軟件包則以空格分開。

5. 軟件包下載地址

銀河麒麟桌面操作系統V10 SP1

x86_64軟件包下載地址

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_amd64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_amd64.deb

arm64軟件包下載地址

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_arm64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_arm64.deb

mips64el軟件包下載地址

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_mips64el.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_mips64el.deb

loongarch64軟件包下載地址

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

http://archive.kylinos.cn/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

6. 修復驗證

使用軟件包查詢命令，查看相關的軟件包版本大于或等于修復版本則成功修復。

$sudo dpkg -l |grep Package

注：Package為軟件包包名。