How To Install postgresql-10-debversion on Ubuntu 18.04
Introduction
In this tutorial we learn how to install postgresql-10-debversion on Ubuntu 18.04.
What is postgresql-10-debversion
postgresql-10-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-10-debversion on Ubuntu 18.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-10-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-10-debversion using apt-get by running the following command:
sudo apt-get -y install postgresql-10-debversion
Install postgresql-10-debversion Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install postgresql-10-debversion using apt by running the following command:
sudo apt -y install postgresql-10-debversion
Install postgresql-10-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-10-debversion using aptitude by running the following command:
sudo aptitude -y install postgresql-10-debversion
How To Uninstall postgresql-10-debversion on Ubuntu 18.04
To uninstall only the postgresql-10-debversion package we can use the following command:
sudo apt-get remove postgresql-10-debversion
Uninstall postgresql-10-debversion And Its Dependencies
To uninstall postgresql-10-debversion and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:
sudo apt-get -y autoremove postgresql-10-debversion
Remove postgresql-10-debversion Configurations and Data
To remove postgresql-10-debversion configuration and data from Ubuntu 18.04 we can use the following command:
sudo apt-get -y purge postgresql-10-debversion
Remove postgresql-10-debversion configuration, data, and all of its dependencies
We can use the following command to remove postgresql-10-debversion configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-10-debversion
References
Summary
In this tutorial we learn how to install postgresql-10-debversion package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.
