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