An announcement at the AWS:Invent 2013 conference that got me excited was the new support for PostgreSQL on Amazon Web Service’s (AWS) Relational Database Service (RDS).
I crossed my fingers as I read the announcement, hoping that PostGIS was part of this. “No Way!” I thought after reading that PostGIS was indeed! I knew I had to try it out.
Running PostGIS on RDS
I fired up an RDS instance of PostgreSQL to see for myself. After connecting using the standard PostgreSQL admin tool, pgAdmin, and executing the statement CREATE EXTENSION postgis; I now had a scalable spatial database in the cloud at my fingertips. With this there are now two spatial data solutions within RDS: SQL Server and PostGIS! Spatial data in the cloud just keeps getting easier.
I used FME to read and write data to this PostGIS database as it would any other PostGIS. Both Raster and Vector worked flawlessly. This whole process, from creating the database to using it, took about 10 minutes. Wow!
FME and PostGIS in the Cloud
The implications of this are huge, especially when I think about our new FME Cloud iPaaS service. FME Cloud currently has a PostGIS database as part of its installation. Now with AWS RDS supporting PostGIS, it is simple for users to use this cloud-based PostGIS database instead.
Doing this is a game changer.
With PostGIS now supported by RDS, anyone can easily deploy a class-leading fault-tolerant database that spans multiple data centers (or AZ in Amazon speak) in minutes. These databases can also be scaled up or down to meet changing requirements. And of course all of the management and backup issues are handled by Amazon. No hardware to buy or manage.
Best thing is that all FME users, from FME Desktop to FME Server to FME Cloud, can take advantage of this today!
Don MurrayDon is the co-founder and President of Safe Software. Safe Software was founded originally doing work for the BC Government on a project sharing spatial data with the forestry industry. During that project Don and other co-founder, Dale Lutz, realized the need for a data integration platform like FME. When Don’s not raving about how much he loves XML, you can find Don working with the team at Safe to take the FME product to the next level. You will also find him on the road talking with customers and partners to learn more about what new FME features they’d like to see.
Interesting days indeed. Bill Dollins has posted an interesting tutorial on building a simple geodata service with the node.js package together with PostGIS on Amazon RDS over at http://blog.geomusings.com/2013/12/11/building-a-simple-geodata-service-with-node-and-amazon-rds/ which is well worth a read as well.