Skip to content

chore(rds): add latest postgres 12.11, 13.7, and 14.3 versions#21452

Merged
mergify[bot] merged 2 commits intoaws:mainfrom
ssplatt:add-postgres-versions
Aug 3, 2022
Merged

chore(rds): add latest postgres 12.11, 13.7, and 14.3 versions#21452
mergify[bot] merged 2 commits intoaws:mainfrom
ssplatt:add-postgres-versions

Conversation

@ssplatt
Copy link
Copy Markdown
Contributor

@ssplatt ssplatt commented Aug 3, 2022 •
edited
Loading

RDS has 12.11, 13.7, and 14.3 available. Currently, I am running into an issue where I am trying to deploy from a 12.11 snapshot and CDK continues to try and "upgrade" the cluster after deployment to 12.10, and fails.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.DBVersions

aws rds describe-db-engine-versions --engine postgres
...
{
            "Engine": "postgres",
            "EngineVersion": "12.11",
            "DBParameterGroupFamily": "postgres12",
            "DBEngineDescription": "PostgreSQL",
            "DBEngineVersionDescription": "PostgreSQL 12.11-R1",
            "ValidUpgradeTarget": [
                {
                    "Engine": "postgres",
                    "EngineVersion": "13.7",
                    "Description": "PostgreSQL 13.7-R1",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": true
                },
                {
                    "Engine": "postgres",
                    "EngineVersion": "14.3",
                    "Description": "PostgreSQL 14.3-R1",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": true
                }
            ],
            "ExportableLogTypes": [
                "postgresql",
                "upgrade"
            ],
            "SupportsLogExportsToCloudwatchLogs": true,
            "SupportsReadReplica": true,
            "SupportedFeatureNames": [
                "Lambda",
                "s3Export",
                "s3Import"
            ],
            "Status": "available",
            "SupportsParallelQuery": false,
            "SupportsGlobalDatabases": false,
            "MajorEngineVersion": "12",
            "SupportsBabelfish": false
        },
...
{
            "Engine": "postgres",
            "EngineVersion": "13.7",
            "DBParameterGroupFamily": "postgres13",
            "DBEngineDescription": "PostgreSQL",
            "DBEngineVersionDescription": "PostgreSQL 13.7-R1",
            "ValidUpgradeTarget": [
                {
                    "Engine": "postgres",
                    "EngineVersion": "14.3",
                    "Description": "PostgreSQL 14.3-R1",
                    "AutoUpgrade": false,
                    "IsMajorVersionUpgrade": true
                }
            ],
            "ExportableLogTypes": [
                "postgresql",
                "upgrade"
            ],
            "SupportsLogExportsToCloudwatchLogs": true,
            "SupportsReadReplica": true,
            "SupportedFeatureNames": [
                "Lambda",
                "s3Export",
                "s3Import"
            ],
            "Status": "available",
            "SupportsParallelQuery": false,
            "SupportsGlobalDatabases": false,
            "MajorEngineVersion": "13",
            "SupportsBabelfish": false
        },
...
{
            "Engine": "postgres",
            "EngineVersion": "14.3",
            "DBParameterGroupFamily": "postgres14",
            "DBEngineDescription": "PostgreSQL",
            "DBEngineVersionDescription": "PostgreSQL 14.3-R1",
            "ValidUpgradeTarget": [],
            "ExportableLogTypes": [
                "postgresql",
                "upgrade"
            ],
            "SupportsLogExportsToCloudwatchLogs": true,
            "SupportsReadReplica": true,
            "SupportedFeatureNames": [
                "Lambda",
                "s3Export",
                "s3Import"
            ],
            "Status": "available",
            "SupportsParallelQuery": false,
            "SupportsGlobalDatabases": false,
            "MajorEngineVersion": "14",
            "SupportsBabelfish": false
        }

@gitpod-io
Copy link
Copy Markdown

gitpod-io bot commented Aug 3, 2022

@aws-cdk-automation aws-cdk-automation requested a review from a team August 3, 2022 19:14
@github-actions github-actions bot added the p2 label Aug 3, 2022
TheRealAmazonKendra
TheRealAmazonKendra previously requested changes Aug 3, 2022
View reviewed changes
Copy link
Copy Markdown
Contributor

@TheRealAmazonKendra TheRealAmazonKendra left a comment

Choose a reason for hiding this comment

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

Please make sure that your PR title confirms to the conventional commit standard (fix, feat, chore) and that it is written in a style that will reflect correctly in the change log (See Contributing Guide, Pull Requests)

Additionally, please link to the documentation in your PR body so that we can check the accuracy of this change since there are no tests. If there is an issue for this already, please also link it in your PR body.

@ssplatt ssplatt changed the title add latest postgres 12, 13, and 14 versions feat(rds): add latest postgres 12, 13, and 14 versions Aug 3, 2022
@ssplatt ssplatt changed the title feat(rds): add latest postgres 12, 13, and 14 versions feat(rds): add latest postgres 12.11, 13.7, and 14.3 versions Aug 3, 2022
@ssplatt
Copy link
Copy Markdown
Contributor Author

ssplatt commented Aug 3, 2022

updated.

@mergify mergify bot dismissed TheRealAmazonKendra’s stale review August 3, 2022 19:57

Pull request has been modified.

@ssplatt ssplatt changed the title feat(rds): add latest postgres 12.11, 13.7, and 14.3 versions fix(rds): add latest postgres 12.11, 13.7, and 14.3 versions Aug 3, 2022
@aws-cdk-automation
Copy link
Copy Markdown
Collaborator

aws-cdk-automation commented Aug 3, 2022

AWS CodeBuild CI Report

  • CodeBuild project: AutoBuildv2Project1C6BFA3F-wQm2hXv2jqQv
  • Commit ID: 61f462a
  • Result: SUCCEEDED
  • Build Logs (available for 30 days)

Powered by github-codebuild-logs, available on the AWS Serverless Application Repository

@TheRealAmazonKendra
Copy link
Copy Markdown
Contributor

TheRealAmazonKendra commented Aug 3, 2022

I'm concerned because none of the versions being added are listed in the documentation https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.html

@TheRealAmazonKendra TheRealAmazonKendra changed the title fix(rds): add latest postgres 12.11, 13.7, and 14.3 versions chore(rds): add latest postgres 12.11, 13.7, and 14.3 versions Aug 3, 2022
@ssplatt
Copy link
Copy Markdown
Contributor Author

ssplatt commented Aug 3, 2022

Screen Shot 2022-08-03 at 5 17 41 PM

@ssplatt
Copy link
Copy Markdown
Contributor Author

ssplatt commented Aug 3, 2022

also, when i do a cdk synth > tmpfile.yaml and manually edit the EngineVersion to 12.11, the CFN applies without an issue.

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Aug 3, 2022

Thank you for contributing! Your pull request will be updated from main and then merged automatically (do not update manually, and be sure to allow changes to be pushed to your fork).

@mergify mergify bot merged commit 72b1b2c into aws:main Aug 3, 2022
@ssplatt ssplatt deleted the add-postgres-versions branch August 3, 2022 21:56
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@TheRealAmazonKendra TheRealAmazonKendra TheRealAmazonKendra approved these changes

Assignees

No one assigned

Labels

p2

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@ssplatt @aws-cdk-automation @TheRealAmazonKendra