Database Engine Updates for Amazon Aurora PostgreSQL - Amazon Aurora

Database Engine Updates for Amazon Aurora PostgreSQL

In the following topic, you can find version and update information specific to Amazon Aurora with PostgreSQL compatibility. For more information about updates that apply generally to Aurora, see Amazon Aurora Updates.

Identifying Your Version of Amazon Aurora PostgreSQL

Amazon Aurora includes certain features that are general to Aurora and available to all Aurora DB clusters. Aurora includes other features that are specific to a particular database engine that Aurora supports. These features are available only to those Aurora DB clusters that use that database engine, such as Aurora PostgreSQL.

An Aurora database has two version numbers; the Aurora version number and the database engine version number.

  • To get the Aurora version number, see Identifying Your Amazon Aurora Version.

  • You can get the database engine version number for an Aurora PostgreSQL DB instance by querying for the SERVER_VERSION runtime parameter. To get the database engine version number, use the following query.

    SHOW SERVER_VERSION;

Upgrading the Amazon Aurora PostgreSQL Engine Version

For more information about upgrading the Amazon Aurora PostgreSQL engine version, see Upgrading the PostgreSQL DB Engine for Aurora PostgreSQL.