How To Install postgresql-14-pointcloud on Ubuntu 22.04
Introduction
In this tutorial we learn how to install postgresql-14-pointcloud
on Ubuntu 22.04.
What is postgresql-14-pointcloud
postgresql-14-pointcloud is:
LIDAR sensors quickly produce millions of points with large numbers of variables measured on each point. The challenge for a point cloud database extension is efficiently storing this data while allowing high fidelity access to the many variables stored.
Much of the complexity in handling LIDAR comes from the need to deal with multiple variables per point. The variables captured by LIDAR sensors varies by sensor and capture process. Some data sets might contain only X/Y/Z values. Others will contain dozens of variables: X, Y, Z; intensity and return number; red, green, and blue values; return times; and many more. There is no consistency in how variables are stored: intensity might be stored in a 4-byte integer, or in a single byte; X/Y/Z might be doubles, or they might be scaled 4-byte integers.
PostgreSQL Pointcloud deals with all this variability by using a “schema document” to describe the contents of any particular LIDAR point. Each point contains a number of dimensions, and each dimension can be of any data type, with scaling and/or offsets applied to move between the actual value and the value stored in the database. The schema document format used by PostgreSQL Pointcloud is the same one used by the PDAL library.
There are three methods to install postgresql-14-pointcloud
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-pointcloud 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-pointcloud
using apt-get
by running the following command:
sudo apt-get -y install postgresql-14-pointcloud
Install postgresql-14-pointcloud Using apt
Update apt database with apt
using the following command.
sudo apt update
After updating apt database, We can install postgresql-14-pointcloud
using apt
by running the following command:
sudo apt -y install postgresql-14-pointcloud
Install postgresql-14-pointcloud 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-pointcloud
using aptitude
by running the following command:
sudo aptitude -y install postgresql-14-pointcloud
How To Uninstall postgresql-14-pointcloud on Ubuntu 22.04
To uninstall only the postgresql-14-pointcloud
package we can use the following command:
sudo apt-get remove postgresql-14-pointcloud
Uninstall postgresql-14-pointcloud And Its Dependencies
To uninstall postgresql-14-pointcloud
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-pointcloud
Remove postgresql-14-pointcloud Configurations and Data
To remove postgresql-14-pointcloud
configuration and data from Ubuntu 22.04 we can use the following command:
sudo apt-get -y purge postgresql-14-pointcloud
Remove postgresql-14-pointcloud configuration, data, and all of its dependencies
We can use the following command to remove postgresql-14-pointcloud
configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-14-pointcloud
References
Summary
In this tutorial we learn how to install postgresql-14-pointcloud
package on Ubuntu 22.04 using different package management tools: apt
, apt-get
and aptitude
.