[postgis-users] restore dump from one server to another

Steffen Macke sdteffen at gmail.com
Mon Oct 30 21:17:01 PST 2006


Dylan,

> is it possible to take the dump from one postgis database:
> pg_dump -v --format=c --username=postgres > dump.bin
>
> and restore it to another postgis install on a different machine ?

This is definitely possible. However, if the PostGIS versions on
the two machines differ, you may want to use the postgis_restore utility
to restore your dump file. See the PostGIS documentation for the details.

Regards,

Steffen



More information about the postgis-users mailing list