We’re running postgres v12 as the v13 upgrade requires too much disk space. It looks like compatibility with v12 may have been broken? Is this deliberate? If so it means we can never upgrade Discourse again. Running ./launcher start app got us back online so it isn’t a production issue right now, b…

Fixed in Fix #551 regression on old pg main ← fix-551-regression merged 07:45PM - 26 Aug 21 UTC (UTC) [Bild] xfalcox …

its looking for postgress 13 and not 12. {“filename”=>“/etc/postgresql/13/main/pg_hba.conf”,

[Bild] Wingtip: We’re running postgres v12 as the v13 upgrade requires too much disk space. Why don’t you back-up, create a totally fresh discourse instance (which should default postgres 13), restore back-up and remap the server in DNS?

That would work, yes. Desperately trying not to have to do that.

Might seem scary, but you’d have enough safeguards there, you can always bring the old server back online.

It’s less scary than annoying work I’d like to avoid, combined with telling my forum they’re going to lose a day or two of posts. Would like the Discourse guys to say “Of course we still work on PG12, that’s just a bug, we’ll get that fixed up” ideally.

I can’t see why that’s necessary. Prepare new server on subdomain? Enter read-only mode on existing server, create back-up Pull in back-up on new server Remap DNS Rebuild new server with primary discourse subdomain. This process could take 30 mins?

Ah! A nice problem to have! :slight_smile:

I suppose, it’s not like I’m paid! :wink:

Discourse bei postgres 12 bricht Upgrades

Unterstützung Installation

Falco (Falco) 26. August 2021 um 19:53 15

pg_upgrade bietet eine einzelne Option --link, um Upgrades am selben Ort zu ermöglichen.

Wir haben uns dafür entschieden, diese in unserem „einsteigerfreundlichen

1 „Gefällt mir“

Upgrade Postgres with REALLY limited space

Thema		Antworten	Aufrufe
Rebuild fails on db:migrate w/PG12 Self-hosting	18	2042	31. Dezember 2022
Upgrade failed: PostgreSQL version 13 ... not compatible with ... version 10.12 Self-hosting	7	1583	17. April 2021
PostgreSQL 12 update Announcements	1	15709	1. Dezember 2023
Old Postgres on Docker Image with two containers: web and data Self-hosting two-container	10	1576	18. Dezember 2020
Problem with upgrading the latest version Self-hosting	8	2880	22. Juli 2020

Discourse bei postgres 12 bricht Upgrades

Verwandte Themen