gistfile1.txt

k exec -ti deployments/psql -n kedify -c psql -- pg_dump --user dashboard-service-account@kedify-initial.iam --host 127.0.0.1 -d kedify --inserts > db.dump
psql --user postgres --host 127.0.0.1 -f db.dump


#docker cp db.dump 02a749fdba3a:.

#docker exec -ti 02a749fdba3a  bash
#psql --user postgres --host 127.0.0.1 -f db.dump

sql cheatsheet

# clusterId, agentId and cluster name

SELECT 
  clusters.name, 
  agents.id AS agentId, 
  clusters.id AS clusterId 
FROM clusters JOIN agents 
ON clusters.id = agents.cluster_id;