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

Kurt Schwehr 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:

   ssh 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  
2nd computer?


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
> http://postgis.refractions.net/mailman/listinfo/postgis-users

kurt at ccom.unh.edu
o: 603-862-1159
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...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070702/84acc8c3/attachment.html>

More information about the postgis-users mailing list