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.
Luis Rodrigues (hotmail)
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.
Erwin 't Hoen
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.