CREATE DATABASE sample_db;
CREATE USER sample_user WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE sample_db TO sample_user;
Enter with
psql -U sample_user -d sample_db
Powered by TurnKey Linux.