postgres_get_server_cert.py example.com:5432 | openssl x509 -noout -dates

> openssl s_client -starttls -connect my.postgres.host:5432 # etc...