Cannot configure Confluence Data database

Server Room

When I moved past the Postgres setup page I get this error:

The following error(s) occurred:

• Configuring database failed
• StatementCallback; bad SQL grammar [CREATE OR REPLACE FUNCTION space_function_for_denormalised_permissions() RETURNS TRIGGER AS $BODY$ BEGIN RETURN NEW; END $BODY$ LANGUAGE plpgsql;]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for schema public

 

Any ideas?

Alexis Robert

Hi @Server Room , 

 

as far as I can see it might be because of permissions granted to the Jira user on newer Postgre versions.

You can look at the suggested solution in this post :

 

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;

 

Let me know if this helps, 

 

--Alexis