-
Notifications
You must be signed in to change notification settings - Fork 59
Closed
Description
It is becoming more frequent that we need to open psql shells to databases on clusters.
The steps are roughly:
- inspect the app/Canton deployment that uses the databases, copy IP and database name from there; example
kubectl describe pod -n sv-8 -l app=global-domain-6-sequencer | grep -i psql - inspect the k8s secret that said deployment uses for the postgres password; example
kubectl get secret -n sv-8 sequencer-6-pg-secrets -o jsonpath={.data.postgresPassword} | base64 -d - open a
cncluster debug_shellandpsqlfrom there - (optional) do
SET search_path <target_schema>for a nicer UX
We could automate this process via adding a nice cncluster command.
Metadata
Metadata
Assignees
Labels
good first issueGood for newcomersGood for newcomers