|
|
| - As Ubuntu user:
- sudo apt-get update
- sudo apt-get install postgresql postgresql-contrib
sudo apt-get install postgresql-9.5-postgis-2.2 - sudo -u postgres createuser --interactive
- 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
|
|