Install dan Konfigurasi PostgreSQL di Ubuntu

Install PostgreSQL

sudo apt install postgresql

Konfigurasi akses /etc/postgresql/*/main/pg_ident.conf

listen_addresses = '*'

Buat password baru

sudo -u postgres psql template1
ALTER USER postgres with encrypted password 'your_password';

Edit akses /etc/postgresql/*/main/pg_hba.conf

hostssl all       all        0.0.0.0/0        scram-sha-256

Restart

sudo systemctl restart postgresql.service