20

I have a PostGIS installation running on an old computer that I'd like to move. I spent a bunch of time playing with pg_dump and pg_dumpall without success. It seems the normal dump procedures don't work with PostGIS because file paths get hard coded in the output from pg_dump. Any suggestions on how to move PostGIS installation to a new installation of PostgreSQL?

  • I fail to see how "Using a schema other than public" is related to this question. – Matthias Kuhn Apr 29 at 19:54
9

I'd suggest moving all your data tables into a schema, then dumping just that schema. then you can easily restore not only on a different computer, but into different versions of PostGIS and PostgreSQL.

Storing your data in a schema other than "public" is a Best Practice.

| improve this answer | |
8

This post http://traviscline.com/blog/2010/04/28/moving-postgis-databases-between-machines/ seems to indicate that pg_dump -Fc is what you want.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy