Hey posting here after trying everything and got stuck with my upgrade. I was updating the forum after many months. I ran a backup as usual and downloaded it. Apparently, in this update process, there is a migration from PG 13 to 15. Everything was running with no issues until the update failed I…

Update: I still trying things. At this point, I just want to go back to a buld that supports PG13 so I can restore my backup, but I still blocked trying that. The commit hash before the upgrade was v3.3.0.beta6 +294, im trying to re-build that one vie YML but still saying this when building up: r…

If you made a backup like you said you did, the easiest thing is to spin up a new droplet, follow Move a Discourse site to another VPS with rsync (but do not copy the database files), and then restore your backup.

[imagem] pfaffman: If you made a backup like you said you did, the easiest thing is to spin up a new droplet, follow Move a Discourse site to another VPS with rsync (but do not copy the database files), and then restore your backup. Hy [imagem] pfaffman: If you made a backup like you sai…

That’s it. See also Restore a backup from the command line

Thanks again, Jay, for responding. I really appreciate your time helping me through this nightmare. I’m trying to do it that way (forcing the version in the YML) but apparently discourse_docker is not happy (yet) with that change: FAILED -------------------- Pups::ExecError: grep -q 'outlets/befor…

[imagem] skozz: forcing the version in the YML Don’t do that. Just do a normal install of the latest version of everything and restore the database.

[imagem] pfaffman: Just do a normal install of the latest version of everything and restore the database. Understood, I will try right now. However, quick question: If the backup is from an old version of Discourse that were using PG13, will I have problems importing the backup into the late…

Sorry @pfaffman I wrote a previous message thinking the problem was gone but then a plot twist happened. After a long time importing, I saw how the forum was online again listing all the posts and so on. In the terminal, the log was: [...] -- execute("DELETE FROM site_settings WHERE name='warn_r…

Update: Logged into the rails console, and apparently the are only 10 posts, not all the ones to be imported :thinking: /var/www/discourse# rails c Loading production environment (Rails 7.2.2.1) discourse(prod)> Post.count => 10 discourse(prod)> Post.where(“baked_version IS NULL”).count => 0 …

Sigh. Are you using the same hostname? (Maybe so?) [imagem] skozz: EXCEPTION: 903 posts are not remapped to new S3 upload URL. S3 migration failed for db 'default'. That’s your problem now. Did you configure S3 in the database or in the yml file? I guess it’s the former. The easiest thing …

Preso e perdido ao atualizar o fórum, problemas com a migração PG

Suporte Instalação

pfaffman (Jay Pfaffman) Junho 11, 2025, 10:38am 5

É isso.

Veja também Restaurar um backup da linha de comando

Tópico		Respostas	Visualizações
Forum not working after update – what’s missing? Self-hosting	35	660	4 de Setembro de 2025
Upgrade failed spectacularily Support	25	877	10 de Fevereiro de 2025
Forum crashes after upgrading from 2.4.0 Self-hosting	9	1491	4 de Julho de 2020
Upgrading old version 2.8.5 issues Self-hosting	26	480	15 de Dezembro de 2025
An upgrade knocked my site offline; how long until it's restored? Self-hosting	15	426	10 de Julho de 2025

Preso e perdido ao atualizar o fórum, problemas com a migração PG

Tópicos relacionados