Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

chore: bump local pgsql from 11 to 14 #1073

Merged
merged 2 commits into from
Sep 20, 2023
Merged

chore: bump local pgsql from 11 to 14 #1073

merged 2 commits into from
Sep 20, 2023

Conversation

bayou-brogrammer
Copy link
Contributor

Description of change

Bumps the local version of pgsql to match our deployed versions

Addresses: #1072

@bayou-brogrammer bayou-brogrammer changed the title bump from 11-15 chore: bump local pgsql from 11 to 14 Jul 7, 2023
iulianbarbu
iulianbarbu previously approved these changes Jul 10, 2023
Copy link
Contributor

@iulianbarbu iulianbarbu left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks! lgtm

@iulianbarbu
Copy link
Contributor

@lecoqjacob it seems like 1 test is failing. Can you reproduce it locally?

@iulianbarbu iulianbarbu dismissed their stale review July 10, 2023 08:06

pending test fixup

@bayou-brogrammer
Copy link
Contributor Author

Password hashing changed in v14 of psql to use sham-sha-256.

https://www.percona.com/blog/postgresql-14-and-recent-scram-authentication-changes-should-i-migrate-to-scram/

Copy link
Contributor

@chesedo chesedo left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

We just have to verify the version stays in lockstep with the versions used for RDS

@@ -333,7 +333,7 @@ fn db_type_to_config(db_type: Type) -> EngineConfig {
match db_type {
Type::Shared(SharedEngine::Postgres) => EngineConfig {
r#type: "shared_postgres".to_string(),
image: "docker.io/library/postgres:11".to_string(),
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This tries to match the same version that is being provisioned for RDS instances to make local and prod identical. I might have missed when the RDS instances also got bumped?

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I checked in the console now and a bit more than half of our RDS instances are at 14 (the newer ones), and the older half is at 13. I don't see any below 13, and the most recent instance is actually 15. 😄 We don't explicitly set the version in provisioner when we provision RDS dbs, so perhaps it just uses latest 🤔

@jonaro00 jonaro00 added the XS label Jul 15, 2023
@jonaro00 jonaro00 removed the E-XS label Aug 17, 2023
Copy link
Contributor

@oddgrd oddgrd left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks! Apologies for the delay.

@oddgrd oddgrd merged commit 0d64923 into shuttle-hq:main Sep 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants