Completely Removing PostgreSQL

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/

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.

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*//**//*sudo apt-*//*get*//*–purge *//*remove*//*postgresql postgresql*//*-12*//*postgresql-client-common postgresql-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