How to Install and Uninstall PostgreSQL on Debian 12

Complete step-by-step guide to properly install and completely remove PostgreSQL on Debian 12 with detailed explanations of each command.

PostgreSQL on Debian 12: Complete Install & Uninstall Guide

PostgreSQL on Debian 12: The Complete Installation and Removal Guide

Introduction

PostgreSQL is one of the most advanced open-source relational database systems available today. Whether you're setting up a development environment or managing production systems on Debian 12, understanding how to properly install and remove PostgreSQL is fundamental. This guide provides a comprehensive walkthrough of the entire process, explaining each command in detail.

System Preparation

Before installing any new software, it's crucial to update your package lists. This ensures you'll get the latest available versions and dependencies.

Updating Package Lists

The following command refreshes your local package index by fetching the latest information from all configured repositories: 
sudo apt update
This step typically requires sudo privileges as it needs to read system repositories. You'll be prompted for your password.

Installing PostgreSQL

Debian's package manager makes PostgreSQL installation straightforward. We'll install both the core database system and additional contributed packages.

Core Installation Command

This command installs the main PostgreSQL package along with additional utilities and extensions: 
sudo apt install postgresql postgresql-contrib -y
Breaking this down:
  • postgresql: The main database server package
  • postgresql-contrib: Additional utilities and extensions
  • -y: Automatically confirms installation prompts
The installation will:
  1. Download all necessary packages
  2. Configure the database cluster
  3. Create the postgres system user
  4. Set up the service to start automatically

Verifying the Installation

After installation, we should verify that PostgreSQL is running correctly.

Checking Service Status

This command shows the current status of the PostgreSQL service: 
sudo systemctl --no-pager status postgresql
Key things to look for in the output:
  • \\"active (running)\\" status
  • No error messages in the logs
  • Properly loaded configuration
The --no-pager option ensures the output displays directly in the terminal without requiring interaction.

Checking Version

Confirm which version was installed with: 
psql --version
This displays the installed PostgreSQL client version, which should match your server version.

Complete Removal of PostgreSQL

When you need to remove PostgreSQL, it's important to do so thoroughly to avoid leftover files that might cause issues with future installations.

Stopping the Service

First, we stop the running PostgreSQL service: 
sudo systemctl stop postgresql
This ensures no database processes are running during removal, preventing file locks or corruption.

Removing Packages

The following command removes PostgreSQL packages and purges their configuration files: 
sudo apt --purge remove postgresql postgresql-contrib -y
The --purge option is crucial as it removes configuration files along with the packages. Without it, configuration files would remain in /etc.

Cleaning Up Data Directories

Even after package removal, PostgreSQL leaves data directories that should be manually removed: 
sudo rm -rf /var/lib/postgresql /var/log/postgresql /etc/postgresql /etc/postgresql-common
This removes:
  • /var/lib/postgresql: Database storage
  • /var/log/postgresql: Log files
  • /etc/postgresql: Configuration files
  • /etc/postgresql-common: Shared configuration

Removing Dependencies

Finally, clean up any automatically installed dependencies that are no longer needed: 
sudo apt autoremove -y
This helps keep your system clean by removing packages that were installed as dependencies but are no longer required.

Conclusion

You've now learned how to properly install PostgreSQL on Debian 12 and completely remove it when needed. Remember that the removal process is destructive - all your databases will be permanently deleted. Always ensure you have proper backups before removing PostgreSQL from a production system. For most development environments, this complete removal process ensures a clean slate for future PostgreSQL installations or different database systems.

Subscribe to Our YouTube for More

Download as PDF

https://blog.arashtad.com/updates/how-to-install-and-uninstall-postgresql-on-debian-12/?feed_id=10792&_unique_id=685ca4efe56d0

Comments

Post a Comment

Popular posts from this blog

Why Smart Contracts Are Revolutionary? (Smart Contracts Use Cases)

Image
A smart contract is a program that runs when certain conditions are met on a blockchain. An automated agreement executes so that all parties can see its outcome immediately without involving an intermediary. In addition to automating workflows, smart contracts can also trigger the next action when conditions are met. This blog discusses how smart contracts are changing the world around us and the benefits they will bring to the market in the future. What is a Smart Contract? The terms of a smart contract can be established in the same way as those of any other contract. However, unlike traditional contracts, a smart contract is executed as code running on a blockchain, for example, Ethereum. From loans and insurance to logistics and gaming, it offer sophisticated peer-to-peer functionality backed by blockchain security, reliability, and accessibility. Types of Smart Contracts Here are some types of self-executing smart contracts. Smart Legal Contra...
Read more

A Quick Guide to Tron Network Interaction using Python.

Image
In our Previous article about sending TRC-20 Usdt we explained a little about the Tron network itself, why it is essential and how to send TRC-20 Usdt on Tron network. To make this happen, we first created an Account on shasta testnet. Then we asked for some testnet usdt from the Tron testnet faucet on Tron Discord. Finally transferred our Usdt using the Tronweb JavaScript library. In this tutorial, we will create an account on nile testnet (you can do the same for shasta testnet). Ask for some nile test Tron tokens from the very same faucet we got our shasta Usdt test tokens and then transfer them to another account. Notice that you can do the same on the mainnet, with the difference that there is no faucet and you need to buy the real TRX tokens from an exchange or wallet. Introduction to Tronix (TRX) token? Tronix (TRX) more commonly known as Tron is a token that powers the blockchain with the same name. In order to use Tron-based applications, you must purchase Tronix. For exam...
Read more

WordPress: The best CMS platform to create website

Image
The process of creating a new website can be challenging. You want to make sure it's something your customers will love, but you don't want the setup to take weeks or be so technical that you have to hire a developer to do every copy update. WordPress is probably the best solution you have come across in your research. It is a PHP-based content management system (CMS) with a MySQL database. Using it, you can create a wide variety of websites: from blogs to e-commerce to business websites and portfolios. You will learn everything you need to know about WordPress in this article. What is WordPress? In its simplest form, WordPress is the easiest to build your website or blog. In terms of technical terms, WordPress is a free, open-source content management system licensed under the GPLv2 license, meaning that anyone can use or modify it. A content management system allows you to manage critical aspects of your website - like content - without knowing anything about programming. Wo...
Read more