NAME

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

SYNTAX

       postgis_restore [-v] [-L TOC] [-s schema] dumpfile

DESCRIPTION

       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 CREATE
       EXTENSION 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
       crated with pg_dump -Fc.

USAGE

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

EXAMPLES

       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

AUTHORS

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

       More information is available at http://postgis.net

                                                                               postgis_restore(1)