PostGIS and Aurora compatibility: experience feedback

Question

Customer would like to move his PostgreSQL to Aurora PostgreSQL with PostGIS.

As per [AWS forum][1], this should work as RDS PostgreSQL [documentation][2] is supported and Aurora doesn't list it as [incompatible][3].

I quickly checked I could load the postgis extension in Aurora but I don't have extensive experience with this.
Are there any drawbacks, tips with Aurora + PostGIS ?

[1]: https://forums.aws.amazon.com/thread.jspa?messageID=811633&tstart=0
  [2]: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html#Appendix.PostgreSQL.CommonDBATasks.PostGIS
  [3]: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.Compare.html

AWS-User-3438484 · Accepted Answer

Yes Aurora Postgres also supports PostGiS. We maintain extensions parity as much as possible between RDS Postgres and Aurora Postgres. Please give it a try and let me know if you have any problems.

mikkok · Answer

We are running Aurora Serverless v1 with Postgis extension, mainly for data storage, and haven't noticed problems with extension itself. Instead there has been a bunch of problems with db-connections when inserting data to DB with FME.

PostGIS and Aurora compatibility: experience feedback

Add your answer

Relevant content