In this tutorial, you will learn how to install PostgreSQL on Rocky Linux 8.
PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many aspects.
Some of the features are: ACID transactions, foreign keys, views, sequences, subqueries, triggers, user-defined types and functions, outer joins, multiversion concurrency control. Graphical user interfaces and bindings for many programming languages are available as well.
PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
Installing PostgreSQL on Rocky Linux 8
Rocky Linux ships with AppStream repository modules for various versions of PostgreSQL.
dnf module list postgresqlRocky Linux 8 - AppStream
Name Stream Profiles Summary
postgresql 9.6 client, server [d] PostgreSQL server and client module
postgresql 10 [d] client, server [d] PostgreSQL server and client module
postgresql 12 client, server [d] PostgreSQL server and client module
postgresql 13 client, server [d] PostgreSQL server and client module
Hint: [d]efault, [e]nabled, [x]disabled, [i]nstalled
From the output above, you can can we that there are streams of various versions of PostgreSQL including v9.6, 10, 12, 13.
The AppStream modules for PostgreSQL is enabled by default.
For various reasons, you might want to install various versions of PostgreSQL on your Rocky Linux 8 box.
Install PostgreSQL 13 on Rocky Linux 8
As of this writing, PostgreSQL 13 is the current stable release.
By default, the AppStream modules for PostgreSQL 10 are enabled by default.
To install PostgreSQL 13 on Rocky Linux 8;
- Enable PostgreSQL 13 AppStream module
dnf -qy module enable postgresql:13Confirm;
dnf info postgresql-serverAvailable Packages
Name : postgresql-server
Version : 13.3
Release : 1.module+el8.4.0+546+3620623e
Architecture : x86_64
Size : 5.6 M
Source : postgresql-13.3-1.module+el8.4.0+546+3620623e.src.rpm
Repository : appstream
Summary : The programs needed to create and run a PostgreSQL server
URL : http://www.postgresql.org/
License : PostgreSQL
Hence, you can now run the command below to install PostgreSQL 13 on Rocky Linux 8.
dnf install postgresql-serverDependencies resolved.
============================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================
Installing:
postgresql-server x86_64 13.3-1.module+el8.4.0+546+3620623e appstream 5.6 M
Installing dependencies:
libicu x86_64 60.3-2.el8_1 baseos 8.8 M
libpq x86_64 13.3-1.el8_4 appstream 196 k
postgresql x86_64 13.3-1.module+el8.4.0+546+3620623e appstream 1.5 M
Transaction Summary
============================================================================================================================================================================
Install 4 Packages
Total download size: 16 M
Installed size: 59 M
Is this ok [y/N]: y
Check the version PostgreSQL installed;
postgres -Vpostgres (PostgreSQL) 13.3Initialize the database;
postgresql-setup --initdbStart and enable PostgreSQL to run on system boot;
systemctl enable --now postgresqlChecking the status;
systemctl status postgresql● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2021-09-07 09:42:14 EAT; 47s ago
Process: 15684 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql (code=exited, status=0/SUCCESS)
Main PID: 15686 (postmaster)
Tasks: 8 (limit: 4938)
Memory: 16.8M
CGroup: /system.slice/postgresql.service
├─15686 /usr/bin/postmaster -D /var/lib/pgsql/data
├─15688 postgres: logger
├─15690 postgres: checkpointer
├─15691 postgres: background writer
├─15692 postgres: walwriter
├─15693 postgres: autovacuum launcher
├─15694 postgres: stats collector
└─15695 postgres: logical replication launcher
Sep 07 09:42:13 rocky8 systemd[1]: Starting PostgreSQL database server...
Sep 07 09:42:13 rocky8 postmaster[15686]: 2021-09-07 09:42:13.544 EAT [15686] LOG: starting PostgreSQL 12.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.4.1 202009>
Sep 07 09:42:13 rocky8 postmaster[15686]: 2021-09-07 09:42:13.545 EAT [15686] LOG: listening on IPv6 address "::1", port 5432
Sep 07 09:42:13 rocky8 postmaster[15686]: 2021-09-07 09:42:13.545 EAT [15686] LOG: listening on IPv4 address "127.0.0.1", port 5432
Sep 07 09:42:13 rocky8 postmaster[15686]: 2021-09-07 09:42:13.687 EAT [15686] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Sep 07 09:42:13 rocky8 postmaster[15686]: 2021-09-07 09:42:13.962 EAT [15686] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 07 09:42:14 rocky8 postmaster[15686]: 2021-09-07 09:42:14.130 EAT [15686] LOG: redirecting log output to logging collector process
Sep 07 09:42:14 rocky8 postmaster[15686]: 2021-09-07 09:42:14.130 EAT [15686] HINT: Future log output will appear in directory "log".
Sep 07 09:42:14 rocky8 systemd[1]: Started PostgreSQL database server.
Install PostgreSQL 12 on Rocky Linux 8
To install PostgreSQL 12 on Rocky Linux, run the commands below;
dnf -qy module enable postgresql:12dnf install postgresql-serverOtherwise, if you had other versions modules enabled, then reset the modules and install PostgreSQL as follows;
dnf -qy module reset postgresqldnf -qy module enable postgresql:12dnf install postgresql-serverDependencies resolved.
============================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================
Installing:
postgresql-server x86_64 12.7-1.module+el8.4.0+587+d46efd10 appstream 5.6 M
Installing dependencies:
libicu x86_64 60.3-2.el8_1 baseos 8.8 M
libpq x86_64 13.3-1.el8_4 appstream 196 k
postgresql x86_64 12.7-1.module+el8.4.0+587+d46efd10 appstream 1.5 M
Transaction Summary
============================================================================================================================================================================
Install 4 Packages
Total download size: 16 M
Installed size: 59 M
Is this ok [y/N]: y
After install, you can verify the version;
postgres -Vpostgres (PostgreSQL) 12.7Initialize the database;
postgresql-setup --initdbStart and enable PostgreSQL to run on system boot;
systemctl enable --now postgresqlInstall PostgreSQL 10 on Rocky Linux 8
By default, you would simply run the commands below to install PostgreSQL 10 on Rocky Linux 8.
dnf install postgresql-serverHowever, if you have other versions AppStream modules enabled, then you have to reset the modules.
dnf -qy module reset postgresqldnf install postgresql-serverDependencies resolved.
============================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================
Installing:
postgresql-server x86_64 10.17-1.module+el8.4.0+548+9eccbe3f appstream 5.1 M
Installing dependencies:
libpq x86_64 13.3-1.el8_4 appstream 196 k
postgresql x86_64 10.17-1.module+el8.4.0+548+9eccbe3f appstream 1.5 M
Enabling module streams:
postgresql 10
Transaction Summary
============================================================================================================================================================================
Install 3 Packages
Total download size: 6.8 M
Installed size: 26 M
Is this ok [y/N]: y
After install, you can verify the version;
postgres -Vpostgres (PostgreSQL) 10.17Initialize the database;
postgresql-setup --initdbStart and enable PostgreSQL to run on system boot;
systemctl enable --now postgresqlSimilarly, to install PostgreSQL 9.x, then enable the module and run the installation command.
Install PostgreSQL 11 on Rocky Linux 8
Rocky Linux do not provide repositories for installing PostgreSQL 11.
Thus, if you want to install PostgreSQL 11 on Rocky Linux 8, then you need to install the repository RPM:
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmDisable the built-in PostgreSQL module:
dnf -qy module disable postgresqlInstall PostgreSQL 11 on Rocky Linux 8
dnf install postgresql11-serverDependencies resolved.
============================================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================================
Installing:
postgresql11-server x86_64 11.13-1PGDG.rhel8 pgdg11 4.9 M
Installing dependencies:
libicu x86_64 60.3-2.el8_1 baseos 8.8 M
postgresql11 x86_64 11.13-1PGDG.rhel8 pgdg11 1.7 M
postgresql11-libs x86_64 11.13-1PGDG.rhel8 pgdg11 394 k
Transaction Summary
============================================================================================================================================================================
Install 4 Packages
Total download size: 16 M
Installed size: 60 M
Is this ok [y/N]: y
Initialize the database;
postgresql-11-setup initdbStart and enable PostgreSQL to run on system boot;
systemctl enable --now postgresql-11Checking the status;
systemctl status postgresql-11● postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2021-09-07 09:19:07 EAT; 44s ago
Docs: https://www.postgresql.org/docs/11/static/
Process: 11990 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 11995 (postmaster)
Tasks: 8 (limit: 4938)
Memory: 16.4M
CGroup: /system.slice/postgresql-11.service
├─11995 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/
├─12001 postgres: logger
├─12003 postgres: checkpointer
├─12004 postgres: background writer
├─12005 postgres: walwriter
├─12006 postgres: autovacuum launcher
├─12007 postgres: stats collector
└─12008 postgres: logical replication launcher
Sep 07 09:19:05 rocky8 systemd[1]: Starting PostgreSQL 11 database server...
Sep 07 09:19:06 rocky8 postmaster[11995]: 2021-09-07 09:19:06.387 EAT [11995] LOG: listening on IPv6 address "::1", port 5432
Sep 07 09:19:06 rocky8 postmaster[11995]: 2021-09-07 09:19:06.387 EAT [11995] LOG: listening on IPv4 address "127.0.0.1", port 5432
Sep 07 09:19:06 rocky8 postmaster[11995]: 2021-09-07 09:19:06.541 EAT [11995] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Sep 07 09:19:06 rocky8 postmaster[11995]: 2021-09-07 09:19:06.848 EAT [11995] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 07 09:19:07 rocky8 postmaster[11995]: 2021-09-07 09:19:07.005 EAT [11995] LOG: redirecting log output to logging collector process
Sep 07 09:19:07 rocky8 postmaster[11995]: 2021-09-07 09:19:07.005 EAT [11995] HINT: Future log output will appear in directory "log".
Sep 07 09:19:07 rocky8 systemd[1]: Started PostgreSQL 11 database server.
Read More on PostgreSQL Tutorials.
Other Tutorials
Install LAMP Stack on Debian 11
