Data migration

Foreman version - 1.22
DB: postgres

our production environment
I created a test environment

I took a pg_dump of foreman database of production instance and tried uploading it to test environment. For this i deleted the foreman db of test instance and uploaded production pg_dump of foreman database to test instance. upload was successful but not able to bring back foreman service up and running.

when i tried opening the web ui, I see the below error. please help what i am doing wrong and how to fix it.

Service unavailable ERF64-6496 [Foreman::MaintenanceException]: There are migrations pending in the system.



just a wild guess based on the error message you recieved, could it be you have different versions of Foreman in testing and production? Maybe only by a minor version?
You can try running foreman-rake db:migrate on your test instance and see how far that brings you.