Thread: Completely Removing PostgreSQL

Completely Removing PostgreSQL

From
Amn Ojee Uw
Date:

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!


Re: Completely Removing PostgreSQL

From
Alvaro Herrera
Date:
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/



Re: Completely Removing PostgreSQL

From
Ron
Date:
On 7/31/23 07: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
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?



https://askubuntu.com/a/18807/69438

Only the config files are left.

--
Born in Arizona, moved to Babylonia.

Re: Completely Removing PostgreSQL

From
Adrian Klaver
Date:
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