postgres

Edit on GitHub	/services/postgres
Type	Helm
Namespace	postgres

Overview

The postgres service is a very small PostgreSQL installation. It is intended to provide persistent relational storage for low-value databases that it isn’t a tragedy to lose.

Do not use this service for important data. Use a managed relational database such as Google CloudSQL. Two intended purposes for this service are:

1. The JupyterHub user session database

2. Backing store for Gafaelfawr’s authentication tokens

If either of those is destroyed, then all current user sessions and authentication tokens are invalidated, work up to the last checkpoint (5 minutes in JupyterLab) may be lost, and users will have to log in again, restart their sessions, and recreate any authentication tokens. While irritating, this is not the end of the world; hence “low-value databases.” (That said, production instances of the Science Platform use CloudSQL for the Gafaelfawr token database.)

Upgrading postgres is generally painless. A simple Argo CD sync is sufficient.

Guides

• Recreating postgres PV/PVC
• Adding a new database
  • Decide on a database name
  • Add the database to charts
  • Add the database to phalanx
  • Manually add the secret to Vault
  • Restart with new values