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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
[EMAIL PROTECTED]
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
