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:

https://archive.cq-jq.com/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软件包下载地址

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_amd64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_amd64.deb

arm64软件包下载地址

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_arm64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_arm64.deb

mips64el软件包下载地址

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_mips64el.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-pltcl-12_12.9-0kylin0.20.04.1k1_mips64el.deb

loongarch64软件包下载地址

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg-compat3_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libecpg6_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpgtypes3_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/libpq5_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-client-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plperl-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/kylin/KYLIN-ALL/pool/main/p/postgresql-12/postgresql-plpython3-12_12.9-0kylin0.20.04.1k1_loongarch64.deb

https://archive.cq-jq.com/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为软件包包名。