PostGIS

Install PostgreSQL

Install PostGIS

Create database

First, connect to the postgres database as the postgres user (admin).

CREATE ROLE wissle WITH PASSWORD 'wissle' LOGIN;
CREATE DATABASE wissle OWNER wissle;

Install extension

First, connect to the wissle database as the postgres user, DON'T DO THIS IN THE postgres DATABASE.

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
CREATE EXTENSION postgis_tiger_geocoder;