PostgeSQL + PostGIS installation for NextGIS Web

gistfile1.txt

# apt install postgresql postgresql-contrib postgis
# su postgres
$ cd
$ createuser --pwprompt nextgisweb
Enter password for new role: [type database password here]
Enter it again: [type database password here again]
$ createdb --owner=nextgisweb nextgisweb
$ psql nextgisweb -c "CREATE EXTENSION postgis"
$ psql nextgisweb -c "ALTER TABLE spatial_ref_sys OWNER TO nextgisweb"
$ psql nextgisweb -c "ALTER TABLE geography_columns OWNER TO nextgisweb"
$ psql nextgisweb -c "ALTER TABLE geometry_columns OWNER TO nextgisweb"
$ psql nextgisweb -c "ALTER TABLE raster_columns OWNER TO nextgisweb"
$ psql nextgisweb -c "ALTER TABLE raster_overviews OWNER TO nextgisweb"
$ psql nextgisweb -c "CREATE EXTENSION hstore"