PostgreSQL on VPS: Install, Configure and Optimize

Install PostgreSQL 16

sudo apt install -y postgresql postgresql-contrib
sudo systemctl enable --now postgresql

Create Database and User

sudo -u postgres psql
CREATE USER myuser WITH PASSWORD 'StrongPassword';
CREATE DATABASE myapp OWNER myuser;
\q