Posgresql Error when I try Install Confluence

[Tony Montana]

Hello. I have an Error

The following error(s) occurred: Configuring database failed StatementCallback; bad SQL grammar [alter table LABEL add column OWNER_NOT_NULL VARCHAR(255) GENERATED ALWAYS AS (COALESCE(OWNER, '')) STORED]

in installation. Last DC confluence and Posgresql 16.4

[Andrew Laden]

I worked with Support. They eventually had me just drop the column and let the upgrade re-create it.

ALTER TABLE label DROP COLUMN owner_not_null;

[Septa Cahyadiputra]

Hi @Tony Montana

The ERROR might indicate permission as describe here:

* https://community.developer.atlassian.com/t/postgresql-15-with-jira-9-10-9-11-error-permission-denied-for-schema-public-at-character/73474

Please double check the permission as described here.

regards,
Septa Cahyadiputra

[Tony Montana]

@Septa Cahyadiputraafter manipulations i have same error

[Septa Cahyadiputra]

Tony, sorry to hear that. If everything checked out, I think it would be best to reach out to support so they could properly review your issue.

Just to double check, you might want to create a new DB instead of just altering the previously created DB as a sanity check.

CREATE USER conf WITH ENCRYPTED PASSWORD 'supersecure123'; 
-- since postgres 15 (before db creation) 
GRANT ALL ON SCHEMA public TO conf; 
-- now create objects 
CREATE DATABASE conf WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0; 
GRANT ALL PRIVILEGES ON DATABASE conf TO conf; 
-- also needed for postgres 15 
ALTER DATABASE conf OWNER TO conf;

[Ben Barrows]

Why on earth would this information not be here:

https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html