PostgreSQL روی Rocky و AlmaLinux

sudo dnf install -y postgresql-server postgresql-contrib
sudo postgresql-setup --initdb
sudo systemctl enable --now postgresql

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

local   all   postgres                peer
local   all   all                     scram-sha-256
host    all   all   127.0.0.1/32      scram-sha-256
host    all   all   ::1/128           scram-sha-256

password_encryption = scram-sha-256

sudo systemctl restart postgresql

sudo -u postgres createuser --pwprompt hr
sudo -u postgres createdb -O hr hr
psql -h 127.0.0.1 -U hr -d hr -c 'select 1;'

# postgresql.conf
listen_addresses = 'localhost,192.168.10.31'

# pg_hba.conf
host  hr  hr  192.168.10.40/32  scram-sha-256

sudo firewall-cmd --permanent --add-rich-rule='rule family=ipv4 source address=192.168.10.40/32 service name=postgresql accept'
sudo firewall-cmd --reload
sudo systemctl restart postgresql