How To Install postgresql-odbc on Rocky Linux 8

In this tutorial we learn how to install postgresql-odbc on Rocky Linux 8. postgresql-odbc is PostgreSQL ODBC driver

Introduction

In this tutorial we learn how to install postgresql-odbc on Rocky Linux 8.

What is postgresql-odbc

This package includes the driver needed for applications to access a PostgreSQL system via ODBC (Open Database Connectivity).

We can use yum or dnf to install postgresql-odbc on Rocky Linux 8. In this tutorial we discuss both methods but you only need to choose one of method to install postgresql-odbc.

Install postgresql-odbc on Rocky Linux 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install postgresql-odbc using dnf by running the following command:

sudo dnf -y install postgresql-odbc

Install postgresql-odbc on Rocky Linux 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install postgresql-odbc using yum by running the following command:

sudo yum -y install postgresql-odbc

How To Uninstall postgresql-odbc on Rocky Linux 8

To uninstall only the postgresql-odbc package we can use the following command:

sudo dnf remove postgresql-odbc

postgresql-odbc Package Contents on Rocky Linux 8

/usr/lib/.build-id
/usr/lib/.build-id/6c
/usr/lib/.build-id/6c/2834701de2d493240d7d3a8e4b103581405fa7
/usr/lib/.build-id/f7
/usr/lib/.build-id/f7/124f6282aabefb669487e4b349c4f8b4d6f212
/usr/lib64/psqlodbc.so
/usr/lib64/psqlodbca.so
/usr/lib64/psqlodbcw.so
/usr/share/doc/postgresql-odbc
/usr/share/doc/postgresql-odbc/README.rpmdist
/usr/share/doc/postgresql-odbc/README.txt
/usr/share/doc/postgresql-odbc/config-opt.html
/usr/share/doc/postgresql-odbc/config.html
/usr/share/doc/postgresql-odbc/editConfiguration.jpg
/usr/share/doc/postgresql-odbc/license.txt
/usr/share/doc/postgresql-odbc/msdtc_pgxalib_tracing_README.txt
/usr/share/doc/postgresql-odbc/msdtc_pgxalib_tracing_disable.reg
/usr/share/doc/postgresql-odbc/msdtc_pgxalib_tracing_enable.reg
/usr/share/doc/postgresql-odbc/readme.txt
/usr/share/doc/postgresql-odbc/release-7.3.html
/usr/share/doc/postgresql-odbc/release.html
/usr/share/doc/postgresql-odbc/unix-compilation.html
/usr/share/doc/postgresql-odbc/win32-compilation.html

References

Summary

In this tutorial we learn how to install postgresql-odbc on Rocky Linux 8 using yum and dnf.