meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
linux:sw:openproject:psql [2025/05/04 19:32] – created niziaklinux:sw:openproject:psql [2025/08/05 09:23] (current) – niziak
Line 1: Line 1:
 +====== PostgreSQL ======
 +
 +====== PostgreSQL setup ======
 +
 <code bash> <code bash>
 sudo -u postgres psql sudo -u postgres psql
 </code> </code>
 +
 <code sql> <code sql>
 CREATE USER op; CREATE USER op;
Line 9: Line 14:
 CREATE DATABASE OP WITH TEMPLATE = template0 ENCODING UNICODE; CREATE DATABASE OP WITH TEMPLATE = template0 ENCODING UNICODE;
 GRANT ALL PRIVILEGES ON DATABASE op TO op; 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> </code>
 +
 +See: [[https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/|PostgreSQL ERROR: permission denied for schema public]]
 +