postgis_restore - restore a PostGIS database from an archive file created by pg_dump

       Originally written by Sandro Santilli <strk@kbt.io>.

       More information is available at http://postgis.netpostgis_restore(1)

       The  postgis_restore command allows extracting SQL statements to re-create objects found in a custom dump
       of a PostGIS-enabled database while skipping the PostGIS specific objects.

       This is only useful for dumps of databases in which  PostGIS  was  enabled  by  loading  the  postgis.sql
       script.  Dumps  taken  from  databases  in  which  PostGIS was enabled via CREATEEXTENSION will not have
       PostGIS objects in them so can safely be restored directly using pg_restore.

       Note that this command only works with dumps using the  custom  format,  which  are  those  created  with
       pg_dump-Fc.

       Create a custom dump from olddb:

            pg_dump -Fc olddb > olddb.dump

       Create a new database newdb:

            createdb newdb

       PostGIS-enable the new database:

            psql -c 'CREATE EXTENSION postgis' newdb

       Restore your data:

            postgis_restore.pl olddb.dump | psql newdb

       postgis_restore - restore a PostGIS database from an archive file created by pg_dump

       postgis_restore [-v] [-LTOC] [-sschema] dumpfile

       Usage information is printed when the script is invoked with no arguments.