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

[Kurt Schwehr]

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?

-kurt

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
http://vislab-ccom.unh.edu/~schwehr/
http://schwehr.org/
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>