POstgres 15 image does not work with Gitlab backup:restore task - "permission denied for schema public" #168

Activity

1. danobot

   changed the title [-]POstgres 15 image does not work with Gitlab backup:restore task = "permission denied for schema public"[/-] [+]POstgres 15 image does not work with Gitlab backup:restore task - "permission denied for schema public"[/+] on Oct 4, 2023
2. froque

   added 4 commits that reference this issue on Nov 4, 2023

   Upgrade instructions form Postgresql 12 to 14

   ...

   94231a0

   Upgrade instructions form Postgresql 12 to 14

   ...

   0db1870

   Upgrade instructions form Postgresql 12 to 14

   ...

   4fe8140

   Upgrade instructions form Postgresql 12 to 14

   ...

   c814fb7
3. elchenberg commented on Jan 9, 2024

   

   elchenberg

   on Jan 9, 2024

   More actions

   I might have the same issue.

   In my case I created a new database for SonarQube:

         containers:
           - name: postgres
             image: docker.io/sameersbn/postgresql:15@sha256:f5f9f8ad3b873d49a44e21c3f17231da3f92db7f0f73119215b7c771faf53e13
             env:
               - name: DB_NAME
                 value: sonar
               - name: DB_PASS
                 value: sonar
               - name: DB_USER
                 value: sonar

   I got permission denied for schema public in SonarQube, too.

   As a workaround I used an initContainer (on the SonarQube pod, after the PostgreSQL database is already up and running):

           - name: create-schema
             image: docker.io/sameersbn/postgresql:15@sha256:f5f9f8ad3b873d49a44e21c3f17231da3f92db7f0f73119215b7c771faf53e13
             env:
               - name: PGPASSWORD
                 value: sonar
             command:
               - psql
             args:
               - --dbname=sonar
               - --command=CREATE SCHEMA IF NOT EXISTS AUTHORIZATION sonar;
               - --host=postgres
               - --no-password
               - --username=sonar

   I am wondering if something like CREATE SCHEMA IF NOT EXISTS AUTHORIZATION sonar; could be added to the create_database function (but my PostgreSQL knowledge is very limited).

   Version: docker.io/sameersbn/postgresql:15@sha256:f5f9f8ad3b873d49a44e21c3f17231da3f92db7f0f73119215b7c771faf53e13

   PS. I still have to double-check if my workaround actually works.
4. Jack12816

   added a commit that references this issue on Dec 1, 2025

   Upgrade instructions form Postgresql 12 to 14

   ...

   8c6f158