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

How to Fix VMware’s “Could not open /dev/vmmon” Error on Ubuntu

You’ve recently installed VMware Workstation on your Ubuntu system and encountered the frustrating “Could not…

33 minutes ago

How to Fix Ubuntu 404 Errors While Fetching Dependencies

Have you ever found yourself staring at a terminal full of 404 errors while trying…

33 minutes ago

How to Fix ‘Please Install All Available Updates’ Error When Upgrading Ubuntu 18.04 to 20.04 LTS

One particularly frustrating error that many users face when trying to upgrade from Ubuntu 18.04 …

34 minutes ago

How to fix “Release is not valid yet” Error in Docker Containers

In the world of containerization, time synchronization issues can create unexpected roadblocks when working with…

34 minutes ago

How to fix “Externally Managed Environment” Pip Errors on Ubuntu

If you’ve recently upgraded to Ubuntu 23.04 or newer, you might have encountered a frustrating…

35 minutes ago

Ubuntu now officially supports NVIDIA Jetson: powering the future of AI at the edge

Canonical announces the General Availability of Ubuntu for the NVIDIA® Jetson Orin™ for edge AI…

8 hours ago