Aurora PostgreSQL: Database Object creations using AWS CLI/SAM CLI/Cloud formation

Question

We looking way to deploy the Database objects on the PostgreSQL Database without using the external tool like pgadmin4.

I know two commonly used method to deploy the database objects
1. Connect to PostgreSQL cluster using third part tool and create the objects
2. Lambda which execute the sql qurty on PostgreSQL Database

I'm wondering if there a way we can create objects via CLI or other way so we don't need to enable the Public Access for Database Cluster or Expose Port 5432 over the Internet.

Answer

As you say, you can use a Lambda to connect to the DB and execute SQL.  If it's a VPC Lambda then you don't need your DB to be public or expose a port over the Internet.

You can integrate the Lambda tightly with CloudFormation as a Custom Resource or Resource Type.

For Custom Resources implemented in Python Lambdas, crhelper makes it really easy.

Aurora PostgreSQL: Database Object creations using AWS CLI/SAM CLI/Cloud formation

Contenuto pertinente