Install TimescaleDB on Rocky Linux 9.2 With Postgresql 15

Sep 18th, 2023 • Permalink

Largely following the official installation guide.

Disable SELinux

vi /etc/selinux/config

Disable firewall

firewall-cmd --zone=public --add-port=5432/tcp
firewall-cmd --permanent --zone=public --add-port=5432/tcp
firewall-cmd --reload
systemctl restart firewalld

Allow Remote Addresses

vi /var/lib/pgsql/15/data/postgresql.conf

listen_address = "*"

Create user and DB

sudo su - postgres
createuser mspv --pwprompt
psql
ALTER ROLE mspv LOGIN;
CREATE DATABASE mspv_db WITH ENCODING='UTF8' OWNER=mspv;
logout
vi /var/lib/pgsql/15/data/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    mspv_db         mspv            0.0.0.0/0               scram-sha-256

Comments