Howto restore 9.1 database in 8.4 cloud environment
I have developped a application using PostgreSQL 9.1 on my local machine. The application is now filled with a lot of sample data which i prefer not to enter again. The cloud environment runs with PostgreSQL 8.4 and does not offer me the possibility to restore a 9.1 database. Is it possible to convert a 9.1 database to 8.4, or is there a work around to import the data from the 9.1 environment into a 8.4 database??
Pieter Spiekman 🎺
this is how I did it:
1) Use pgadmin (9.1) and export a dump from your 9.1 server
2) Use pgadmin (9.1) and import this dump on a 8.4 server
3) Use pgadmin (8.4) and export a new dump from the 8.4 server
--> you have a dump that you can upload to the cloud
Thnx for the answer, I have tried it and it works.