Skip to content

Improve PostgreSQL replication documentation/runbooks

Our guides need to state:

  • How to set up replication (both a primary and N secondaries)
  • How to perform a failover
  • That pg_basebackup might hang for 10 minutes while not producing output (while waiting for a primary to respond)
  • What files need to be placed where
  • Where the credentials for the gitlab_replicator user are stored (1Password, Chef vaults, etc)
  • What graphs/monitoring we have to help out engineers (e.g. links to individual dashboards in Grafana)

@jnijhof I'm assigning this to you since you know the most about this aspect. Feel free to re-assign if necessary.