Hi,
I am testing my app against all supported PostgreSQL versions from 11-14 in a dockerized setup.
Now I wanted to add Postgres 15 with the exact same procedure but I am getting these DB-errors on startup of Jira.
ERROR: permission denied for schema public at character ...
I have seen, there is no update on the docs for anything new on Postgres 15 here:
I am using this seed SQL since many years:
jira-seed.sql
CREATE DATABASE jira WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
CREATE USER jira WITH ENCRYPTED PASSWORD 'supersecure123';
GRANT ALL PRIVILEGES ON DATABASE jira TO jira;
And for the docker container I set these env vars:
# my local ip is: 192.168.178.73
# START DB
docker run --name jira911dbvanilla -d \
-p 5432:5432 \
-e POSTGRES_USER=root \
-e POSTGRES_PASSWORD=supersecure123root \
postgres:15.4-alpine
# SEED (pw: supersecure123root)
psql -h 192.168.178.73 -p 5432 -U root -f ./jira-seed.sql
# START JIRA
docker run --name jira911vanilla -d \
-p 8080:8080 \
-e JVM_MINIMUM_MEMORY=512M \
-e JVM_MAXIMUM_MEMORY=2048M \
-e ATL_JDBC_URL="jdbc:postgresql://192.168.178.73:5432/jira" \
-e ATL_JDBC_USER=jira \
-e ATL_JDBC_PASSWORD=supersecure123 \
-e ATL_DB_DRIVER=org.postgresql.Driver \
-e ATL_DB_TYPE=postgres72 \
-e CLUSTERED=false \
atlassian/jira-software:9.11-jdk11
What am I doing wrong? This has worked since postgres 11 up to 14.
Thanks
Bernhard