How do I check the version number for an Amazon Aurora MySQL or Amazon Aurora PostgreSQL DB instance?

Resolution

To check the version number for your Aurora DB instance, complete the following steps:

1. Use one of the following clients to log in to your Aurora instance:
   For MySQL, use MySQL Workbench.
   For PostgreSQL, use psql or SQL Workbench/J.
2. To get your version number, run the following command:

   select AURORA_VERSION();

You can use the version number to cross-reference database engine updates to see what features and enhancements are available for your Aurora version. Check the database engine updates for Aurora MySQL-Compatible or Aurora PostgreSQL-Compatible updates.

Note: Aurora frequently releases updates. Updates are cluster wide, and require a simultaneous restart of all the instances in the cluster. The restart can cause brief interruptions in connectivity. If you use Aurora MySQL, then the zero downtime patch feature can prevent connectivity interruptions on the writer node. If you use Aurora PostgreSQL, then you must reboot the service to get the updates.

To plan for these restarts, check the Amazon Relational Database Service (Amazon RDS) console. Or, adjust the DB instance maintenance window.

Related information

MySQL bugs fixed by Aurora MySQL database engine updates

Amazon Aurora PostgreSQL releases and engine versions