<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">I've done this successfully using pg_dump something like this:<DIV><BR class="khtml-block-placeholder"></DIV><DIV> pg_dump --create my_db > my_db.pgdump.sql</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> scp my_db.pgdump.sql secondcomputer:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> ssh secondcomputer</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV> psql < my_db.pgdump.sql</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>-kurt</DIV><DIV><BR><DIV><DIV>On Jul 2, 2007, at 1:49 PM, Jessica Richard wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite">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.<BR><DIV> <BR class="khtml-block-placeholder"></DIV><HR size="1">Park yourself in front of a world of choices in alternative vehicles.<BR><A href="http://us.rd.yahoo.com/evt=48246/*http://autos.yahoo.com/green_center/;_ylc=X3oDMTE5cDF2bXZzBF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDZ3JlZW4tY2VudGVy">Visit the Yahoo! Auto Green Center.</A><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV><A href="mailto:kurt@ccom.unh.edu">kurt@ccom.unh.edu</A></DIV><DIV>o: 603-862-1159</DIV><DIV><A href="http://vislab-ccom.unh.edu/~schwehr/">http://vislab-ccom.unh.edu/~schwehr/</A></DIV><DIV><A href="http://schwehr.org">http://schwehr.org</A>/</DIV><DIV>Res. Assist. Professor in Ocean Engineering</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Center for Coastal and Ocean Mapping</DIV><DIV>Chase Ocean Engineering Lab</DIV><DIV>24 Colovos Road</DIV><DIV>Durham, New Hampshire 03824</DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR class="Apple-interchange-newline"></SPAN></SPAN></SPAN> </DIV><BR></DIV></BODY></HTML>