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…

Running chown -R postgres postgres_data at /shared after entering the docker container has fixed it.

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

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

[صورة] noezDE: The source cluster was not shut down cleanly. Read the entire faq section here: [صورة] 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 state…

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…

فشل التحديث (postgresql)

الدعم تثبيت

noezDE (noez.de) 3 يونيو 2020، 5:54م 8

تم حل المشكلة بتشغيل الأمر chown -R postgres postgres_data

في /shared بعد الدخول إلى حاوية Docker.

8 إعجابات

PostgreSQL 13 update from PostgreSQL 10 fails

الموضوع		الردود	مرات العرض
Upgrade of postgres failed Self-hosting	1	1110	25 سبتمبر 2020
PostgreSQL 13 update from PostgreSQL 10 fails Self-hosting	10	2569	13 أكتوبر 2021
Rebuild fails: Data directory /shared/postgres_data must not be owned by root Self-hosting	5	534	5 فبراير 2025
Trouble with postgre（maybe） Self-hosting	5	1689	13 أغسطس 2020
Postgres upgrade success loop due to prior postgres 8 to 10 migration Self-hosting	4	1190	25 يونيو 2020

فشل التحديث (postgresql)

الموضوعات ذات الصلة