FlowFuse/flowfuse

Clarification on K8s Cron backup procedure for Postgres DB

Closed this issue · 0 comments

Description

When configuring the CRON job to execute the pg_dump against Postgres, we encountered an issue where the helm contains an ingress rule that prevents containers from connecting if they don't have app: flowforge as a label.

Error produced:
pg_dump: error: connection to database "flowforge" failed: could not connect to server: Operation timed out
Is the server running on host "flowforge-postgresql.flowforge.svc.cluster.local" (0.0.0.0) and accepting
TCP/IP connections on port 5432?

To Fix:
Added the following to the yaml file for the postgres-backup:

metadata:
  name: postgres-backup
  labels:
    app: flowforge

Following this update we were able to execute the schedule.