Moving a PostGIS Installation

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?

I fail to see how "Using a schema other than public" is related to this question. — Matthias Kuhn, Apr 29 '20 at 19:54

score 10 · Answer 1 · answered Sep 30 '10 at 16:45

10

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.

answered Sep 30 '10 at 16:45

Paul Ramsey

19,865
1
47
57

1

More info here http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html – Paul Ramsey Sep 30 '10 at 17:02

score 9 · Answer 2 · edited Nov 28 '11 at 16:42

9

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.

edited Nov 28 '11 at 16:42

alfonx

1,111
10
13

answered Sep 24 '10 at 17:20

Ian Turton

81,417
6
84
185

Moving a PostGIS Installation

2 Answers2

Linked