I just had a little adventure in restoring the FME Server (we are on 2022) configuration database - that is the internal postgres database for configuration and job history. We will move it to mssql eventually...

I managed to hose our test server the other day - it is this problem I wrote a post about here:

Now we have had a scheduled job that creates a full pg_dump backup of the data, and the latest run was just 2 days old! We have had the backup system in place, but we have never had to do a restore - the backup is also for archiving the history.

It took a lot of trial and error and experimentation to figure out how do it, but eventually I got there.

* Drop the fmeserver database
* Recreate the database
* Restore from backup (schema + data)
* Grant permissions

Here are my more detailed notes...
https://lnkd.in/dz-usUSU