Skip to content

NodeJS PostGis Ressources

Romain Tourte edited this page Sep 25, 2019 · 3 revisions

postgresql-nodejs-tutorial

 brew install postgres

Start the server

 pg_ctl -D /usr/local/var/postgres start

Check

 export PGDATA='/usr/local/var/postgres'
 pg_ctl status

Create Database

If that’s a fresh installation, we need to initialize the database cluster:

 initdb /usr/local/var/postgres
 createdb postgis_oceanSensors

Enable PostGIS

We’ll use the psql command line utility to connect to the database that we’ve just created:

 psql postgis_oceanSensors

Config Postgres SQL Access

into postgrsql.conf

 listen_addresses = '*'

into pg_hba.conf

 host all all 0.0.0.0/0 md5

Clone this wiki locally