postgresql - AWS 云信息 : Enable PostGIS Extension in RDS from Cloudformation

Question

云信息新手。我正在使用 aws cloudformation 脚本生成 PostgreSQL RDS 实例。
有没有办法从aws cloudFormation脚本启用PostGIS(和其他扩展)？

Answer 1

Working with PostGIS PostGIS is an extension to PostgreSQL for storing and managing spatial information. If you are not familiar with PostGIS, you can get a good general overview at PostGIS Introduction.

You need to perform a bit of setup before you can use the PostGIS extension. The following list shows what you need to do; each step is described in greater detail later in this section.

• Connect to the DB instance using the master user name used to create the DB instance.
• Load the PostGIS extensions.
• Transfer ownership of the extensions to therds_superuser role.
• Transfer ownership of the objects to the rds_superuser role.
• Test the extensions.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html

我不确定，但也许您可以使用 cloudformation 创建 lambda 函数和 RDS，然后可以调用 lambda 来执行上述步骤。你需要尝试一下。

最好，