PostgreSQL on Linux: Install and Optimize

Create Database and User

su - postgres
psql
CREATE USER myapp WITH PASSWORD 'strongpassword';
CREATE DATABASE myappdb OWNER myapp;
GRANT ALL PRIVILEGES ON DATABASE myappdb TO myapp;