How To Install root-sql-pgsql on CentOS 8

root-sql-pgsql is PostgreSQL client plugin for ROOT

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.