Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a simple question:

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?

Thanks, SS

share|improve this question

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.

share|improve this answer

This post seems to indicate that pg_dump -Fc is what you want.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.