search

dancingsushii / geo-specific-diffpriv

Plugin for PostgersSQL achieving data minimisation with a help of differential privacy on geospatial databases.
MIT License
0 stars 0 forks source link

GCP: Create VM with postgres & postgis installed #4

Closed mariidpm closed 2 years ago

mariidpm commented 2 years ago

Document the steps

mariidpm commented 2 years ago

VM created.. need to: create a user/keys which we can all use install postgres enable postgis extension

mariidpm commented 2 years ago

Created and used 'ubuntu' user (which should work for everyone as I passed the creds to the vm), to connect with this user: gcloud compute ssh ubuntu@vm-postgis-01 --zone=europe-west3-c

Installed postgres and enabled postgis in the vm, Created a test geo db: 'pengtest' and a test table 'citiestest'

Note: I also validated that I can connect with my own username and still access postgres/postgis

To access postgres/postgis from vm and query the test table: sudo -u postgres psql \connect pengtest SELECT * FROM citiestest;

I'll add further details to the wiki later today or tomorrow