A user, nahimov, seeks guidance on restoring a Discourse forum from a PostgreSQL database backup after losing their production environment due to a cloud provider failure. merefield directs them to the official documentation for manual backup and restore procedures. Canapin reassures that restoring on the latest Discourse version is generally feasible and advises against unnecessary @mentions. pfaffman asks clarifying questions about the install type and backup method to ensure the restoration process is properly understood.
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?
Hi @nahimov 
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.
Was it a standard install?
Where are the backups? Are they backups created by Discourse or backups of just postgres taken some other way?