Terraform code for AWS Postgresql RDS
create directory postgres and navigate
$ mkdir postgres && cdβpostgres
create main.tf file
$ vim main.tf
provider "aws" {
}
resource "aws_security_group" "rds_sg" {
name = "rds_sg"
ingress {
from_port = 5432
to_port = 5432
protocol = "tcp"
cidr_blocks = ["0.0.0.0/0"]
}
}
resource "aws_db_instance" "myinstance" {
engine = "postgres"
identifier = "myrdsinstance"
allocated_storage = 20
engine_version = "14"
instance_class = "db.t3.micro"
username = "myrdsuser"
password = "myrdspassword"
parameter_group_name = "default.postgres14"
vpc_security_group_ids = ["${aws_security_group.rds_sg.id}"]
skip_final_snapshot = true
publicly_accessible = true
}
output "rds_endpoint" {
value = "${aws_db_instance.myinstance.endpoint}"
}
save and exit
$ terraform init
$ terraform plan
$ terraform apply -auto-approve
Install postgres client in local machine
$ sudo apt install -y postgresql-client
To access AWS postgresql RDS instance
$ psql -h <end_point_URL> βp=5432 βusername=myrdsuser βpassword βdbname=mydb
To destroy postgresql RDS instance
$ terraform destroy -auto-approve