Doing the newest update (incl. postgresql) result in an error: root@community:/var/discourse# ./launcher rebuild app Ensuring launcher is up to date Fetching origin Launcher is up-to-date Stopping old container + /usr/bin/docker stop -t 60 app app cd /pups && git pull && /pups/bin/pups --std…

[image] noezDE: https://meta.discourse.org/t/postgresql-12-update/151236 Did you review this post?

[image] RiversideRocks: [image] noezDE: https://meta.discourse.org/t/postgresql-12-update/151236 Yes, i did it before. We couldnt get the update running.

[image] noezDE: The source cluster was not shut down cleanly. Read the entire faq section here: [image] PostgreSQL 12 update FAQ The source cluster was not shut down cleanly If you get a upgrade failed with the above message, you can try a simpler approach to get it back into a better sta…

Already tried the workaround but it did not work.

The log is full of: 2020-06-03 16:01:21.074 UTC [693] FATAL: data directory “/shared/postgres_data” has wrong ownership 2020-06-03 16:01:21.074 UTC [693] HINT: The server must be started by the user that owns the data directory.

After loggin into the container i tried to shutdown it by myself: root@community-app:/etc/postgresql/10/main# service postgresql stop [FAIL] Stopping PostgreSQL 10 database server: main[…] Error: Config owner (postgres:106) and data owner (Debian-exim:105) do not match, and config owner is not roo…

Update failed (postgresql)

Support Self-hosting

noezDE (noez.de) June 3, 2020, 5:54pm 8

Running chown -R postgres postgres_data

at /shared after entering the docker container has fixed it.

PostgreSQL 13 update from PostgreSQL 10 fails

Topic		Replies	Views
Upgrade of postgres failed Self-hosting	1	1110	September 25, 2020
PostgreSQL 13 update from PostgreSQL 10 fails Self-hosting	10	2572	October 13, 2021
Rebuild fails: Data directory /shared/postgres_data must not be owned by root Self-hosting	5	536	February 5, 2025
Trouble with postgre（maybe） Self-hosting	5	1693	August 13, 2020
Postgres upgrade success loop due to prior postgres 8 to 10 migration Self-hosting	4	1192	June 25, 2020

Update failed (postgresql)

Related topics