Page History

Install Postgres and postgis

create/import database

create medici role and grant priviledges

• 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

• /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 md5

  and tried (but unable to login with psql)

  host     all   all   *   md5

  hostssl  all   all   *  

  •   md5