Can we use Common Services Team DB template with Post GIS? - Githubissues

bcgov / wps

Wildfire Predictive Services to support decision making in prevention, preparedness, response and recovery

Apache License 2.0

41 stars 9 forks source link

Can we use Common Services Team DB template with Post GIS? #295

Closed jakemorr closed 4 years ago

jakemorr commented 4 years ago

Describe the task Can we use Common Services Team DB template with Post GIS?

Acceptance Criteria

[x] is it possible?
[x] if it is possible, how should we do it
[x] how much effort would it be to do

Additional context

prefer to use PostGIS DB from the start

Sybrand commented 4 years ago

I've sent rocketchat messages to Gary and Mat asking: "Who's the best resource to ask questions about getting that HA postgresql database into our project? Specifically - we'd want it with PostGIS and wonder how much work it would be making that happen." - waiting for response.

Sybrand commented 4 years ago

I've reached out to #general on rocketchat re. PostGIS in general - Steve Hillier has responded and is sending me a HA PostGis template.
Mat hall also sent this: https://github.com/bcgov/nr-get-token/wiki/High-Availability

Sybrand commented 4 years ago

Steve Hillier: "It would be nice to maybe make a PR to the BCDevOps repo but for now I uploaded a Dockerfile here https://gist.github.com/stephenhillier/17bf0a7365f00c916d80733028f34ae9 It uses the Docker hub Postgres because I based it off the Dockerfile in the BCDevOps repo

It uses the Docker hub Postgres because I based it off the Dockerfile in the BCDevOps repo https://github.com/BCDevOps/platform-services/blob/master/apps/pgsql/patroni/docker/Dockerfile

now that there is an official (I think?) postgis/postgis Docker hub you could presumably install Patroni to that too. If you look in the BCDevOps branches you can also find an experimental RHEL based Dockerfile by cvarjao"

Sybrand commented 4 years ago

Seems very do-able - the platform team has a patroni templates and docker files: https://github.com/BCDevOps/platform-services/tree/master/apps/pgsql/patroni/ and the water team has experience applying PostGIS on top of what they have.

Sybrand commented 4 years ago

I've started exploring this on branch: task/postgis_ha Following the platform teams instructions I easily deployed an instance in our openshift project.

Next steps:

Modify the platform teams code using code from Steve to deploy HA PostGIS.
Deploy ephemeral instance on every dev PR.
Deploy persistance instance in production.