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

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.

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

相關內容