Page History

...

Date

New Piece Name

IP

Action (normal letter = commands, italics = description)

Notes

171020

gltg-postgres

141.142.209.176

As Ubuntu user:
sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
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

Space shortcuts