Allows for newer PGSQL versions to be configured (v15) by updating to the latest lib/pq version available (v1.10.9) @itsouvalas
Description
It creates a direct dependency on github.com/lib/pq@v1.10.9 for jetstream's main application.
It updates the indirect dependency on github.com/lib/pq@v1.10.9 for monocular plugin
Motivation and Context
Newer versions of PGSQL default to SCRAM-SHA-256 as a password hashing method. As a result when using PGSQL v10 onwards connection or similar issues would arise when attempting to connect:
2023-10-09T15:24:41.38+0000 [APP/PROC/WEB/0] OUT INFO[Mon Oct 9 15:24:41 UTC 2023] Waiting for database to be responsive: Unable to ping the database: pq: unknown authentication response: 10
Using the latest github.com/lib/pq@v1.10.9 allow for successful communication to the newer versions of PGSQL.
How Has This Been Tested?
Using postgres-bosh-release v47 and by connecting to stratos using cf CUPS, we were able to connect successfully and interact with the application accordingly.
Types of changes
[X] Bug fix (non-breaking change which fixes an issue)
[ ] Docs update
[X] New feature (non-breaking change which adds functionality)
[ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
Checklist:
[X] My code follows the code style of this project.
[ ] My change requires a change to the documentation.
[ ] I have updated the documentation accordingly.
[X] I have followed the guidelines in CONTRIBUTING.md, including the required formatting of the commit message
[Features]
Description
It creates a direct dependency on github.com/lib/pq@v1.10.9 for jetstream's main application. It updates the indirect dependency on github.com/lib/pq@v1.10.9 for monocular plugin
Motivation and Context
Newer versions of PGSQL default to SCRAM-SHA-256 as a password hashing method. As a result when using PGSQL v10 onwards connection or similar issues would arise when attempting to connect:
Using the latest github.com/lib/pq@v1.10.9 allow for successful communication to the newer versions of PGSQL.
How Has This Been Tested?
Using postgres-bosh-release v47 and by connecting to stratos using cf CUPS, we were able to connect successfully and interact with the application accordingly.
Types of changes
Checklist: