Martin Peters

Data, python and visualisation enthusiast. Keen cyclist. Husband and father of three children.


Setting up PostGIS within Aurora Serverless Postgres using AWS CDK

[ postgis  postgres  ireland  aws  ]

Published Feb 01, 2020

In my last blog post I introduced some geospatial analysis concepts and how the Irish population has moved towards Dublin since the mid 1800s. I’ll continue on this theme in later posts but first I’ll introduce the new Cloud Development Kit from AWS and how to provision a Postgis enabled Postgres database.


The AWS CDK (Amazon Web Services Cloud Development Kit) is a new open source framework to define cloud infrastructure in code (Infrastructure as Code) and provisioning it through AWS CloudFormation.

CDK provides many high level components to allow rapid code development requiring much less input compared to the typical CloudFormation templates. CDK is available in TypeScript, Python, Java and C#.

I’ve built a python CDK repo where two stacks provision an Amazon Virtual Private Cloud (VPC) with a Bastion host and a Postgres database using Amazon Relational Database Service (RDS) (provisioned or serverless). The README of the repo contains details of deploying the stacks and accessing the Aurora Serverless postgres database including how you can use AWS secrets and sessions managers to access the database instance. The README also contains tons of links to blog posts on the CDK topic.

Hopefully this post and repo has given you a feel for CDK in AWS and how it is now just a couple of clicks to get a serverless database up and running. In future posts I’ll introduce spatial functions within Postgis, spatial datasets available, and explore trends and ways of visualising spatial data.


  1. AWS CDK
  2. AWS CDK Code
  3. AWS VPC
  4. AWS RDS
  5. RDS User Guide
  6. List of Postgres Extensions
  7. RDS with PostGIS
  8. Amazon Aurora
  9. AWS Aurora Serverless
  10. AWS Aurora with Postgres
  11. AWS Aurora User Guide
  12. Python CDK - VPC + Postgres


ireland postgres postgis aws random qgis property geospatial