Categories: Ubuntu

Uninstall the PostgreSQL on Ubuntu 22.04

PostgreSQL is one of the most popular database management systems. It’s a free and open-source software which is renowned for stability, performance, scalability, and security. Many applications and programming languages (Python, JavaScript, Ruby, C/C++, and more) support the PostgreSQL integration. Learn more about PostgreSQL.

In this guide, we will take a quick look at removing the PostgreSQL on Ubuntu 22.04.

Table of Contents

Toggle

Prerequisites:

To perform the steps in this guide, you need the following components:

Step 1: Finding the Installed PostgreSQL Packages

The default method of installing PostgreSQL on Ubuntu is through the APT package manager. The package source can be either the official Ubuntu package repo or the official PostgreSQL APT repo.

First, we check the list of installed packages that contains the term, postgres:

$ apt list –installed | grep postgres

Step 2: Uninstalling PostgreSQL Altogether

Notice that all the packages that are related to PostgreSQL start with the term, postgresql. Using this pattern, we can specify what packages to uninstall to the APT package manager.

Using the following command, we can easily remove all the PostgreSQL packages:

$ sudo apt autoremove –purge postgresql*

Here,

Sponsored
  • The APT package manager uninstalls any installed package that matches the described pattern.
  • All the associated dependency packages that are no longer used are also uninstalled at the same time.

Note that it removes all the installed versions of PostgreSQL. If you want to remove a specific version of PostgreSQL, we have to follow a more specific method.

Step 3: Uninstalling a Specific Version

Certain cluster setups may utilize multiple versions of PostgreSQL for compatibility reasons. In such an environment, removing all the PostgreSQL packages may not be suitable. In that case, we can remove a specific version of PostgreSQL.

By checking the list of installed PostgreSQL packages, we can easily determine the versions that are currently installed:

$ apt list –installed | grep postgresql-[09]

Here,

  • We grab the list of installed packages from APT.
  • The output is piped to grep and is filtered using the regular expression.

For reference, the release notes page lists all the available versions of PostgreSQL.

Now that we have a target, we can uninstall it using the following command:

$ sudo apt remove postgresql-version> postgresql-client-version>

Conclusion

We explored the various ways of uninstalling PostgreSQL on Ubuntu. We demonstrated on how to uninstall a specific version as well as uninstall PostgreSQL altogether from the system.

Interested in learning more about PostgreSQL? If you intend to use multiple versions of PostgreSQL on the same machine, you have to assign different ports for each database server. It’s also possible to integrate the PostgreSQL in Java apps using JDBC.

Ubuntu Server Admin

Recent Posts

Welcome to the Ubuntu Weekly Newsletter 883

Welcome to the Ubuntu Weekly Newsletter, Issue 883 for the week of March 9 –…

20 hours ago

How to Install nvidia-smi on Ubuntu or Debian Linux

In this article, we will see how to install nvidia-smi on Ubuntu or Debian Linux.…

1 day ago

How to Install clang tool on Ubuntu or Debian Linux

In this article, we will see how to install clang tool on Ubuntu or Debian…

2 days ago

How to resolve Ubuntu 20.04 Container Signature Errors on Raspberry Pi ARM Devices

When working with Docker containers on Raspberry Pi devices, you might encounter frustrating signature verification…

3 days ago

How to fix DNS Resolution Issues with OpenVPN on Ubuntu 18.04

You’ve recently upgraded to Ubuntu 18.04 and found that your OpenVPN connection no longer resolves…

3 days ago

How to Fix Ubuntu 18.04 System Monitor Launch Issues

Have you ever tried to open System Monitor on your Ubuntu 18.04 system only to…

4 days ago