create-serverless-v2-aws-database.sh

# Create a RDS database using the new V2 Serverless engine

aws rds create-db-cluster \
 --db-cluster-identifier serverless-v2-cluster \
 --region ap-southeast-2 \
 --availability-zones ap-southeast-2a ap-southeast-2b ap-southeast-2c \
 --engine aurora-postgresql \
 --engine-version 13.6 \
 --storage-encrypted \
 --master-username postgresql \
 --master-user-password aPasswordHereOfSomeKind \
 --serverless-v2-scaling-configuration MinCapacity=0.5,MaxCapacity=2 \
 --vpc-security-group-ids sg-XXXXXXXXXXX
 
 aws rds create-db-instance \
  --db-cluster-identifier serverless-v2-cluster \
  --db-instance-identifier serverless-v2-instance-1 \
  --region ap-southeast-2 \
  --db-instance-class db.serverless  \
  --engine aurora-postgresql 
  
 aws rds create-db-instance \
  --db-cluster-identifier serverless-v2-cluster \
  --db-instance-identifier serverless-v2-instance-2 \
  --region ap-southeast-2 \
  --db-instance-class db.serverless  \
  --engine aurora-postgresql 
  
  
 # For jump box
amazon-linux-extras enable postgresql13
yum clean metadata && yum install postgresql