卸载apt-get 安装的PostgreSQL版本

embedded/2024/10/16 4:23:41/

文章目录

  • 卸载apt-get 安装的PostgreSQL版本
    • 查找已安装的PostgreSQL包
    • 卸载PostgreSQL:
    • 检查并删除残留文件
    • 验证卸载

卸载apt-get 安装的PostgreSQL版本

卸载通过apt-get安装的PostgreSQL 就版本,可以按照以下步骤进行。

查找已安装的PostgreSQL包

在卸载之前,建议先查找并确认已安装的PostgreSQL包及其版本。
可以使用以下命令来查找与PostgreSQL相关的所有已安装包:

dpkg -l | grep postgresql

例:

root@autodl-container-616f40a3b3-41cb82d9:~# dpkg -l | grep postgresql
ii  postgresql                    10+190ubuntu0.1     all                 object-relational SQL database (supported version)
ii  postgresql-10                 10.23-0ubuntu0.18.0 amd64               object-relational SQL database, version 10 server
ii  postgresql-client             10+190ubuntu0.1     all                 front-end programs for PostgreSQL (supported version)
ii  postgresql-client-10          10.23-0ubuntu0.18.0 amd64               front-end programs for PostgreSQL 10
ii  postgresql-client-common      190ubuntu0.1        all                 manager for multiple PostgreSQL client versions
ii  postgresql-common             190ubuntu0.1        all                 PostgreSQL database-cluster manager
ii  postgresql-server-dev-10      10.23-0ubuntu0.18.0 amd64               development files for PostgreSQL 10 server-side programming
ii  postgresql-server-dev-all     190ubuntu0.1        all                 extension build tool for multiple PostgreSQL versions

卸载PostgreSQL:

使用apt-get的–purge remove选项来卸载PostgreSQL及其配置文件。
通常apt-get卸载时不需要指定小版本号,因为它会卸载所有相关的PostgreSQL包。
不过,如果出于某种原因你需要更精确地指定版本,可能需要查找确切的包名(这通常包括版本号)。但大多数情况下,以下命令就足够了:

sudo apt-get --purge remove postgresql*

这个命令会卸载所有以“postgresql”开头的包,包括PostgreSQL服务器、客户端库、文档等。–purge选项会同时删除配置文件。

例:

root@autodl-container-616f40a3b3-41cb82d9:/usr/lib/postgresql# cd ~
root@autodl-container-616f40a3b3-41cb82d9:~# apt-get --purge remove postgresql*
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Note, selecting 'postgresql-10-pgrouting' for glob 'postgresql*'
Note, selecting 'postgresql-common' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgrouting-doc' for glob 'postgresql*'
Note, selecting 'postgresql-10-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-9.2-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-10-dirtyread' for glob 'postgresql*'
Note, selecting 'postgresql-pltcl' for glob 'postgresql*'
Note, selecting 'postgresql-10-asn1oid' for glob 'postgresql*'
Note, selecting 'postgresql-contrib-10' for glob 'postgresql*'
Note, selecting 'postgresql-server-dev-all' for glob 'postgresql*'
Note, selecting 'postgresql-plv8' for glob 'postgresql*'
Note, selecting 'postgresql-10-postgis-2.2-scripts' for glob 'postgresql*'
Note, selecting 'postgresql-10-unit' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgfincore' for glob 'postgresql*'
Note, selecting 'postgresql-10-prioritize' for glob 'postgresql*'
Note, selecting 'postgresql-10-postgis-scripts' for glob 'postgresql*'
Note, selecting 'postgresql-10-pldebugger' for glob 'postgresql*'
Note, selecting 'postgresql-10-mimeo' for glob 'postgresql*'
Note, selecting 'postgresql-9.5-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-10-python3-multicorn' for glob 'postgresql*'
Note, selecting 'postgresql-10-bgw-replstatus' for glob 'postgresql*'
Note, selecting 'postgresql-10-postgis-2.4' for glob 'postgresql*'
Note, selecting 'postgresql-10-amcheck' for glob 'postgresql*'
Note, selecting 'postgresql-10-jsquery' for glob 'postgresql*'
Note, selecting 'postgresql-filedump' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgmemcache' for glob 'postgresql*'
Note, selecting 'postgresql-10-postgis-2.4-scripts' for glob 'postgresql*'
Note, selecting 'postgresql-10-ogr-fdw' for glob 'postgresql*'
Note, selecting 'postgresql-10-pglogical' for glob 'postgresql*'
Note, selecting 'postgresql-10-postgis-2.3-scripts' for glob 'postgresql*'
Note, selecting 'postgresql-python3-multicorn' for glob 'postgresql*'
Note, selecting 'postgresql-postgis-java' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgrouting-scripts' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgsphere' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgtap' for glob 'postgresql*'
Note, selecting 'postgresql-doc-10' for glob 'postgresql*'
Note, selecting 'postgresql-python-multicorn' for glob 'postgresql*'
Note, selecting 'postgresql-10-cron' for glob 'postgresql*'
Note, selecting 'postgresql-all' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgmp' for glob 'postgresql*'
Note, selecting 'postgresql-9.3-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgq3' for glob 'postgresql*'
Note, selecting 'postgresql-10-plproxy' for glob 'postgresql*'
Note, selecting 'postgresql-7.4' for glob 'postgresql*'
Note, selecting 'postgresql-9.0-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-doc' for glob 'postgresql*'
Note, selecting 'postgresql-8.0' for glob 'postgresql*'
Note, selecting 'postgresql-10-debversion' for glob 'postgresql*'
Note, selecting 'postgresql-10' for glob 'postgresql*'
Note, selecting 'postgresql-10-q3c' for glob 'postgresql*'
Note, selecting 'postgresql-10-prefix' for glob 'postgresql*'
Note, selecting 'postgresql-10-slony1-2' for glob 'postgresql*'
Note, selecting 'postgresql-pgtap' for glob 'postgresql*'
Note, selecting 'postgresql-9.1' for glob 'postgresql*'
Note, selecting 'postgresql-9.3' for glob 'postgresql*'
Note, selecting 'postgresql-9.4' for glob 'postgresql*'
Note, selecting 'postgresql-9.5' for glob 'postgresql*'
Note, selecting 'postgresql-9.6' for glob 'postgresql*'
Note, selecting 'postgresql-10-plr' for glob 'postgresql*'
Note, selecting 'postgresql-client' for glob 'postgresql*'
Note, selecting 'postgresql-10-citus' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgextwlist' for glob 'postgresql*'
Note, selecting 'postgresql-10-plsh' for glob 'postgresql*'
Note, selecting 'postgresql-10-plv8' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgaudit' for glob 'postgresql*'
Note, selecting 'postgresql-plperl' for glob 'postgresql*'
Note, selecting 'postgresql-10-mysql-fdw' for glob 'postgresql*'
Note, selecting 'postgresql-9.6-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-10-rum' for glob 'postgresql*'
Note, selecting 'postgresql-hll' for glob 'postgresql*'
Note, selecting 'postgresql' for glob 'postgresql*'
Note, selecting 'postgresql-10-ip4r' for glob 'postgresql*'
Note, selecting 'postgresql-10-powa' for glob 'postgresql*'
Note, selecting 'postgresql-contrib' for glob 'postgresql*'
Note, selecting 'postgresql-10-slony1' for glob 'postgresql*'
Note, selecting 'postgresql-plpython3' for glob 'postgresql*'
Note, selecting 'postgresql-10-pgq-node' for glob 'postgresql*'
Note, selecting 'postgresql-server' for glob 'postgresql*'
Note, selecting 'postgresql-q3c' for glob 'postgresql*'
Note, selecting 'postgresql-plpython' for glob 'postgresql*'
Note, selecting 'postgresql-plr' for glob 'postgresql*'
Note, selecting 'postgresql-10-partman' for glob 'postgresql*'
Note, selecting 'postgresql-autodoc' for glob 'postgresql*'
Note, selecting 'postgresql-10-orafce' for glob 'postgresql*'
Note, selecting 'postgresql-10-pllua' for glob 'postgresql*'
Note, selecting 'postgresql-pltcl-10' for glob 'postgresql*'
Note, selecting 'postgresql-10-repack' for glob 'postgresql*'
Note, selecting 'postgresql-10-preprepare' for glob 'postgresql*'
Note, selecting 'postgresql-comparator' for glob 'postgresql*'
Note, selecting 'postgresql-9.4-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-pgsphere' for glob 'postgresql*'
Note, selecting 'postgresql-server-dev-10' for glob 'postgresql*'
Note, selecting 'postgresql-plperl-10' for glob 'postgresql*'
Note, selecting 'postgresql-9.1-repmgr' for glob 'postgresql*'
Note, selecting 'postgresql-10-similarity' for glob 'postgresql*'
Note, selecting 'postgresql-client-10' for glob 'postgresql*'
Note, selecting 'postgresql-plpython-10' for glob 'postgresql*'
Note, selecting 'postgresql-plpython3-10' for glob 'postgresql*'
Note, selecting 'postgresql-client-common' for glob 'postgresql*'
Note, selecting 'postgresql-10-python-multicorn' for glob 'postgresql*'
Note, selecting 'postgresql-10' instead of 'postgresql-contrib-10'
Package 'postgresql-7.4' is not installed, so not removed
Package 'postgresql-8.0' is not installed, so not removed
Package 'postgresql-9.1' is not installed, so not removed
Note, selecting 'postgresql-plperl-10' instead of 'postgresql-plperl'
Note, selecting 'postgresql-plpython-10' instead of 'postgresql-plpython'
Note, selecting 'postgresql-plpython3-10' instead of 'postgresql-plpython3'
Note, selecting 'postgresql-pltcl-10' instead of 'postgresql-pltcl'
Package 'postgresql-9.3' is not installed, so not removed
Package 'postgresql-9.4' is not installed, so not removed
Package 'postgresql-9.5' is not installed, so not removed
Package 'postgresql-9.6' is not installed, so not removed
Note, selecting 'postgresql-10-plr' instead of 'postgresql-plr'
Package 'postgresql-server' is not installed, so not removed
Package 'postgresql-postgis-java' is not installed, so not removed
Note, selecting 'postgresql-10-pgtap' instead of 'postgresql-pgtap'
Note, selecting 'postgresql-10-plv8' instead of 'postgresql-plv8'
Package 'postgresql-10-postgis-2.2-scripts' is not installed, so not removed
Package 'postgresql-10-postgis-2.3-scripts' is not installed, so not removed
Note, selecting 'postgresql-10-python-multicorn' instead of 'postgresql-python-multicorn'
Note, selecting 'postgresql-10-python3-multicorn' instead of 'postgresql-python3-multicorn'
Note, selecting 'postgresql-10-slony1-2' instead of 'postgresql-10-slony1'
Note, selecting 'postgresql-pgsphere' instead of 'postgresql-10-pgsphere'
Note, selecting 'postgresql-q3c' instead of 'postgresql-10-q3c'
Package 'postgresql-9.6-repmgr' is not installed, so not removed
Package 'postgresql-9.5-repmgr' is not installed, so not removed
Package 'postgresql-9.4-repmgr' is not installed, so not removed
Package 'postgresql-9.3-repmgr' is not installed, so not removed
Package 'postgresql-9.2-repmgr' is not installed, so not removed
Package 'postgresql-9.1-repmgr' is not installed, so not removed
Package 'postgresql-9.0-repmgr' is not installed, so not removed
Package 'postgresql-10-amcheck' is not installed, so not removed
Package 'postgresql-10-asn1oid' is not installed, so not removed
Package 'postgresql-10-bgw-replstatus' is not installed, so not removed
Package 'postgresql-10-citus' is not installed, so not removed
Package 'postgresql-10-cron' is not installed, so not removed
Package 'postgresql-10-debversion' is not installed, so not removed
Package 'postgresql-10-dirtyread' is not installed, so not removed
Package 'postgresql-10-ip4r' is not installed, so not removed
Package 'postgresql-10-jsquery' is not installed, so not removed
Package 'postgresql-10-mimeo' is not installed, so not removed
Package 'postgresql-10-mysql-fdw' is not installed, so not removed
Package 'postgresql-10-ogr-fdw' is not installed, so not removed
Package 'postgresql-10-orafce' is not installed, so not removed
Package 'postgresql-10-partman' is not installed, so not removed
Package 'postgresql-10-pgaudit' is not installed, so not removed
Package 'postgresql-10-pgextwlist' is not installed, so not removed
Package 'postgresql-10-pgfincore' is not installed, so not removed
Package 'postgresql-10-pglogical' is not installed, so not removed
Package 'postgresql-10-pgmemcache' is not installed, so not removed
Package 'postgresql-10-pgmp' is not installed, so not removed
Package 'postgresql-10-pgrouting' is not installed, so not removed
Package 'postgresql-10-pgrouting-doc' is not installed, so not removed
Package 'postgresql-10-pgrouting-scripts' is not installed, so not removed
Package 'postgresql-10-pgtap' is not installed, so not removed
Package 'postgresql-10-pldebugger' is not installed, so not removed
Package 'postgresql-10-pllua' is not installed, so not removed
Package 'postgresql-10-plproxy' is not installed, so not removed
Package 'postgresql-10-plr' is not installed, so not removed
Package 'postgresql-10-plsh' is not installed, so not removed
Package 'postgresql-10-plv8' is not installed, so not removed
Package 'postgresql-10-postgis-2.4' is not installed, so not removed
Package 'postgresql-10-postgis-2.4-scripts' is not installed, so not removed
Package 'postgresql-10-postgis-scripts' is not installed, so not removed
Package 'postgresql-10-powa' is not installed, so not removed
Package 'postgresql-10-prefix' is not installed, so not removed
Package 'postgresql-10-preprepare' is not installed, so not removed
Package 'postgresql-10-prioritize' is not installed, so not removed
Package 'postgresql-10-python-multicorn' is not installed, so not removed
Package 'postgresql-10-python3-multicorn' is not installed, so not removed
Package 'postgresql-10-repack' is not installed, so not removed
Package 'postgresql-10-repmgr' is not installed, so not removed
Package 'postgresql-10-rum' is not installed, so not removed
Package 'postgresql-10-similarity' is not installed, so not removed
Package 'postgresql-10-slony1-2' is not installed, so not removed
Package 'postgresql-10-unit' is not installed, so not removed
Package 'postgresql-autodoc' is not installed, so not removed
Package 'postgresql-comparator' is not installed, so not removed
Package 'postgresql-filedump' is not installed, so not removed
Package 'postgresql-hll' is not installed, so not removed
Package 'postgresql-pgsphere' is not installed, so not removed
Package 'postgresql-q3c' is not installed, so not removed
Package 'postgresql-contrib' is not installed, so not removed
Package 'postgresql-doc' is not installed, so not removed
Package 'postgresql-doc-10' is not installed, so not removed
Package 'postgresql-plperl-10' is not installed, so not removed
Package 'postgresql-plpython-10' is not installed, so not removed
Package 'postgresql-plpython3-10' is not installed, so not removed
Package 'postgresql-pltcl-10' is not installed, so not removed
Package 'postgresql-10-pgq-node' is not installed, so not removed
Package 'postgresql-10-pgq3' is not installed, so not removed
Package 'postgresql-all' is not installed, so not removed
The following packages were automatically installed and are no longer required:cron dctrl-tools distro-info-data iproute2 libatm1 libmnl0 libpq-dev libxslt1.1 libxtables12 logrotate lsb-release ssl-cert sysstat
Use 'apt autoremove' to remove them.
The following packages will be REMOVED:postgresql* postgresql-10* postgresql-client* postgresql-client-10* postgresql-client-common* postgresql-common*postgresql-server-dev-10* postgresql-server-dev-all*
0 upgraded, 0 newly installed, 8 to remove and 169 not upgraded.
After this operation, 26.5 MB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 45376 files and directories currently installed.)
Removing postgresql (10+190ubuntu0.1) ...
Removing postgresql-10 (10.23-0ubuntu0.18.04.2) ...
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of stop.
Removing postgresql-client (10+190ubuntu0.1) ...
Removing postgresql-client-10 (10.23-0ubuntu0.18.04.2) ...
Removing postgresql-server-dev-all (190ubuntu0.1) ...
Removing postgresql-server-dev-10 (10.23-0ubuntu0.18.04.2) ...
Removing postgresql-common (190ubuntu0.1) ...
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of stop.
Removing 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Removing postgresql-client-common (190ubuntu0.1) ...
(Reading database ... 43895 files and directories currently installed.)
Purging configuration files for postgresql-10 (10.23-0ubuntu0.18.04.2) ...
Dropping cluster main...
Purging configuration files for postgresql-client-common (190ubuntu0.1) ...
dpkg: warning: while removing postgresql-client-common, directory '/etc/postgresql-common' not empty so not removed
Purging configuration files for postgresql-common (190ubuntu0.1) ...
dpkg: warning: while removing postgresql-common, directory '/var/lib/postgresql' not empty so not removed
root@autodl-container-616f40a3b3-41cb82d9:~# 

检查并删除残留文件

卸载后,你可能还想检查并手动删除PostgreSQL可能留下的任何残留文件或目录。
这通常包括/etc/postgresql/(配置文件)和/var/lib/postgresql/(数据文件)目录。

例:

root@autodl-container-616f40a3b3-41cb82d9:~# ls -l /etc/postgresql-common
ls: cannot access '/etc/postgresql-common': No such file or directory
root@autodl-container-616f40a3b3-41cb82d9:~# ls -l /var/lib/postgresql
total 31864
-rw------- 1 postgres postgres     2812 Sep 28 08:56 logfile
drwxrwxr-x 7 postgres postgres      111 Sep 26 22:16 pgsql16
drwxrwxr-x 7 postgres postgres     4096 Sep 27 21:46 pgvector
drwxrwxr-x 6 postgres postgres     4096 Sep 26 21:30 postgresql-16.3
-rw-rw-r-- 1 postgres postgres 32616059 May  7 04:31 postgresql-16.3.tar.gz
root@autodl-container-616f40a3b3-41cb82d9:~# 

但是,由于–purge选项已经尝试删除了配置文件,这些目录可能已经被清空或不存在了。

验证卸载

可以使用dpkg -l | grep postgresql命令再次检查,以确保没有留下任何与PostgreSQL相关的包。
如果命令没有返回任何内容,说明PostgreSQL已经被成功卸载。

root@autodl-container-616f40a3b3-41cb82d9:~# dpkg -l | grep postgresql
root@autodl-container-616f40a3b3-41cb82d9:~# 

按照上述步骤操作后,你应该已经成功卸载了通过apt-get安装的PostgreSQL 10.23版本。


http://www.ppmy.cn/embedded/119410.html

相关文章

Solidity语言:重点学习Solidity编程语言,这是EVM上最常用的智能合约语言。

Solidity是一种面向合约的编程语言,用于在以太坊虚拟机(EVM)上编写智能合约。它是Solidity开发者在以太坊平台上创建智能合约的主要选择之一。 学习Solidity的重点包括以下几方面: 语法和数据类型:学习Solidity的基本…

Python 读取与处理出入库 Excel 数据实战案例(HTML 网页展示)

有如下数据,需要对数据合并处理,输出到数据库。 数据样例:👇 excel内容: 出入库统计表河北库.xlsx: 出入库统计表天津库.xlsx: 01实现过程 1、创建test.py文件,然后将下面代码复制到里面,最后…

EI会议推荐-往届已检索|第二届智能电网与电力系统国际会议(ICSGPS 2025)

第二届智能电网与电力系统国际会议(ICSGPS 2025)由上海交通大学、广西大学、武汉大学、武汉理工大学、湖南大学、中南大学、爱迩思出版社、ESBK学术中心联合支持,于2025年1月17日-20日在中国武汉举行。在本次会议上发表的文章将会被本次会议所…

深入解析Debian与Ubuntu:技术特点与用户使用指南

深入解析Debian与Ubuntu:技术特点与用户使用指南 引言 Debian和Ubuntu作为两大知名的Linux发行版,不仅在历史和理念上有所不同,在技术特点和用户使用方法上也各具特色。本文将深入解析它们的技术特点,并提供用户使用指南&#x…

小程序-使用npm包

小程序对 npm 的支持与限制 目前,小程序中已经支持使用 npm 安装第三方包,从而来提高小程序的开发效率。但是,在小程序中使用 npm 包有如下 3 个限制: 不支持依赖于 Node.js 内置库的包不支持依赖于浏览器内置对象的包不支持依赖…

如何区分这个ip是真实ip,不是虚假的ip

区分一个IP地址是真实IP还是虚假IP(伪造IP)是非常重要的,特别是在网络安全、数据采集和其他与IP相关的业务场景中。虚假IP(也称为伪造IP或假冒IP)可以通过多种方式被创建,如代理、VPN、或IP欺骗&#xff08…

【Godot4.3】自定义数列类NumList

概述 数列是一种特殊数组。之前写过等比、等差数列、斐波那契等数列的求取函数。今天就汇总到一起,并添加其他的一些数列,比如平方数、立方数、三角形数等。 这里我首先采用以前比较喜欢的静态函数库的写法,然后在其基础上改进为基于类继承…

【HarmonyOS】应用权限原理和封装

背景 在项目中,避免不了需要调用系统资源和系统能力,比如:日历读写、摄像头等。因此,需要了解对系统资源访问权限的申请方式方法。 授权方式 包括两种授权方式,分别是system_grant(系统授权) 和 user_grant(用户授权)…