====== PostgreSQL ======

====== PostgreSQL setup ======

<code bash>
sudo -u postgres psql
</code>

<code sql>
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;
</code>

See: [[https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/|PostgreSQL ERROR: permission denied for schema public]]