database restore in mendix environment

1
Hi, I'm trying to load data from my local postgres db to the one in mendix environment. I've managed to create a .backup file through cmd line, but when trying to restoredb in m2ee it fails with: ERROR: An error occured while calling pg_restore: pg_restore: [archiver] unsupported version (1.12) in file header I am running postgreSQL 9.0.4 localy. How can load up the data in mendix enviornment? LR.
asked
2 answers
3

Have a look at: http://stackoverflow.com/questions/4599696/use-pg-restore-to-restore-from-a-newer-version-of-postgresql, this might be the same issue and the solution is posted here.

answered
1

In Mendix hosting, you can restore .backup files that are created with the pg_dump program from either PostgreSQL 8.3 or 8.4, not 9.x yet.

I recommend using 8.4 locally.

answered