[postgis-users] How to load postgis enabled database from one machine to another?
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?
More information about the postgis-users