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

[Brent Wood]

--- 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