Unable to connect to Heroku Postgres DB after Heroku maintenance

Question

I've been using Heroku's Postgres database for years and have had no issues connecting from MAMP localhost on my Mac.

However, my database has been recently upgraded via Heroku maintenance and I now get the following PHP PDO error when using MAMP localhost:

"SQLSTATE[08006] [7] SSL error: tlsv1 alert protocol version"

From what I understand, this is because Heroku now requires TLS version 1.2 or higher to connect to Postgres. I've verified that I'm using TLS 1.3 locally, but I'm still getting this error.

How to connect to a remote Heroku Postgres database locally from a Mac running PHP?

I've been researching this issue extensively but can't unlock it myself.

Thanks in advance to anyone who can help.

Answer 1

In this case I ended up providing a solution for others. I ended up updating the version of MAMP I was running on my Mac from MAMP 5 to MAMP 6, which included the correct versions of OpenSSL and libpq. I can connect to the updated remote Postgres database on Heroku again. Thanks to user Ph00 Bar in the Postgres Slack group!