Skip to content

Feature request: Add pg_jsonschema extension support to Aurora PostgreSQL

0

We would like AWS Aurora PostgreSQL to support the pg_jsonschema extension: supabase/pg_jsonschema

Our use case is server-side JSON Schema validation of json/jsonb columns, including using jsonb_matches_schema() in CHECK constraints.

We require this functionality on Aurora PostgreSQL and currently cannot deploy the extension ourselves because it is a native Rust/pgrx PostgreSQL extension.

Target PostgreSQL version: 17/18 AWS Region: eu-central-1

Is pg_jsonschema already on the Aurora PostgreSQL roadmap? If this is not currently supported or planned, could you please advise on the best way to submit this as a feature request to the Aurora PostgreSQL team?

asked a month ago57 views

1 Answer
0

Aurora PostgreSQL supports a wide range of PostgreSQL extensions, and you can enable them using the standard CREATE EXTENSION command. However, the availability of specific extensions varies by Aurora PostgreSQL version and region. While Aurora PostgreSQL does provide native JSON and JSONB data type support with various querying and indexing capabilities, I cannot confirm whether pg_jsonschema is currently available or on the roadmap.

To submit a feature request for pg_jsonschema extension support in Aurora PostgreSQL, the best approach is to contact AWS Support through the AWS Support Center at https://console.aws.amazon.com/support/. If you have an active AWS Premium Support plan, you can reach out directly for Aurora-specific guidance and to formally submit your feature request. When submitting your request, be sure to include your specific use case details, target PostgreSQL versions, and the AWS Region where you need this functionality.

AWS evaluates feature requests based on customer demand and use cases, so providing detailed information about your requirements for server-side JSON Schema validation and CHECK constraint usage will help the Aurora PostgreSQL team assess the request.
Sources
Extensions supported for Amazon Aurora PostgreSQL - Amazon Aurora
Amazon Aurora FAQ - Amazon Aurora
Working with Amazon Aurora PostgreSQL - Amazon Aurora

answered a month ago

AWS
SUPPORT ENGINEER

reviewed a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.