AWS RDS for PostgreSQL Service

Terraform module which deploys PostgreSQL service on AWS.

• Support standalone(one read-write instance) and replication(one read-write instance and multiple read-only instances, for read write splitting).

Usage

module "postgresql" {
  source = "..."

  infrastructure = {
    vpc_id        = "..."
    kms_key_id    = "..."
    domain_suffix = "..."
  }

  architecture    = "replication"
  engine_version  = "13.0"          # https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-release-calendar.html#Release.Calendar
}

Examples

• Replication
• Standalone

Contributing

Please read our contributing guide if you're interested in contributing to Walrus template.

Requirements

Name	Version
terraform	>= 1.0
aws	>= 5.24.0
random	>= 3.5.1

Providers

Name	Version
aws	>= 5.24.0
random	>= 3.5.1

Modules

No modules.

Resources

Name	Type
aws_db_instance.primary	resource
aws_db_instance.secondary	resource
aws_db_parameter_group.target	resource
aws_db_subnet_group.target	resource
aws_security_group.target	resource
aws_security_group_rule.target	resource
aws_service_discovery_instance.primay	resource
aws_service_discovery_instance.secondary	resource
aws_service_discovery_service.primary	resource
aws_service_discovery_service.secondary	resource
aws_subnet.default	resource
aws_vpc.default	resource
random_password.password	resource
random_string.name_suffix	resource
aws_availability_zones.selected	data source
aws_kms_key.selected	data source
aws_service_discovery_dns_namespace.selected	data source
aws_subnets.selected	data source
aws_vpc.selected	data source

Inputs

Name	Description	Type	Default	Required
architecture	Specify the deployment architecture, select from standalone or replication.	string	"standalone"	no
context	Receive contextual information. When Walrus deploys, Walrus will inject specific contextual information into this field. Examples: context: project: name: string id: string environment: name: string id: string resource: name: string id: string	map(any)	{}	no
database	Specify the database name. The database name must be 2-64 characters long and start with any lower letter, combined with number, or symbols: - _. The database name cannot be PostgreSQL forbidden keyword.	string	"mydb"	no
engine_parameters	Specify the deployment engine parameters, select for https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Parameters.html.	list(object({ name = string value = string }))	[]	no
engine_version	Specify the deployment engine version, select from https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-release-calendar.html#Release.Calendar.	string	"16.0"	no
infrastructure	Specify the infrastructure information for deploying. Examples: infrastructure: vpc_id: string, optional # the ID of the VPC where the PostgreSQL service applies kms_key_id: string, optional # the ID of the KMS key which to encrypt the PostgreSQL data domain_suffix: string, optional # a private DNS namespace of the CloudMap where to register the applied PostgreSQL service publicly_accessible: bool # whether the PostgreSQL service is publicly accessible	object({ vpc_id = optional(string) kms_key_id = optional(string) domain_suffix = optional(string) publicly_accessible = optional(bool, false) })	{ "publicly_accessible": false }	no
password	Specify the account password. The password must be 8-32 characters long and start with any letter, number, or symbols: ! # $ % ^ & * ( ) _ + - =. If not specified, it will generate a random password. See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.Constraints.	string	null	no
replication_readonly_replicas	Specify the number of read-only replicas under the replication deployment.	number	1	no
resources	Specify the computing resources. Examples: resources: class: string, optional # https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html#Concepts.DBInstanceClass.Summary	object({ class = optional(string, "db.t3.medium") })	{ "class": "db.t3.medium" }	no
storage	Specify the storage resources. Examples: storage: class: string, optional # https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html size: number, optional # in megabyte	object({ class = optional(string, "gp2") size = optional(number, 20 * 1024) })	{ "class": "gp2", "size": 20480 }	no
username	Specify the account username. The username must be 2-16 characters long and start with lower letter, combined with number, or symbol: _. The username cannot be PostgreSQL forbidden keyword.	string	"rdsuser"	no

Outputs

Name	Description
address	The address, a string only has host, might be a comma separated string or a single string.
address_readonly	The readonly address, a string only has host, might be a comma separated string or a single string.
connection	The connection, a string combined host and port, might be a comma separated string or a single string.
connection_readonly	The readonly connection, a string combined host and port, might be a comma separated string or a single string.
context	The input context, a map, which is used for orchestration.
database	The name of PostgreSQL database to access.
password	The password of the account to access the database.
port	The port of the service.
refer	The refer, a map, including hosts, ports and account, which is used for dependencies or collaborations.
username	The username of the account to access the database.

License

Copyright (c) 2023 Seal, Inc.

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at LICENSE file for details.

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.