I'm trying to clear a SQL client error (in Postico) saying that the AWS certificate for our Postgres server (through Heroku) is not trusted.
The instructions I've found all assume that the certificate has a Root Authority, and that adding that to the keychain will solve the issue. However, the Amazon cert appears to have no Root Authority and is self-signed (see below). Installing Amazon's cert does nothing, evidently for this reason.
I could just trust the cert but I'd rather resolve the issue of why there's no trusted authority behind the cert. How can I connect and get a certificate that is from a trusted authority?
