pgVector Update in RDS Aurora PostgresSQL

The Postgres extension version for each Postgres version are listed here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.14

You will have to update to the Postgres version that supports the extension version you want to use. I don't think there is a way to update just the extension. Also, pgvector 0.8.0 is not yet available for Aurora PostgreSQL.

Thank you for your question about upgrading pgvector on your Amazon RDS Aurora PostgreSQL cluster. I can provide some guidance on this matter.

First, it's important to note that pgvector 0.8.0 is available for PostgreSQL 14.14 and higher versions. Your current cluster is running PostgreSQL 14.9, which is why you're unable to upgrade to pgvector 0.8.0 directly.

To upgrade pgvector to version 0.8.0, you'll need to follow these steps:

1. Upgrade your Aurora PostgreSQL cluster to version 14.14 or higher. This is a prerequisite for accessing pgvector 0.8.0.

2. After upgrading the PostgreSQL engine version, you can then update the pgvector extension using the SQL command:

   ALTER EXTENSION pgvector UPDATE TO '0.8.0';

To perform the PostgreSQL engine upgrade:

1. Use the Amazon RDS Console to initiate a major version upgrade on your cluster. Select the "Modify" option for your cluster, choose the updated version (14.14 or higher), and apply the settings immediately.

2. Alternatively, you can use the AWS CLI to perform the upgrade with a command similar to:

   aws rds modify-db-cluster --db-cluster-identifier your-cluster-id --engine-version 14.14 --allow-major-version-upgrade --apply-immediately

Please note that upgrading the PostgreSQL engine version is a significant operation that may involve some downtime. It's recommended to perform this upgrade during a maintenance window and after thoroughly testing in a non-production environment.

After the PostgreSQL engine upgrade is complete, you should be able to upgrade pgvector to version 0.8.0 using the SQL command mentioned earlier.

Regarding availability, pgvector 0.8.0 should be available in all AWS regions where Amazon RDS for PostgreSQL is supported. If you're still unable to access version 0.8.0 after upgrading to PostgreSQL 14.14 or higher, you may want to contact AWS support for region-specific information.

Remember to review your database parameter groups and ensure they are compatible with the new PostgreSQL version. You may need to create new parameter groups or modify existing ones to align with the upgraded version.

Lastly, it's always a good practice to take a backup of your database before performing any major upgrades.
Sources
Using logical replication to perform a major version upgrade for Aurora PostgreSQL - Amazon Aurora
Upgrading PostgreSQL extensions in RDS for PostgreSQL databases - Amazon Relational Database Service
Amazon RDS for PostgreSQL supports pgvector 0.8.0 - AWS