Skip to content

Error when upgrading major Postgres version #6585

@yinonburgansky

Description

@yinonburgansky

In SST 4.2.7, when trying to update Postgres version from 16 to 17,
it fails, and result in a broken state, (need to run multiple sst refresh & sst deploy to restore the app back, still on old version):

const rds = new sst.aws.Postgres("MyPostgres", {
      vpc,
      version: "17", // "16"
      })

error:

MyPostgresParameterGroup
sdk-v2/provider2.go:572: sdk.helper_schema: deleting RDS DB Parameter Group (myapp-production-mypostgresparametergroup-dmktutba): operation error RDS: DeleteDBParameterGroup, https response error StatusCode: 400, RequestID: ***, InvalidDBParameterGroupState: One or more database instances are still members of this parameter group myapp-production-mypostgresparametergroup-dmktutba, so the group cannot be deleted: provider=aws@7.20.0

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions