Hi Atlassian,
I am trying to create a confluence database in Aurora Postgresql and I am getting this error
postgres=> create role confluenceuser with password 'secret' login;
CREATE ROLE
postgres=> create database confluence with encoding 'utf-8' lc_collate 'en_US.utf8' LC_CTYPE 'en_US.utf8' TEMPLATE template0 owner confluenceuser;
ERROR: must be member of role "confluenceuser"
Any suggestion on what I am doing wrong? I am trying to follow this link https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html
Thanks,
Asif
Our issue was adding ownership of the database to a user and that was failing.
We found a fix. So create the database without the owner. And then alter the database to the owner. That worked.
postgres=> create database confluence with encoding 'utf-8' lc_collate 'en_US.utf8' LC_CTYPE 'en_US.utf8' TEMPLATE template0;
CREATE DATABASE
postgres=> alter database confluence owner to confluenceuser;
ALTER DATABASE
Here is a guide to creating a postgresql user.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.