Check registry patroni setup in gprd

After standing up the registry Patroni cluster in production we should check if it is ready to be used by the container registry:

  • db console access for devs
  • gkms vault being setup with correct db credentials
  • db password working to connect to the DB
  • primary pgbouncer LB hostname: pgbouncer-registry.int.gprd.gitlab.net
  • consul DNS entries are resolved on pgbouncer and patroni nodes: replica.patroni-registry.service.consul and master.patroni-registry.service.consul
  • wal archiving on the primary
  • db backups
  • dr replicas
  • db backup restore tests
  • DB tuning (connection pool size)
  • DB grants, tables, privileges
Edited by Henri Philipps