Posgresql Error when I try Install Confluence

Question

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 · Answer

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;

Ben Barrows_ozqzol · Answer

Why on earth would this information not be here:

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

Septa Cahyadiputra_zgeimr · Answer

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;