Cause:
- Default privileges on PUBLIC schema were changed in postgres 15+ => see postgres release notes: PostgreSQL: Release Notes
Solution (use at own risk)
To solve this the suggested GRANT ALL ON SCHEMA public TO jira; did not work for me.
I also needed to change the database owner too. So here is the full seed.sql that is working with postrares 15+
CREATE USER jira WITH ENCRYPTED PASSWORD 'supersecure123';
-- since postgres 15 (before db creation)
GRANT ALL ON SCHEMA public TO jira;
-- now create objects
CREATE DATABASE jira WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
GRANT ALL PRIVILEGES ON DATABASE jira TO jira;
-- also needed for postgres 15
ALTER DATABASE jira OWNER TO jira;