I wrecked my Discourse install at forum.atlas-games.com. I had to update to PostgreSQL 12 but only had 11GB free for my 7GB database and kept throwing errors, so I used used the “manual update” method here: PostgreSQL 12 update All seemed to work well (no errors), but now my site is reset to default and wants to me to re-register and set it up from scratch … no posts, no users, no settings. I know I have backups … we pay the $2/mo for Digital Ocean to take weekly backups (looks like they’re 3 days old, though), and the forum’s own internal backups seem to be accessible (4 days old), but I’m hoping I didn’t actually lose my data and there’s a way to reassociate it. I ran “./launcher cleanup” though. Thanks for any help.

I checked my database size via terminal command: du -h /var/discourse/shared/standalone/postgres_data My database was down to 83MB from 7GB previously. So it seems to have really been overwritten by the update. I ran ./launcher cleanup as part of the PostgreSQL update (as per the update directions), so there’s nothing to go back to except my backups. Discord wasn’t just disconnected from the database somehow. I restored my backups, I can live with losing a couple of days of posts (my own fault for not backing up before updating). I just wish I knew why the PostgreSQL update overwrote my database, since I’m going to have try do it again eventually.

PostgreSQL update wrecked my forum. Please help!

Product Support Self-hosting

IAmGav (Gavin Perch) October 23, 2021, 8:57am 3

I would suggest, in the future only run ./launcher cleanup once your site is up and running and everything is working 100%.

and always backup when you do a big change like this

Topic		Replies	Views
PostgreSQL 12 update Announcements	0	16047	May 12, 2020
Problem with upgrading the latest version Self-hosting	7	3153	June 22, 2020
Trouble with latest update Self-hosting	2	1020	May 20, 2020
Trouble updating discourse after some time - UPGRADE OF POSTGRES FAILED Product Support	5	337	November 21, 2025
Trouble with update 2.5.0.beta4 to 2.6.0.beta2 (probably Postgres) Self-hosting	4	697	September 1, 2020

PostgreSQL update wrecked my forum. Please help!

Related topics