Skip to main content

Setup postgresql

CREATE DATABASE myprojectdb;
CREATE USER myprojectuser WITH PASSWORD 'strongpassword';
ALTER ROLE myprojectuser SET client_encoding TO 'UTF8';
ALTER ROLE myprojectuser SET default_transaction_isolation TO 'read committed';
ALTER ROLE myprojectuser SET timezone TO 'UTC';
GRANT ALL PRIVILEGES ON DATABASE myprojectdb TO myprojectuser;
\q