Update PostGIS

[cbcunc]

Abtract

This issue requests an upgrade of the PostGreSQL version used for Hydroshare's Django database server to the latest agreeable version.

Action Items

• [ ] Agreement should be reached in the Monday morning HS developer conference call concerning the latest agreeable version of PostGreSQL {see Version}.
• [ ] Consider in the developer call moving the project to the organization level instead of the repository level {see Project Board}.
• [ ] Revise the PostGIS image Dockerfile {see Dockerfile}.
• [ ] Harmonize the image pull to originate from the Hydoshare Docker Hub organization {see Image}.

Project Board

This issue was opened in hydroshare/hydroshare instead of [hydroshare/hs_postgres])https://github.com/hydroshare/hs_postgres) in order to track it on the HS Issue Management Board project.

Version

Hydroshare beta and production currently run on PostgreSQL 9.4.7. The 9.4 series had its final release on February 13, 2020 (https://www.postgresql.org/support/versioning/) and is unsupported. The latest available version as of the time of this issue creation is 14.2. Hydroshare has been run successfully in an on-demand cloud-based development environment with PostGreSQL 13.1.

Targets

PostGreSQL runs in a docker container (name: postgis) on VMWare VMs on a RENCI internal network (edc.renci.org) as non-routable IPs:

• Production: db1-hydroshare.edc.renci.org
• Beta: db1-beta-hydroshare.edc.renci.org

Staging and development versions of Hydroshare use local containers or local PostGresSQL instances {see POSTGIS_HOST in local_settings.py}.

Dockerfile

On both VMs, the Dockerfile used as the build source for the container's image is taken from hydroshare/hs_postgres.

OS and OS Version

PostGreSQL repository and Key

PostGIS

PGAdmin

Contrib Tools

pg_hba.con

postgresql.conf

docker-entrypoint.sh

Image

On beta, the image is pulled from the Hydoshare organization (https://hub.docker.com/repository/docker/hydroshare/hs_postgres). On production, the image is pulled from the personal repository of the original image author ((https://hub.docker.com/r/mjstealey/hs_postgres).

dockef-compose.yml

New VM

Docker CE Daemon

daemon.json

key.json

docker-compose Client

iptables

local_settings.py

Beta Test

Backup and Restore

Jenkins

Deployment

Saving work on issue... to be continued...