Skip to content

Instantly share code, notes, and snippets.

@dserodio

dserodio/psql_check_ssl.sql

Created August 20, 2020 14:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dserodio/9571f1d993a57dc97ac013bed8ea8265 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dserodio/9571f1d993a57dc97ac013bed8ea8265 to your computer and use it in GitHub Desktop.
Download ZIP
Check if PostgreSQL is using SSL
Raw
psql_check_ssl.sql
SELECT s.pid, s.ssl, s.version, a.client_addr, a.usename, a.datname, a.query
FROM pg_stat_ssl AS s
JOIN pg_stat_activity AS a ON a.pid = s.pid;
-- You can see `t|f` in `ssl` field
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment