Skip to content

Instantly share code, notes, and snippets.

@mjgarton

mjgarton/cp_dev_cdb.sh

Created February 22, 2019 14:12
Show Gist options
  • Save mjgarton/bba5f885058a7afe4971557e911ad45d to your computer and use it in GitHub Desktop.
Save mjgarton/bba5f885058a7afe4971557e911ad45d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cp_dev_cdb.sh
kubectl --context=dev-aws -n customer-platform port-forward cockroachdb-1 26257:26257 &
kubectl --context=dev-aws -n customer-platform exec -ti cockroachdb-1 cat /cockroach/cockroach-certs/node.key >/tmp/node.key
kubectl --context=dev-aws -n customer-platform exec -ti cockroachdb-1 cat /cockroach/cockroach-certs/node.crt >/tmp/node.crt
chmod 600 /tmp/node.crt /tmp/node.key
PGSSLCERT=/tmp/node.crt PGSSLKEY=/tmp/node.key PGCLIENTENCODING=utf8 psql -w "postgresql://root@localhost:26257/itemdb?sslmode=require"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment