The documented procedure on the forums lists two methods of upgrading Postgres. Just let Discourse handle it. This requires 3 times the disk space. So if your DB is 100GB, you would need an additional 200GB free to do the upgrade. Obviously a huge problem for people with large installs. Follow the…

[画像] Wingtip: Run the command below, which will require a very small amount of additional disk space. So if your DB is 100GB, it might require, say, an additional 10GB? And if so, is this a recommended procedure by the Discourse devs, and has anyone actually done it before and lived to tell the …

No I’m not sure, I don’t have much experience with postgres and was hoping one of the discourse devs could provide some assurances it would work. Even if it does work I also wouldn’t recommend it as the default upgrade procedure as the old way keeps a separate copy of the DB for rollback. If it wor…

Another easy way is to spin up a new server, migrate the data, and turn off the old one. If you must use the old one, do the upgrade on a temporary server, so a fresh install on the original server (which probably needs an OS upgrade) and move it back. That’s safe, easy, and well documented. Hundre…

Yes, but that would take a day or two. During that time we could either a) tell users their posts during this period will be lost or b) set the forum read-only. Neither is a great solution.

I don’t think that the server would be down a whole lot longer than during the rebuild. And if you move to the new server and stay there, you can leave the old server in read only mode while you make the move. If downtime is your concern then moving to a new server will be much, much better.

We have a pretty big forum, but I’ve never tried restoring a backup so I don’t know how long it would take. We would indeed stay on the new host if we did it. I would like to avoid that due to the extra work/annoyance if possible.

[画像] pfaffman: Another easy way is to spin up a new server, migrate the data, and turn off the old one Yup, as I originally suggested here Discourse on postgres 12 breaks upgrades - #8 by merefield I’d just bite the bullet?

All my posts here have been in an ongoing attempt to avoid doing that.

Did you ever get this upgraded @Wingtip ?

Another way to solve the upgrade with limited space issue is to make a backup, rm - r the postgres directory, rebuild, and then restore the backup. I did this on a site last week.

Postgresのアップグレード、本当にスペースが限られている場合

サポートインストール

merefield (Robert) 2021 年 8 月 30 日午前 6:29 8

はい、私が最初にここで提案した通りです Discourse on postgres 12 breaks upgrades - #8 by merefield

思い切って実行してみるのはどうでしょうか？

トピック		返信	表示
Make (temporary) use of Network Storage for Restores, PSQL Update, Self-hosting	16	343	2025 年 2 月 14 日
Not enough disk space for upgrade when Postgres is upgraded Self-hosting server-resources	7	1072	2018 年 5 月 24 日
PostgreSQL 12 update Announcements	0	15826	2020 年 5 月 12 日
Discourse on postgres 12 breaks upgrades Self-hosting	16	1129	2021 年 8 月 27 日
Docker base image with PostgreSQL 10 released Announcements docker	24	4961	2018 年 11 月 26 日

Postgresのアップグレード、本当にスペースが限られている場合

関連トピック