Does Amazon Aurora Postgres support lambda invocations?

Question

From what I could gather in AWS's documentation, Aurora MySQL supports invoking lambda functions as triggers: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/AuroraMySQL.Integrating.Lambda.html

No such documentation for Postgres. Is there a way to call a lambda from a Postgres instance?

Answer 1

PostgreSQL on RDS:

If you are using PostgreSQL on RDS, then as of now it doesn't support invoking lambda function as triggers.

Amazon Aurora(PostgreSQL Compatibility):

As of now this also doesn't support invoking lambda function as triggers.

PostgreSQL on EC2:

But if you have setup PostgreSQL on EC2, then you use leverage PL/Python language to create your User Defined Functions and AWS Python SDK to invoke Lambda functions.

In the below links, checkout the section titled PostgreSQL setup , in which they have provided detailed steps to achieve the same.

AWS Blog Link: Set up a SQL-to-Lambda interface

GitHub Link: aws-lambda-rdbms-integration

Answer 2

Since December 2020 Aurora PostgreSQL supports Lambda invocations. Documentation can be found here.