On the command line, perform the following steps:
- Even though a backup file was created in this chapter's third recipe, create a new backup file by executing the following command:
> pg_dump -U me -f chapter10.backup -F custom chapter10
- Create a new database to which the backup file will be restored by executing the following commands:
> psql -d postgres -U me postgres=# CREATE DATABASE new10;
- Connect to the new10, database and create a postgis schema as follows:
postgres=# \c new10 new10=# CREATE SCHEMA postgis;
- Execute the CREATE EXTENSION command to install the Postgis extension in the postgis schema:
new10=# CREATE EXTENSION postgis WITH SCHEMA postgis;
- Make sure you set the search_path parameter to include ...