Postgis Install

• install 2d postgis, 3d postgis

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;

ALTER EXTENSION postgis UPDATE;
ALTER EXTENSION postgis_topology UPDATE

CREATE EXTENSION postgis_raster;
CREATE EXTENSION postgis_sfcgal;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
CREATE EXTENSION postgis_tiger_geocoder;

PostGIS

PostGIS has many packaged installations, but if you are more adventurous and want to compile your own, refer to our source download and compilation instructions: Binary distributions of PostGIS are available for various operating systems. More details about getting up and running with windows can be found on Windows Downloads page.

https://postgis.net/install/