0

I am trying to futureproof a Postgres database so it can be transferred to AWS Aurora.

I am using the guide extension uuid-ossp.

Is it possible to add PostGres extensions to AWS Aurora?

In particular, I am interested in whether the extension uuid-ossp can be used in Aurora.

5

Yes, you can create Postgres extensions in AWS Aurora Postgres. Yes, the extension uuid-ossp can be used in Aurora.

To get supported extension list in your AWS Aurora Postgres version, run this query:

SHOW rds.extensions; 

or

select * from  pg_available_extensions;

And also check out PostgreSQL Extensions and Modules Supported on Amazon RDS in the Amazon Relational Database Service User Guide for the list of extensions supported in AWS Aurora Postgres based on Postgres versions.

There is no difference in the extension usage for both community Postgres and Aurora Postgres if extension installed on the server. For uuid-ossp usage, please refer to F.44. uuid-ossp in the PostgreSQL documentation.

1
  • 1
    I set up a test aurora postgres instance and was able to add this extension successfully
    – mikelus
    Jun 12 '20 at 12:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.