PostgreSQL setup

sudo -u postgres psql

CREATE USER op;
CREATE ROLE op WITH LOGIN;
ALTER USER op WITH PASSWORD 'password';
DROP DATABASE op;
CREATE DATABASE OP WITH TEMPLATE = template0 ENCODING UNICODE;
GRANT ALL PRIVILEGES ON DATABASE op TO op;
 
# PostgreSQL 15 also revokes the CREATE permission FROM ALL users EXCEPT a DATABASE owner FROM the public (OR DEFAULT) schema.
ALTER DATABASE op OWNER TO op;
 
# OR:
GRANT USAGE, CREATE ON SCHEMA public TO op;

See: PostgreSQL ERROR: permission denied for schema public