Proposed Architecture
Development Timeline
...
141.142.209.176
...
Install Postgres and postgis
create/import database
...
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)
...