Q: Which database versions does Amazon RDS for PostgreSQL support?

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.

Q: What are the extensions supported by RDS for PostgreSQL?
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.

Q: Does RDS for PostgreSQL support audit logging?

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.

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

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

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

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.

Q: Does Amazon RDS provide guidelines for upgrading engine versions or deprecation of engine versions that are currently supported?

Yes. Please refer to the Amazon RDS FAQs.