How To Install postgresql-14-toastinfo on Ubuntu
Posted on April 1, 2023 (Last modified on May 20, 2023 )
2 minutes • 412 words
Introduction
In this tutorial we learn how to install postgresql-14-toastinfo on Ubuntu.
What is postgresql-14-toastinfo
postgresql-14-toastinfo is:
This PostgreSQL extension exposes the internal storage structure of variable-length datatypes, called varlena.
The function pg_toastinfo describes the storage form of a datum:
- null for NULLs
- ordinary for non-varlena datatypes
- short inline varlena for varlena values up to 126 bytes (1 byte header)
- long inline varlena, (un)compressed for varlena values up to 1GiB (4 bytes header)
- toasted varlena, (un)compressed for varlena values up to 1GiB stored in TOAST tables
The function pg_toastpointer returns a varlena’s chunk_id oid in the corresponding TOAST table. It returns NULL on non-varlena input.
There are three methods to install postgresql-14-toastinfo on Ubuntu. 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-toastinfo 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-toastinfo using apt-get by running the following command:
sudo apt-get -y install postgresql-14-toastinfo
Install postgresql-14-toastinfo Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install postgresql-14-toastinfo using apt by running the following command:
sudo apt -y install postgresql-14-toastinfo
Install postgresql-14-toastinfo 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-toastinfo using aptitude by running the following command:
sudo aptitude -y install postgresql-14-toastinfo
How To Uninstall postgresql-14-toastinfo on Ubuntu
To uninstall only the postgresql-14-toastinfo package we can use the following command:
sudo apt-get remove postgresql-14-toastinfo
Uninstall postgresql-14-toastinfo And Its Dependencies
To uninstall postgresql-14-toastinfo and its dependencies that are no longer needed by Ubuntu, we can use the command below:
sudo apt-get -y autoremove postgresql-14-toastinfo
Remove postgresql-14-toastinfo Configurations and Data
To remove postgresql-14-toastinfo configuration and data from Ubuntu we can use the following command:
sudo apt-get -y purge postgresql-14-toastinfo
Remove postgresql-14-toastinfo configuration, data, and all of its dependencies
We can use the following command to remove postgresql-14-toastinfo configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-14-toastinfo
Dependencies
postgresql-14-toastinfo have the following dependencies:
References
Summary
In this tutorial we learn how to install postgresql-14-toastinfo package on Ubuntu using different package management tools: apt, apt-get and aptitude.