Creating Extensions v3.1.2
After installing PostGIS, create a PostGIS database and the extensions in each database you wish to use PostGIS extensions. You must not create the extensions in the
Before creating the
postgisdatabase, we recommend creating a superuser to administer the database. To create the user, navigate into the bin directory under your Advanced Server installation and connect to the server with the psql client:
Invoke the following command to create a privileged role:
Log out of psql and connect as
Invoke the following command to create the
postgisdatabase owned by
\ccommand to switch to the
postgisdatabase, and use the
CREATE EXTENSIONcommand to create the PostGIS Extensions:
The postgis-sfcgal extension is not available on Ubuntu 18, Ubuntu 20, SLES 12, RHEL/CentOS 7 - ppc64le, and Windows platforms.
When connected with pgAdmin, you should now see PostGIS extensions, functions, tables, and trigger functions beneath the
postgis database public schema. The
postgis database is now geospatially enabled and can be used as a template to create new Geospatial databases.
Fig. 8: Extensions on PgAdmin