amazon-web-services - 如何使用 Cloudformation 在 AWS Aurora 中指定 Postgres？

Question

我正在尝试使用 Cloudformation 启动 Postgres 风格的 Aurora 集群，但我找不到如何在模板中指定“postgres”。有谁知道怎么做，或者 Postgres 是否受支持？

http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html

Answer 1

aurora-postgresql

目前唯一支持的引擎版本是 9.6.3

更新 - 当前支持的 aurora 版本现在包括 9.6.6、9.6.8 和 9.6.9 https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-engine-versions.html

更新 2 - 对于版本 10，当前支持的 aurora 版本包括 postgres:10.4、10.5、10.6 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Updates.20180305.html

aws rds describe-db-engine-versions --engine aurora-postgresql
--region us-east-1 {
    "DBEngineVersions": [
        {
            "Engine": "aurora-postgresql",
            "DBParameterGroupFamily": "aurora-postgresql9.6",
            "DBEngineDescription": "Aurora (PostgreSQL)",
            "EngineVersion": "9.6.3",
            "DBEngineVersionDescription": "Aurora PostgreSQL (compatible with PostgreSQL 9.6.3)",
            "ValidUpgradeTarget": []
        }
    ] }

https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html

引擎

The name of the database engine to be used for this instance.

Not every database engine is available for every AWS Region.

Valid Values:

    aurora

    aurora-postgresql

    mariadb

    mysql

    oracle-ee

    oracle-se2

    oracle-se1

    oracle-se

    postgres

    sqlserver-ee

    sqlserver-se

    sqlserver-ex

    sqlserver-web