Schedule | Ticket ID | Work Summary | Discussion Points | Action Items | Recording & Documenation – LMS Link (Only Enrolled members has access) | Architect | Remark/Status |
---|---|---|---|---|---|---|---|
📅 Schedule : 7:35 PM IST, 21-Feb-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | 👨🔧 Connect to database through .pgpass file / Secrect Manager . how to create a secret in secret manager with customer managed key encryption. how to create secret policy and attach that policy to user (service account) how to use jq commands how to set access key, id and region to connect to aws account command to connect to RDS instance – psql -h ” -p ” -U ‘username’ -p ‘<password’ | 🎬 Action Items ✍️ need to write shell script to connect to 18 instance in different aws accounts either using .pgpass file approach or secret manager approach. | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 6:30 PM IST, 22-Feb-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | how to create user CREATE USER WITH PASSWORD ” how to create role CREATE ROLE name [ WITH ADMIN role_name ] how to store secret values in secret manager worked on shell script | 🎬 Action Items ✍️ how to create users inside the database and use required info to connect from different users. | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 6:00 PM IST, 23-Feb-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | how to create user inside the database | 🎬 Action Items ✍️ script to connect to 18 instance in different aws accounts either using .pgpass file approach or secret manager approach. | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 7:10 PM IST, 24-Feb-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | Explained about grafana | 🎬 Action Items ✍️ need to work on grafana once user get required info | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 7:30 PM IST, 01-March-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | written shell script and Executed how to pass SQL queries during runtime | 🎬 Action Items ✍️ need to modify script based on the requirement . | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 9:30 PM IST, 13-March-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | shell script modifications | 🎬 Action Items ✍️ need to modify script based on the requirement . | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed | |
📅 Schedule : 8:30 PM IST, 14-March-2023 | End to End Connection to AWS RDS Instance through .pgpass file or Secret Manager | shell script modifications | 🎬 Action Items ✍️ Completed the requirement. | Click : Connection to AWS RDS InAWS RDS Instance through .pgpass file or Secret Manager | Supraja | Completed |