Skip to main content

Just going through the motions of upgrading an FME Cloud instance and I'm looking for a way to migrate the job history into a new instance.

 

I know, however, that this isn't supported with the backup and that some db work is required (https://knowledge.safe.com/articles/816/fme-server-job-history.html)

 

The problem is that I can't seem to access the fmeserver schema.

 

 

My work around will be to use the REST API to get the data and create my own job history table but I would rather avoid that if possible. Am I missing something here?

Hi @virtualcitymatt!

 

 

I do not recommend importing historic job history into your new instance (as described in the article you linked). However, should you decide to proceed I would suggest that you backup your instance beforehand and do some testing afterwards.

 

 

We have instructions on how to access the fme cloud database here: https://docs.safe.com/fme_cloud/FME_Cloud/Content/About_Instances/Connect_to_PostGIS_Database.htm#Connect_to_database

 

 

Hope that helps!

Hi @virtualcitymatt!

 

 

I do not recommend importing historic job history into your new instance (as described in the article you linked). However, should you decide to proceed I would suggest that you backup your instance beforehand and do some testing afterwards.

 

 

We have instructions on how to access the fme cloud database here: https://docs.safe.com/fme_cloud/FME_Cloud/Content/About_Instances/Connect_to_PostGIS_Database.htm#Connect_to_database

 

 

Hope that helps!

Thanks for the help Jen, but this Database just seems to be an empty PostGIS database. I can't see the FME Server database tables. I guess that I'm not supposed to and that's ok. It makes sense for sure.

 

In the end I just used the REST API to back up the job history data a remote location (what I really should have been doing the whole time).

 

 

Thanks again

 

Matt

On FME Cloud you do not have access to the FME Server System Database. Therefore it is not supported to migrate the job history from one instance to another.

 

 

The PostGIS database that comes with an FME Cloud instance is provided for rapid prototyping and getting started with scenarios quickly. It is not the same database as the FME Server System Database.

Reply