How To Install root-sql-pgsql on CentOS 8
Introduction
In this tutorial we learn how to install root-sql-pgsql on CentOS 8.
What is root-sql-pgsql
This package contains the PostGreSQL plugin for ROOT. This plugin provides a thin client (interface) to PostGreSQL servers. Using this client, one can obtain information from a PostGreSQL database into the ROOT environment.
We can use yum or dnf to install root-sql-pgsql on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install root-sql-pgsql.
Install root-sql-pgsql on CentOS 8 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install root-sql-pgsql using dnf by running the following command:
sudo dnf -y install root-sql-pgsql
Install root-sql-pgsql on CentOS 8 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
CentOS Linux 8 - AppStream 43 kB/s | 4.3 kB 00:00
CentOS Linux 8 - BaseOS 65 kB/s | 3.9 kB 00:00
CentOS Linux 8 - ContinuousRelease 43 kB/s | 3.0 kB 00:00
CentOS Linux 8 - Extras 23 kB/s | 1.5 kB 00:00
CentOS Linux 8 - FastTrack 40 kB/s | 3.0 kB 00:00
CentOS Linux 8 - HighAvailability 36 kB/s | 3.9 kB 00:00
CentOS Linux 8 - Plus 24 kB/s | 1.5 kB 00:00
CentOS Linux 8 - PowerTools 50 kB/s | 4.3 kB 00:00
Extra Packages for Enterprise Linux Modular 8 - x86_64 13 kB/s | 9.2 kB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 kB/s | 8.5 kB 00:00
Metadata cache created.
After updating yum database, We can install root-sql-pgsql using yum by running the following command:
sudo yum -y install root-sql-pgsql
How To Uninstall root-sql-pgsql on CentOS 8
To uninstall only the root-sql-pgsql package we can use the following command:
sudo dnf remove root-sql-pgsql
root-sql-pgsql Package Contents on CentOS 8
/usr/include/root/TPgSQLResult.h
/usr/include/root/TPgSQLRow.h
/usr/include/root/TPgSQLServer.h
/usr/include/root/TPgSQLStatement.h
/usr/lib/.build-id
/usr/lib/.build-id/55
/usr/lib/.build-id/55/c46294d28c92d88694811791c9e098c654daa9
/usr/lib64/root/libPgSQL.rootmap
/usr/lib64/root/libPgSQL.so
/usr/lib64/root/libPgSQL.so.6.22
/usr/lib64/root/libPgSQL.so.6.22.08
/usr/lib64/root/libPgSQL_rdict.pcm
/usr/share/root/plugins/TSQLServer/P020_TPgSQLServer.C
References
Summary
In this tutorial we learn how to install root-sql-pgsql on CentOS 8 using yum and dnf.