As a result of a cloud provider failure, we lost our production forum. There are only Postgres database backups. Can you tell me what is the correct sequence of actions when restoring from a database backup? And in general, is it possible? Is there any table inside the database indicating the version of the forum? Thank you very much in advance!

Have you looked at the #sysadmin documentation on this? [image] Manually create and restore Discourse backups Sysadmins As discussed below, a warning for newbies: this is an advanced method! there is an automated, web UI way to restore from backups at /admin/backups which is so much easier. with the method below, no automatic backup is kept of the /var/discourse/containers/app.yml file which contains essential SMTP credentials and SSL customizations. Keep a copy of this offsite whenever you change it. If you are using digital ocean, keep frequent snapshots of your droplets - preferably before each time you run .…

Hi @nahimov :slight_smile: It’s unnecessary to @mention a team member, so I’ve removed it. They often read meta anyway and will reply if they feel it’s needed. There are always many people here, whether the team or not, willing to help. Robert’s link is the standard procedure to follow when restoring the forum. Unless your forum hasn’t been updated for a long time (which is always a bad thing), you should be able to restore your backup on the last Discourse version without issues.

[image] nahimov: As a result of a cloud provider failure, we lost our production forum. There are only Postgres database backups. Was it a standard install? Where are the backups? Are they backups created by Discourse or backups of just postgres taken some other way?

Besoin d'aide s'il vous plaît ! Restaurer le forum à partir de la sauvegarde de la base de données

Assistance produit Installation

merefield (Robert) Février 13, 2023, 10:35 2

Avez-vous consulté la documentation #sysadmin à ce sujet ?

Sujet		Réponses	Vues
Forum update failed – how to restore or reinstall with previous data? Product Support backups	1	209	Septembre 4, 2025
Manually create and restore Discourse backups Sysadmins how-to	13	16694	Juin 16, 2022
Any other way to take backup and restore? Product Support	2	3199	Juin 23, 2019
Restore a backup from the command line Self-Hosting how-to	18	23121	Mai 18, 2025
Can I restore backups from older Discourse versions? Self-hosting	3	2326	Octobre 5, 2018

Besoin d'aide s'il vous plaît ! Restaurer le forum à partir de la sauvegarde de la base de données

Sujets connexes