Amazon RDS for PostgreSQL: Configuration differences with PostgreSQL on EC2

0

A customer has decided to start using RDS for the new versions of their offering. They are interested in knowing what are the main differences they should take into account when moving from PostgreSQL on EC2 to RDS. I have already found the list of supported features but I wonder if we have any further information regarding:

  • Parameters whose default value in RDS is different from the one in self-managed PostgreSQL.
  • Parameters that are not available or can't be modified for RDS
  • Any functionality that being available for both of them have different behaviors.

Thanks in advanced.

AWS
已提问 4 年前588 查看次数
1 回答
0
已接受的回答

I am not aware of any document showing the parameters comparison. The easy option is to compare the output of pg_settings table on RDS and self-managed PostgreSQL.

You also need to spend some time on the the following:

  • Extensions / Extension versions - Is the correct version of the extension available?

  • Fdw/dblinks - On PostgreSQL to PostgreSQL FDW/Dblink is supported so check what is being used by customer.

  • Special features like email or OS files access - no OS access is available so any functionality required OS access will not work.

  • Pl/ Perl java python etc - Only the secure versions are supported.

  • Scheduled cron jobs - They need to be run from Lambda, Step Functions or an EC2 instance.

AWS
已回答 4 年前
profile picture
专家
已审核 3 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则