[postgis-users] How to load postgis enabled database from one machine to another?

Brent Wood pcreso at pcreso.com
Mon Jul 2 13:04:32 PDT 2007

--- Jessica Richard <rjessil at yahoo.com> wrote:

> I need to load a postgis enabled postgres database from on machine to
> another, I got a long list of errors. Some of them are pointing to the
> postgis path on the first machine, while on the second machine, the postgis
> was installed in different location.  Thanks.

I've done this in a single step, using the psql client on one host to access
the Postgres server on the other, along the lines of:

pgdump --create db1 | psql -h <host2> 

Does Postgis work correctly, and are both systems running the same (or at least
a compatible) version? 

Brent Wood

More information about the postgis-users mailing list