Install PostgreSQL 16.9 on CentOS 8

• Install PostgreSQL 16.9 on CentOS 8

Install PostgreSQL 16.9 on CentOS 8

Install PostgreSQL 16.9 on CentOS 8 / CentOS Stream 8

1. Disable Built‑in PostgreSQL Module

sudo dnf -qy module disable postgresql

2. Add Official PostgreSQL (PGDG) Repo

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

3. Install PostgreSQL 16

sudo dnf install -y postgresql16 postgresql16-server

4. Initialize PostgreSQL Database

sudo /usr/pgsql-16/bin/postgresql-16-setup initdb

5. Start & Enable PostgreSQL Service

sudo systemctl enable --now postgresql-16

6. Verify Version

psql --version

7. Enable Remote Access (Optional)

Edit postgresql.conf:

sudo nano /var/lib/pgsql/16/data/postgresql.conf

Change:

listen_addresses = '*'

Edit pg_hba.conf:

sudo nano /var/lib/pgsql/16/data/pg_hba.conf

Add:

host    all    all    0.0.0.0/0    md5

or

host    all            postgres        0.0.0.0/0                md5
host    replication    debezium         0.0.0.0/0               md5
host    all            debezium         0.0.0.0/0               md5

Restart:

sudo systemctl restart postgresql-16

8. Open Firewall Port (Optional)

sudo firewall-cmd --add-port=5432/tcp --permanent
sudo firewall-cmd --reload

9. Create User & Database

sudo -i -u postgres
createuser debezium -P
createdb mydb -O debezium
exit

---

PostgreSQL 16.9 is now installed successfully.