Home / server / Questions / 401270
In Process
Mnementh
Asked: 2012-06-23 02:43:14 +0800 CST

How to import a dump in Postgres from a newer version?

  • 772

We have a postgres-databse under windows, that is version 9.1. From that we want to dump the data and import under a Linux-server, that runs Postgres 8.4. The data include spatial data with Postgis.

The problem is, that the dump doesn't import, as it uses commands like 'CREATE EXTENSION ..' that can't be understand on the older Postgres. Is there a way to transfer the data between these databases?

postgresql dump postgis

1 Answers

  1. You have two choices:

    1) Install on Linux Postgresql v9.1

    2) Remove from dump every command, which Postgresql v8.4 doesn't know.

    EDIT:

    You can do two exports - first only structure of database (pg_dump -s) and then only data (pg_dump -a). Then you can edit only one file...

    • 3