How can I install PostgreSQL 11 on CentOS 8 / RHEL 8 Linux?. PostgreSQL is an object-relational database management system based on POSTGRES 4.2, developed at the University of California at Berkeley Computer Science Department. PostgreSQL offers many modern features of SQL such as:
- complex queries
- foreign keys
- triggers
- updatable views
- transactional integrity
- multiversion concurrency control
PostgreSQL project provides a repository of packages of all supported versions for the most common distributions. Among the distributions supported are all Red Hat family of which includes CentOS, Fedora, Scientific Linux, Oracle Linux and Red Hat Enterprise Linux.
For PostgreSQL 12, check Installing PostgreSQL 12 on CentOS / RHEL 8
The version of PostgreSQL available on CentOS 8 / RHEL 8 officially maintained modular repository is 10 and 9.6. We’ll add PostgreSQL Yum Repository which hosts all recent releases.
Step 1: Add PostgreSQL Yum Repository
The PostgreSQL Yum Repository will integrate with your normal systems and patch management, and provide automatic updates for all supported versions of PostgreSQL throughout the support lifetime of PostgreSQL.
It can be added to CentOS / RHEL 8 system by running the command below:
sudo dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpmView package details with:
$ rpm -qi pgdg-redhat-repo
Name : pgdg-redhat-repo
Version : 42.0
Release : 34PGDG
Architecture: noarch
Install Date: Wed 16 Aug 2023 10:05:39 PM UTC
Group : Unspecified
Size : 14941
License : PostgreSQL
Signature : DSA/SHA1, Mon 14 Aug 2023 03:56:52 PM UTC, Key ID 1f16d2e1442df0f8
Source RPM : pgdg-redhat-repo-42.0-34PGDG.src.rpm
Build Date : Mon 14 Aug 2023 03:56:34 PM UTC
Build Host : koji-rhel8-x86-64-pgbuild
Vendor : PostgreSQL Global Development Group
URL : https://yum.postgresql.org
....
Step 2: Install PostgreSQL 11 on CentOS 8 / RHEL 8
Disable postgresql module.
$ sudo dnf module -y disable postgresql
Updating Subscription Management repositories.
Last metadata expiration check: 0:03:10 ago on Mon 16 Sep 2022 04:30:11 PM EDT.
Dependencies resolved.
===================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================
Disabling module streams:
postgresql 10
Transaction Summary
===================================================================================================================================================
Is this ok [y/N]: y
Complete!
Then clean yum cache and install PostgreSQL 11 on CentOS 8 / RHEL 8.
sudo dnf clean allFinally install PostgreSQL 11 server and client packages on CentOS 8 / RHEL 8 by running the commands below.
sudo dnf -y install postgresql11-server postgresql11Minor version details can be checked using dnf command.
dnf info -y postgresql11-server postgresql11Step 3: Initialize database and enable automatic start
After installation, database initialization is required before service can be started.
sudo /usr/pgsql-11/bin/postgresql-11-setup initdb
sudo systemctl enable --now postgresql-11
Confirm that the service is started without any errors.
$ 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 Mon 2022-09-16 16:41:09 EDT; 7s ago
Docs: https://www.postgresql.org/docs/11/static/
Process: 14929 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 14936 (postmaster)
Tasks: 8 (limit: 24024)
Memory: 16.9M
CGroup: /system.slice/postgresql-11.service
├─14936 /usr/pgsql-11/bin/postmaster -D /var/lib/pgsql/11/data/
├─14937 postgres: logger
├─14939 postgres: checkpointer
├─14940 postgres: background writer
├─14941 postgres: walwriter
├─14942 postgres: autovacuum launcher
├─14943 postgres: stats collector
└─14944 postgres: logical replication launcher
Sep 16 16:41:09 rhel8.novalocal systemd[1]: Starting PostgreSQL 11 database server...
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.501 EDT [14936] LOG: listening on IPv6 address "::1", port 5432
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.501 EDT [14936] LOG: listening on IPv4 address "127.0.0.1", port 5432
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.505 EDT [14936] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQ>
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.511 EDT [14936] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.521 EDT [14936] LOG: redirecting log output to logging collector process
Sep 16 16:41:09 rhel8.novalocal postmaster[14936]: 2022-09-16 16:41:09.521 EDT [14936] HINT: Future log output will appear in directory "log".
Sep 16 16:41:09 rhel8.novalocal systemd[1]: Started PostgreSQL 11 database server.
PostgreSQL 11 configuration file is:
ls /var/lib/pgsql/11/data/postgresql.confRead through the file to see which settings you can turn on/off. The service should be restarted whenever changes are committed.
Step 4: Set PostgreSQL admin user’s password
Set PostgreSQL admin user
$ sudo su - postgres
[postgres@rhel8 ~]$ psql -c "alter user postgres with password 'StrongPassword'"
ALTER ROLE
[postgres@rhel8 ~]$Create a test user and database
[postgres@rhel8 ~]$ psql
psql (11.15)
Type "help" for help.
postgres-# createuser test_user
postgres-# alter user test_user with password 'MyDBpassword';
postgres=# createdb test_db -O test_user
postgres=# grant all privileges on database test_db to test_user;
GRANTLogin as a test_user user try to create a table on the Database.
$ psql -U test_user -h localhost -d test_db
Step 5: Install pgAdmin 4 Web interface
pgAdmin is the leading Open Source feature-rich PostgreSQL administration and development platform that runs on Linux, Unix, Mac OS X, and Windows. Here is the link for the installation of pgAdmin4 on CentOS 8.
Books for Learning PostgreSQL database:
