Skip to content

Latest commit

 

History

History
51 lines (35 loc) · 1.29 KB

notes.md

File metadata and controls

51 lines (35 loc) · 1.29 KB

My project notes

# change /rds_demo/alert_phone value first!
sh ./parameter_store_values.sh

aws cloudformation validate-template \
  --template-body file://cfn-templates/rds.template

cfn-lint -t cfn-templates/rds.template

aws cloudformation create-stack \
  --template-body file://cfn-templates/event.template \
  --stack-name RDSEventDemoStack

aws cloudformation create-stack \
  --template-body file://cfn-templates/rds.template \
  --stack-name RDSDemoStack

# alternative
aws cloudformation create-stack \
  --template-body file://cfn-templates/rds_only.template \
  --stack-name RDSDemoStack

aws cloudformation delete-stack \
  --stack-name RDSDemoStack

aws rds describe-db-instances \
  --db-instance-identifier demo-instance

# open port 5432 to your ip address /32 CIDR in the VPC security group

cd python-scripts

python3 -m pip install -r ./requirements.txt

time python3 ./create_pagila_data.py --instance master

# change cpd.set_connection to docker or master (AWS) in 2 places first!
time python3 ./unit_tests.py

time python3 ./query_postgres.py --instance master

# https://www.pgadmin.org/download/pgadmin-4-container/
docker pull dpage/pgadmin4
docker run -p 8180:80 \
  -e "PGADMIN_DEFAULT_EMAIL=user@domain.com" \
  -e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" \
  -d dpage/pgadmin4