可以在Heroku维护后连接到Heroku Postgres DB
多年来，我一直在使用Heroku的Postgres数据库，并从Mac上的MAMP Localhost连接，没有问题。
但是，我的数据库最近已通过Heroku维护升级，现在使用MAMP Localhost时，我会收到以下PHP PDO错误：
“ SQLSTATE [08006] [7] SSL错误：TLSV1警报协议版本“
从我了解的内容中因为Heroku现在需要TLS版本1.2或更高版本才能连接到Postgres。我已经验证了我在本地使用TLS 1.3，但是我仍会遇到此错误。
如何从MAC运行的PHP本地连接到远程Heroku Postgres数据库？
我一直在广泛研究这个问题，无法解除自己的障碍。
预先感谢任何可以提供帮助的人。
I've been using Heroku's Postgres databases for years now, and connecting from my MAMP localhost on Mac with no issue.
However, my databases have recently been upgraded by Heroku maintenance, and now when using MAMP localhost I am getting the following PHP PDO error:
"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 have verified I am using TLS 1.3 locally, but I am still getting this error.
How can I locally connect to my remote Heroku Postgres database from my Mac running PHP?
I have been researching this issue extensively and have been unable to unblock myself.
Thanks in advance to anybody who can help.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
解决方案我最终在这种情况下与其他任何人一起去。我最终将Mac在MAMP 5上运行的MAMP的版本从MAMP 5更新为MAMP 6，其中包括OpenSSL和LibPQ的适当版本。我可以再次连接到Heroku上更新的远程Postgres数据库。感谢Postgres Slack组中的用户ph00 bar！
Solution I ended up going with for anyone else in this situation. I ended up updating the version of MAMP I was running on my Mac from MAMP 5 to MAMP 6, which included the proper versions of OpenSSL and libpq. I can once again connect to the updated remote Postgres database on Heroku. Thank you to user Ph00 Bar in the Postgres Slack group!