Question

Howto restore 9.1 database in 8.4 cloud environment

1

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??

asked 2012-03-30

Pieter Spiekman 🎺

4 answers

Georg Holz · Answer 1 · 2012-04-02

Hi Peter,

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

Pieter Spiekman 🎺 · Answer 2 · 2012-04-02

Hi Georg,

Thnx for the answer, I have tried it and it works.

Ronald Catersels · Answer 3 · 2012-03-30

May be this trick could be usefull: postgres 9 to 8

Shan · Answer 4 · 2012-10-01

How can i import the dump files from the postgres 9.1.i need to export that dump file to another psotgres 9.1 which is installed in cloud