Clarification on K8s Cron backup procedure for Postgres DB
Closed this issue · 0 comments
sharpernb commented
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.