- Install postgres.
- Setup password for
postgreslinux user:sudo passwd postgres - Switch to this user:
su - postgres - Run
psql -U postgres - Create user with your name as in linux. Grant it some privileges. For all privileges:
CREATE USER {your_username} WITH ENCRYPTED PASSWORD '{your_password}';
ALTER USER {your_username} WITH SUPERUSER;