How To Install postgresql-12-debversion on Ubuntu 20.04
Introduction
In this tutorial we learn how to install postgresql-12-debversion
on Ubuntu 20.04.
What is postgresql-12-debversion
postgresql-12-debversion is:
Debian version numbers, used to version Debian binary and source packages, have a defined format, including specifications for how versions should be compared in order to sort them. This package implements a “debversion” type to represent Debian version numbers within the PostgreSQL database. This also includes operators for version comparison and index operator classes for creating indexes on the debversion type.
Version comparison uses the algorithm used by the Debian package manager, dpkg, using the implementation from libapt-pkg. This means that columns in tables using the debversion type may be sorted and compared correctly using the same logic as “dpkg –compare-versions”. It is also possible to create indexes on these columns.
postgresql-debversion implements the following features:
- The “debversion” type (internally derived from the “text” type)
- A full set of operators for version comparison (< <= = <> >= >) including commutator and negator optimisation hints
- Operator classes for btree and hash indexes
- The aggregate functions min() and max()
There are three methods to install postgresql-12-debversion
on Ubuntu 20.04. We can use apt-get
, apt
and aptitude
. In the following sections we will describe each method. You can choose one of them.
Install postgresql-12-debversion Using apt-get
Update apt database with apt-get
using the following command.
sudo apt-get update
After updating apt database, We can install postgresql-12-debversion
using apt-get
by running the following command:
sudo apt-get -y install postgresql-12-debversion
Install postgresql-12-debversion Using apt
Update apt database with apt
using the following command.
sudo apt update
After updating apt database, We can install postgresql-12-debversion
using apt
by running the following command:
sudo apt -y install postgresql-12-debversion
Install postgresql-12-debversion Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude
using the following command.
sudo aptitude update
After updating apt database, We can install postgresql-12-debversion
using aptitude
by running the following command:
sudo aptitude -y install postgresql-12-debversion
How To Uninstall postgresql-12-debversion on Ubuntu 20.04
To uninstall only the postgresql-12-debversion
package we can use the following command:
sudo apt-get remove postgresql-12-debversion
Uninstall postgresql-12-debversion And Its Dependencies
To uninstall postgresql-12-debversion
and its dependencies that are no longer needed by Ubuntu 20.04, we can use the command below:
sudo apt-get -y autoremove postgresql-12-debversion
Remove postgresql-12-debversion Configurations and Data
To remove postgresql-12-debversion
configuration and data from Ubuntu 20.04 we can use the following command:
sudo apt-get -y purge postgresql-12-debversion
Remove postgresql-12-debversion configuration, data, and all of its dependencies
We can use the following command to remove postgresql-12-debversion
configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-12-debversion
References
Summary
In this tutorial we learn how to install postgresql-12-debversion
package on Ubuntu 20.04 using different package management tools: apt
, apt-get
and aptitude
.