Thread: Completely Removing PostgreSQL
In my Debian 12, I have removed the following apps from my system by using the following commands:
sudo apt-get –purge remove postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib
sudo apt-get –purge remove postgresql postgresql-12 postgresql-client-common postgresql-common postgresql-contrib
and then used sudo apt autoremove to remove whatever was left dangling there. However, after using dpkg -l | grep postgres command, I get this?
dpkg -l | grep postgres
rc postgresql-12 12.15-1.pgdg120+1 amd64 The World's Most Advanced Open Source Relational Database
rc postgresql-15 15.3-1.pgdg120+1 amd64 The World's Most Advanced Open Source Relational Database
rc postgresql-client-common 250.pgdg120+1 all manager for multiple PostgreSQL client versions
rc postgresql-common 250.pgdg120+1 all PostgreSQL database-cluster manager
rc postgresql-pljava-common 1.6.4-2.pgdg120+1 all Java procedural language for PostgreSQL, config files
-----------------------------
The above clearly shows that dpkg, and therefore my Debian 12, still recognize the existence of these packages. When trying to remove them apt remove, it fails to find them.
How can I completely remove PostgreSQL-xx.xx from my system?
Thanks!
On 2023-Jul-31, Amn Ojee Uw wrote: > In my Debian 12, I have removed the following apps from my system by using > the following commands: > *dpkg -l | grep postgres* > rc postgresql-12 12.15-1.pgdg120+1 amd64 The > World's Most Advanced Open Source Relational Database > rc postgresql-15 15.3-1.pgdg120+1 amd64 The > World's Most Advanced Open Source Relational Database > rc postgresql-client-common 250.pgdg120+1 all > manager for multiple PostgreSQL client versions > rc postgresql-common 250.pgdg120+1 all > PostgreSQL database-cluster manager > rc postgresql-pljava-common 1.6.4-2.pgdg120+1 all > Java procedural language for PostgreSQL, config files This is lack of Debian knowledge, not Postgres' fault in any way . You just need to "apt purge" these packages, as "rc" status for a package in apt means "desired state=remove, status=conf-files", ie. the residual is just the config files that apt doesn't remove in case you want to reinstall the package later. You would have seen known this if you had looked at the dpkg -l header lines: Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name Version ... rc -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
In my Debian 12, I have removed the following apps from my system by using the following commands:
sudo apt-get –purge remove postgresql postgresql-15 postgresql-client-common postgresql-common postgresql-contrib sudo apt-get –purge remove postgresql postgresql-12 postgresql-client-common postgresql-common postgresql-contriband then used sudo apt autoremove to remove whatever was left dangling there. However, after using dpkg -l | grep postgres command, I get this?
dpkg -l | grep postgres
rc postgresql-12 12.15-1.pgdg120+1 amd64 The World's Most Advanced Open Source Relational Database
rc postgresql-15 15.3-1.pgdg120+1 amd64 The World's Most Advanced Open Source Relational Database
rc postgresql-client-common 250.pgdg120+1 all manager for multiple PostgreSQL client versions
rc postgresql-common 250.pgdg120+1 all PostgreSQL database-cluster manager
rc postgresql-pljava-common 1.6.4-2.pgdg120+1 all Java procedural language for PostgreSQL, config files-----------------------------
The above clearly shows that dpkg, and therefore my Debian 12, still recognize the existence of these packages. When trying to remove them apt remove, it fails to find them.
How can I completely remove PostgreSQL-xx.xx from my system?
https://askubuntu.com/a/18807/69438
Only the config files are left.
Born in Arizona, moved to Babylonia.
On 7/31/23 05:47, Amn Ojee Uw wrote: > In my Debian 12, I have removed the following apps from my system by > using the following commands: > > /*sudo apt-*//*get*//*–purge *//*remove*//*postgresql postgresql*//*-15*//*postgresql-client-common postgresql-common postgresql-contrib*//**//*sudoapt-*//*get*//*–purge *//*remove*//*postgresql postgresql*//*-12*//*postgresql-client-commonpostgresql-common postgresql-contrib*/ I believe this sudo apt-get –purge remove ... should be: sudo apt-get remove –purge ... or simpler sudo apt-get purge ... As it is you just remove(ed) the files except for the configuration files. > > and then used*sudo**apt autoremove* to remove whatever was left dangling > there. However, after using *dpkg -l | grep postgres* command, I get this? > > ** > > *dpkg -l | grep postgres* > rc postgresql-12 12.15-1.pgdg120+1 amd64 The > World's Most Advanced Open Source Relational Database > rc postgresql-15 15.3-1.pgdg120+1 amd64 The > World's Most Advanced Open Source Relational Database > rc postgresql-client-common 250.pgdg120+1 > all manager for multiple PostgreSQL client versions > rc postgresql-common 250.pgdg120+1 all > PostgreSQL database-cluster manager > rc postgresql-pljava-common 1.6.4-2.pgdg120+1 > all Java procedural language for PostgreSQL, config files > > ----------------------------- > > The above clearly shows that *dpkg*, and therefore my Debian 12, still > recognize the existence of these packages. When trying to remove them > *apt remove,* it fails to find them. > > How can I completely remove PostgreSQL-xx.xx from my system? > > > Thanks! > > -- Adrian Klaver adrian.klaver@aklaver.com