Install PostGIS on macOS

how-to-install-postgis-on-macos.md

1. install postgis

   $ brew install postgis

2. start PostgreSQL service

   $ brew services start postgres

   stop PostgreSQL service

   $ brew services stop postgres

3. create superuser

   $ createuser --superuser "$(echo $USER)"
   $ createdb "$(echo $USER)"

4. install PostGIS extension in PostgreSQL
   1. login to postgresql commandline mode

      $ psql

   2. create postgis extension

      =# CREATE EXTENSION postgis;

   3. check postgis extension version

      =# \dx

      and you'll probably see a line as below:

      postgis  | 2.3.2   | public     | PostGIS geometry, geography, and raster spatial types and functions
      

That's all. Enjoy coding.