Database | Amazon RDS for PostgreSQL

Question 1

Which database versions does Amazon RDS for PostgreSQL support?

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL | Database

Answer 1

Amazon RDS for PostgreSQL currently supports PostgreSQL 9.3, 9.4, 9.5, and 9.6. Information about the supported minor versions is available in the Amazon RDS User Guide.

Question 2

What are the extensions supported by RDS for PostgreSQL?

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL | Database

Answer 2

You can check the list of supported extensions in the Amazon RDS User Guide. To request support for additional extensions, you can send an email to rds-postgres-extensions-request@amazon.com with the extension name and use case.

Question 3

Does RDS for PostgreSQL support audit logging?

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL | Database

Answer 3

RDS PostgreSQL supports several parameters you can set to log activity that occurs on your PostgreSQL DB instance. You can learn more about them in the Amazon RDS User Guide.

Question 4

Are there RDS for PostgreSQL limitations that I need to be aware of?

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL | Database

Answer 4

Yes, you can read about the limitations of RDS PostgreSQL instances in the Amazon RDS User Guide.

Question 5

How does Amazon RDS distinguish between “major” and “minor” versions of PostgreSQL?

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL | Database

Answer 5

In the context of RDS for PostgreSQL, version numbers are organized as follows:

PostgreSQL version = X.Y.Z

From the Amazon RDS standpoint, a version change would be considered major if either the first or second part of the version number is being changed. Example: going from 9.4.X -> 9.5.Y.

A version change would be considered minor if the third part of the version number within the release is being changed. Example: going from 9.5.2 -> 9.5.4.

Refer to the PostgreSQL Versioning Policy for more information.