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
