Issue Summary

This suggestion was created to fix our documentation related to Postgres database creation: Connect Bamboo to a PostgreSQL database.

Description

Starting Bamboo 9.1, Postgres 15 became supported by Bamboo as per Bamboo 9.1 - Supported platforms, but in Connect Bamboo to a PostgreSQL database documentation there's dedicated section to help users to create the database in case if Postgres 15 is being used.

Suggestion

Add to Connect Bamboo to a PostgreSQL database documentation some similar information that is present in Connecting Jira applications to PostgreSQL. For example:

With PostgreSQL 15, there has been a change in the way table creation permissions are handled for users. PostgreSQL 15 revokes the CREATE permission from all users except a database owner from the public (or default) schema. According to the Postgres 15 documentation, you can fix it by creating a user-private schema for the Bamboo database user.

However, you can also grant the permission to the public schema by running the following commands:

1. Create the user that Bamboo will be using.

   CREATE USER bamboo WITH PASSWORD 'atlas';

2. Create the database.

   CREATE DATABASE bamboo WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

3. Grant the necessary privileges to the database:

   GRANT ALL PRIVILEGES ON DATABASE bamboo TO atlas;

4. Connect to the database.

   \c bamboo postgres

5. Grant the required schema privileges:

   atlas=# GRANT ALL ON SCHEMA public TO atlas;