Permissions trouble upgrading data container

pfaffman · October 1, 2024, 3:29pm

I just had to do this again. I think what needs to happen is that

templates/postgres.template.yml

20e33fbfd


      
               #!/bin/bash
               sv stop postgres
          
          - file:
              path: /root/install_postgres
              chmod: "+x"
              contents: |
                #!/bin/bash
                locale-gen $LANG && update-locale
                mkdir -p /shared/postgres_run
                chown postgres:postgres /shared/postgres_run
                chmod 775 /shared/postgres_run
                rm -fr /var/run/postgresql
                ln -s /shared/postgres_run /var/run/postgresql
                if [ -e /shared/postgres_run/.s.PGSQL.5432 ]; then
                  socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1
                fi
                rm -fr /shared/postgres_run/.s*
                rm -fr /shared/postgres_run/*.pid
                mkdir -p /shared/postgres_run/13-main.pg_stat_tmp
                chown postgres:postgres /shared/postgres_run/13-main.pg_stat_tmp

Needs to be:

        chown postgres:postgres /shared/postgres_*

It doesn’t really matter if you chown postgres:postgres inside the container, right?

Topic		Replies	Views
Upgrading from a very old container fails due to postgres permission errors Bug	2	149	June 3, 2025
Rebuild fails: Data directory /shared/postgres_data must not be owned by root Self-hosting	4	752	February 5, 2025
PostgreSQL 13 update from PostgreSQL 10 fails Self-hosting	10	2742	October 13, 2021
Rebuild app crashes every time :( Self-hosting	6	1290	November 7, 2018
Update failed (postgresql) Self-hosting	7	4071	June 3, 2020

Permissions trouble upgrading data container

Related topics