I have some data in PostgreSQL which I am exporting to Amazon RDS service. Will I be able to use PostGIS extension in AWS, Also will I need the mandatory column "geom" or I could run queries with just latitude longitude valuies?

  • Note that the name "geom" is just a convention, not a requirement; you could name the column chocolate_cake_with_grapefruit_juice if you were so inclined. – Vince Aug 28 '19 at 0:19
  • Oh yeah, I should mentioned is the geometry column mandatory, which I have found out by now that it is required to run spatial operations, despite having lat long values. Yes I understand geom is just a naming convention, thanks for pointing out. – Tanya Aug 28 '19 at 16:55

Yes, you will be able to use PostGIS with RDS. See Amazon's user guide on Working with PostGIS.

It appears to be the full, unmodified extension, so I would assume it operates just like a non-cloud installation. You'll still need a geometry column in order to run spatial queries.

| improve this answer | |
  • Thanks a lot Alex. Let me try it out – Tanya Aug 27 '19 at 22:31
  • Im facing some connection issues with AWS, waiting for support from their team. Meanwhile I just wanted to know if I will be able to import existing postgres databases into aws server. The reverse is possible I know. Could you help please Alex? – Tanya Aug 30 '19 at 0:12
  • Yes, you should be able to import. See their help files here: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… – Alex Aug 30 '19 at 13:27
  • Alex any idea about this : gis.stackexchange.com/questions/334091/… – Tanya Sep 5 '19 at 20:18
  • I've done this, and taught workshops with it. It's easy. Just enable the extension and away you go... – DPSSpatial Jun 1 at 15:57

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.