Database configurationΒΆ

Decide where to install the PostgreSQL database. Most of the times installing the on the database on the same machine is ok.

Install PostgreSQL and PostGIS

sudo apt install postgresql postgis

Change the postgreSQL password

sudo -u postgres psql -c "alter user postgres password 'postgres';"

Note

replace the example password with something stronger if you like

Create the istSOS database

sudo -u postgres createdb -E UTF8 istsos
sudo -u postgres psql -d istsos -c 'CREATE EXTENSION postgis'

Now your istSOS server is ready to be used.