How To Install postgresql-14-periods on Ubuntu 22.04
Introduction
In this tutorial we learn how to install postgresql-14-periods on Ubuntu 22.04.
What is postgresql-14-periods
postgresql-14-periods is:
This extension attempts to recreate the behavior defined in SQL:2016 (originally SQL:2011) around periods and tables with SYSTEM VERSIONING. The idea is to figure out all the rules that PostgreSQL would like to adopt (there are some details missing in the standard) and to allow earlier versions of PostgreSQL to simulate the behavior once the feature is finally integrated.
There are three methods to install postgresql-14-periods on Ubuntu 22.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-14-periods 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-14-periods using apt-get by running the following command:
sudo apt-get -y install postgresql-14-periods
Install postgresql-14-periods Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install postgresql-14-periods using apt by running the following command:
sudo apt -y install postgresql-14-periods
Install postgresql-14-periods 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-14-periods using aptitude by running the following command:
sudo aptitude -y install postgresql-14-periods
How To Uninstall postgresql-14-periods on Ubuntu 22.04
To uninstall only the postgresql-14-periods package we can use the following command:
sudo apt-get remove postgresql-14-periods
Uninstall postgresql-14-periods And Its Dependencies
To uninstall postgresql-14-periods and its dependencies that are no longer needed by Ubuntu 22.04, we can use the command below:
sudo apt-get -y autoremove postgresql-14-periods
Remove postgresql-14-periods Configurations and Data
To remove postgresql-14-periods configuration and data from Ubuntu 22.04 we can use the following command:
sudo apt-get -y purge postgresql-14-periods
Remove postgresql-14-periods configuration, data, and all of its dependencies
We can use the following command to remove postgresql-14-periods configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-14-periods
References
Summary
In this tutorial we learn how to install postgresql-14-periods package on Ubuntu 22.04 using different package management tools: apt, apt-get and aptitude.