How To Install postgresql-11-toastinfo on Debian 10

Learn how to install postgresql-11-toastinfo on Debian 10 with this tutorial. postgresql-11-toastinfo is Show storage structure of varlena datatypes in PostgreSQL

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.