The export pg_dump -F c geoview > geoview.dump The import sh /usr/share/postgresql/8.1/contrib/postgis-1.2.0/utils/postgis_restore.pl /usr/share/postgresql/8.1/contrib/postgis-1.2.0/lwpostgis.sql geoview2 /var/tmp/geoview.dump