postgres — In-cluster SQL store

The postgres service is a very small PostgreSQL installation to provide relational storage for applications and environments where data loss is acceptable. Two intended purposes for this service are:

• The JupyterHub user session database

• Backing store for Gafaelfawr’s authentication tokens

It may also be used by other applications, such as exposurelog and narrativelog.

Important

Do not use this service for important data. Use a managed relational database, such as Google CloudSQL, instead.

Production instances of the Science Platform use CloudSQL or a local external PostgreSQL server for the Gafaelfawr token database instead of this service.

View on GitHub	applications/postgres Application template
Source	lsst-sqre/rsp-postgres
Type	Helm
Namespace	postgres
Environments	ccin2p3 values Argo CD idfint values Argo CD idfprod values Argo CD minikube values roe values Argo CD summit values Argo CD usdf-tel-rsp values Argo CD usdfdev values Argo CD usdfint values Argo CD usdfprod values Argo CD

Guides

• Adding a new database
  • Decide on a database name
  • Add the database to the deployment
  • Add the secret for the database
  • Restart with new values
• Troubleshooting postgres
  • Recreating postgres PV/PVC
• postgres Helm values reference