Install PostgreSQL on Arch Linux

Step 1 – Install

pacman -S --noconfirm postgresql
sudo -u postgres initdb --locale=en_US.UTF-8 -E UTF8 -D /var/lib/postgres/data
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongPass123!';
CREATE DATABASE appdb OWNER appuser;
GRANT ALL PRIVILEGES ON DATABASE appdb TO appuser;
\q

Key files

Allow remote connections (optional)

/var/lib/postgres/data/postgresql.conf: listen_addresses = '*'

/var/lib/postgres/data/pg_hba.conf: host appdb appuser 0.0.0.0/0 scram-sha-256

systemctl reload postgresql 2>/dev/null || rc-service postgresql-14 reload 2>/dev/null || rcctl reload postgresql