...
...
141.142.209.176
...
Install Postgres and postgis
create/import database
create medici role and grant priviledges
...
sudo apt-get install postgresql-9.5-postgis-2.2
...
- medici
- superuser?: n
- create dbs?: n
- create new roles?: n
...
sudo -u postgres createdb geostream
...
sudo -u postgres psql -d geostream -c 'GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO medici;'
...
sudo -u postgres psql -d geostream -c 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO medici;'
...
copy over small db from local (change role of db to medici)
...
sudo -u postgres psql geostream < geostream_one_greon.sql
...
/etc/postgresql/9.5/main/postgres.conf add
listen_addresses = '*'
/etc/postgresql/9.5/main/pg_hba.conf add host all all 0.0.0.0/0 md5
hostssl all all 0.0.0.0/0 md5and tried (but unable to login with psql)
host all all * md5
...