Re: BUG #18068: Insufficient permission unless SUPERUSER - Mailing list pgsql-bugs

From Ghw
Subject Re: BUG #18068: Insufficient permission unless SUPERUSER
Date
Msg-id 18a2a0d956e.e9539b35303165.769488109648739004@ghwfluffy.com
Whole thread Raw
In response to Re: BUG #18068: Insufficient permission unless SUPERUSER  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Thank you very much for your prompt reply, that was exactly my issue. Sorry for the false bug report.

For anyone else googling how to grant permissions in docker-entrypoint-initdb.d:

CREATE DATABASE mydb;
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypassword';
\c mydb
GRANT CREATE ON SCHEMA public TO myuser;

pgsql-bugs by date:

Previous
From: Jonathan Zacharuk
Date:
Subject: RE: Error when using unquoted identifier that contains the word end in a begin atomic block
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder()