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.

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

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

Connect to PostgreSQL cluster using third part tool and create the objects
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.

주제

서버리스 마이그레이션 및 현대화 분석 데이터베이스

태그

서버리스 아마존 Relational Database Service 오로라 PostgreSQL 아마존 Aurora

언어

English

Alpesh Dhori eGain

질문됨 일 년 전290회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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.

전문가

skinsman

답변함 일 년 전

Alpesh Dhori eGain
일 년 전
Hi,

Thanks for your response.

I'm looking options other then lambda as we do have very large functions, tables etc. which will be very difficult to manage in the code file.

AWS document suggest we do have such API on earlier Serverless 1 Instance Type but this only support older version of PostgreSQL.

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

관련 콘텐츠