My Heroku instance suddenly stopped accepting connections to the DB without an SSL certificate, and so my application stopped working. Just in case someone else bumps into this problem, here's what I did:
- Update your pubspec.yaml to point to this repo instead of the latest version of Aqueduct. Props to NayanJD for his pull request. Remember to add a dependency_overrides section. You might also need to set publish_to to none.
- In the channel.dart file, the one inside of your own project, within the contextWithConnectionInfo method, set the useSSL option in the PostgreSQLPersistentStore constructor to true.
- Add the --use-ssl option to the release command in Procfile.