mnzislam / practice_Lab

0 stars 0 forks source link

<MONZUR> [Lab] DataPipeline: How to create DB Instance and Create Trigger Function - DataPipeline 103 #3

Open mnzislam opened 1 month ago

mnzislam commented 1 month ago

Objective : Create a Relational Database Service through the console and Connect to the server through pgadmin4-- try some sql script to create user followed by a table and a trigger function

mnzislam commented 1 month ago

Created a RDS as per the ticket guodeline--

Few key points-- Database engine version 14.6R1 could not find I chose 14.13 R1 port should 5432-- this is the default port, if you want to use 5999 it should be a custom one. Security Group Inbound rule should allow the postgresql to access

Image

mnzislam commented 1 month ago

SQL script o create user followed by a table and a trigger function in pgadmin4 as per the ticket

Image Image Image Image Image