---
updatedAt: 2025-12-16T15:29:42.000Z
agentTools:
  projectIndex: https://docs.getfastah.com/llms.txt
---

# Amazon Aurora DSQL and Aurora PostgreSQL

Compare Aurora PostgreSQL and Aurora DSQL support for Fastah data types like IP addresses, subnets, and geolocation points.

[Amazon Aurora PostgreSQL](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html) and [Amazon Aurora DSQL](https://aws.amazon.com/rds/aurora/dsql/) are fully managed, PostgreSQL-compatible databases from AWS. They differ in data type and extension support—relevant when storing [Fastah API responses](understanding-the-api-response).

**Choose Aurora PostgreSQL** if you need PostGIS for geospatial queries or `cidr` for subnet storage. **Choose Aurora DSQL** for serverless, distributed workloads where `inet` and timestamps suffice.

## Supported data types

| Feature                                                                                | Aurora PostgreSQL                                                                                                        | Aurora DSQL                                                                                                                                                                                       |
| -------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [IPv4/IPv6 addresses](postgresql-postgis-latitude-and-longitude-geolocations) (`inet`) | ✅                                                                                                                        | ✅ ([docs](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-data-types.html#working-with-postgresql-compatibility-query-runtime))          |
| [Subnet storage](postgresql-postgis-latitude-and-longitude-geolocations) (`cidr`)      | ✅                                                                                                                        | ❌                                                                                                                                                                                                 |
| [PostGIS extension](postgresql-postgis-latitude-and-longitude-geolocations)            | ✅ ([docs](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.PostGIS.html)) | ❌ ([docs](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-unsupported-features.html#working-with-postgresql-compatibility-unsupported-extensions)) |
| [Timezone-aware timestamps](detecting-timezone)                                        | ✅                                                                                                                        | ✅ ([docs](https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-postgresql-compatibility-supported-data-types.html#date-time-data-types))                                         |