Proposed Architecture
Development Timeline
...
141.142.209.176
...
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
...
- create user gltgdev and grant permissions
- createuser gltgdev
ALTER USER gltgdev WITH ENCRYPTED PASSWORD 'password';
psql -h 141.142.209.176 -U gltgdev -d geostream
connect gltg-dev to gltg-postgres
in custom.conf (yay, it works)
postgres.user="gltgdev"
postgres.host="141.142.209.176"
postgres.password="*****"
...
- 141.142.209.172
- 141.142.209.173
- 141.142.209.174
...
- on gltg-dev
sudo mongodump --out /home/marcuss/backup/test_mongo_dump/test1
scp to target server
on gltg-mongo-1
sudo /var/lib/mongodb-mms-automation/mongodb-linux-x86_64-3.4.9/bin/mongorestore -d gltg --drop /home/ubuntu/test1/gltg
opening mongo shell gives warnings:
171102 - checked with rob - he's fixing stuff
...
- 141.142.210.210
...
- 141.142.210.220
Notes meeting Rob 171027
mongo - need to run commands in primary instance?
illinois - separate clowder and geodashboard servers, separate postgres and mongo databases on same servers
...