Skip to main content
Solved

Does anyone know how to migrate the job history from an FME Cloud instance?

virtualcitymatt
Celebrity
Forum|alt.badge.img+38

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?

Best answer by gerhardatsafe

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.
View original
Did this help you find an answer to your question?

3 replies

J
Forum|alt.badge.img+2

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!
virtualcitymatt
Celebrity
Forum|alt.badge.img+38
jlutherthomas wrote:

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
G
Forum|alt.badge.img

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


Helpful Members This Week

Community Stats

31,473
Posts
119,315
Replies
39,088
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.