Skip to content

Instantly share code, notes, and snippets.

@CHERTS

CHERTS/get_root_ca_percona_everest.sh

Created May 30, 2024 08:07
Show Gist options
  • Save CHERTS/8a49c54642d1f287ecef64a99275dde5 to your computer and use it in GitHub Desktop.
Save CHERTS/8a49c54642d1f287ecef64a99275dde5 to your computer and use it in GitHub Desktop.
Download ZIP
Get root ca for Percona Everest (PostgreSQL)
Raw
get_root_ca_percona_everest.sh
#/bin/bash
EVEREST_ENV=prod
mkdir ~/.postgresql
touch ~/.postgresql/root.crt
kubectl get secrets/pgo-root-cacert -n ${EVEREST_ENV} -o jsonpath="{.data['root\.crt']}" | base64 -d >> ~/.postgresql/root.crt
# psql "host=127.0.0.1 port=5432 dbname=postgres user=postgres password=XXXXXX sslmode=prefer"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment