How To Install pg_repack on Fedora 36

In this tutorial we learn how to install pg_repack in Fedora 36. pg_repack is Reorganize tables in PostgreSQL databases without any locks

Introduction

In this tutorial we learn how to install pg_repack on Fedora 36.

What is `pg_repack`

pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly. Please check the documentation (in the doc directory or online) for installation and usage instructions.

We can use yum or dnf to install pg_repack on Fedora 36. In this tutorial we discuss both methods but you only need to choose one of method to install pg_repack.

Install pg_repack on Fedora 36 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

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

sudo dnf -y install pg_repack

Install pg_repack on Fedora 36 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

After updating yum database, We can install pg_repack using yum by running the following command:

sudo yum -y install pg_repack

How To Uninstall pg_repack on Fedora 36

To uninstall only the pg_repack package we can use the following command:

sudo dnf remove pg_repack

pg_repack Package Contents on Fedora 36

/usr/bin/pg_repack
/usr/lib/.build-id
/usr/lib/.build-id/39
/usr/lib/.build-id/39/5b7970663d8b7ba35d0730dbaeca3a5443b455
/usr/lib/.build-id/b9
/usr/lib/.build-id/b9/8dad8345f1c615255a00eed7d1be36b6882f66
/usr/lib64/pgsql/bitcode/pg_repack.index.bc
/usr/lib64/pgsql/bitcode/pg_repack/pgut/pgut-spi.bc
/usr/lib64/pgsql/bitcode/pg_repack/repack.bc
/usr/lib64/pgsql/pg_repack.so
/usr/share/doc/pg_repack
/usr/share/doc/pg_repack/README.rst
/usr/share/doc/pg_repack/pg_repack.html
/usr/share/doc/pg_repack/pg_repack.rst
/usr/share/doc/pg_repack/pg_repack_jp.html
/usr/share/doc/pg_repack/pg_repack_jp.rst
/usr/share/doc/pg_repack/release.html
/usr/share/doc/pg_repack/release.rst
/usr/share/licenses/pg_repack
/usr/share/licenses/pg_repack/COPYRIGHT
/usr/share/pgsql/extension/pg_repack--1.4.6.sql
/usr/share/pgsql/extension/pg_repack.control

References

pg_repack website

Summary

In this tutorial we learn how to install pg_repack on Fedora 36 using yum and [dnf]((/fedora/36/dnf/).