[postgis-users] How to load postgis enabled database from one machine to another?
schwehr at ccom.unh.edu
Mon Jul 2 10:59:48 PDT 2007
I've done this successfully using pg_dump something like this:
pg_dump --create my_db > my_db.pgdump.sql
scp my_db.pgdump.sql secondcomputer:
psql < my_db.pgdump.sql
If you look inside the sql file, you will see the commands to
recreate the postgis tables. Perhaps postgis is not installed on the
On Jul 2, 2007, at 1:49 PM, Jessica Richard 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.
> Park yourself in front of a world of choices in alternative vehicles.
> Visit the Yahoo! Auto Green Center.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
kurt at ccom.unh.edu
Res. Assist. Professor in Ocean Engineering
Center for Coastal and Ocean Mapping
Chase Ocean Engineering Lab
24 Colovos Road
Durham, New Hampshire 03824
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users