Install PostgreSQL on NetBSD 10

Step 1 – Install PostgreSQL

pkgin install postgresql16-server postgresql16-client
# Initialize
su -l pgsql -c 'initdb -D /usr/pkg/pgsql/data'
echo 'pgsql=YES' >> /etc/rc.conf
service postgresql start

Step 2 – Connect as the postgres superuser

sudo -u postgres psql

Step 3 – Create a database and user

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

Step 4 – Key configuration files

Step 5 – Allow remote connections (optional)

Edit /usr/pkg/pgsql/data/postgresql.conf:

listen_addresses = '*'

Edit /usr/pkg/pgsql/data/pg_hba.conf and add:

host  appdb  appuser  0.0.0.0/0  scram-sha-256

Reload:

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