azure-postgresql-flexible-server

intel/azure-postgresql-flexible-server/intel

Terraform Module HCL INTEL ✓ Verified

Intel Cloud Optimization Module - Azure PostgreSQL Flexible Server

Install
module "azure-postgresql-flexible-server" {
source = "intel/azure-postgresql-flexible-server/intel"
version = "1.2.2"
}
plain text: /constructs/tfmod-intel-azure-postgresql-flexible-server-intel/install.txt
⭐ Source on GitHub 📦 Registry page
README

Intel Optimized Cloud Modules for Terraform © Copyright 2024, Intel Corporation Azure PostgreSQL Flexible Server Module This module can be used to deploy an Intel optimized Azure PostgreSQL Flexible Server instance. Instance selection and PostgreSQL optimization are included by default in the code. The PostgreSQL Optimizations were based off Intel Xeon Tuning guides Performance Data Boost Azure PostgreSQL performance by up to 1.42x with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Process up to 1.24x more Azure PostgreSQL transactions with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Up to 1.23x more Azure PostgreSQL OLTP transactions per minute with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Usage See examples folder for complete examples. By defau

Inputs (28)
NameTypeDescriptionDefault
resource_group_namestringExisting Resource Group where resource will be created. required
db_passwordstringPassword for the master database user. required
db_server_namestringName of the server that will be created. required
db_ha_standby_zonestringSpecifies the Availability Zone in which the standby Flexible Server should be l"1"
db_engine_versionstringDatabase engine version for the Azure database instance."14"
db_charsetstringSpecifies the Charset for the database."UTF8"
db_namestringName of the database that will be created on the flexible instance. If this is snull
db_server_skustringInstance SKU, see comments above for guidance"MO_Standard_E8ds_v4"
db_usernamestringUsername for the master database user."pgadmin"
db_ha_modestringThe high availability mode for the Flexible Server. Possibles values are ZoneRed"ZoneRedundant"
db_private_dns_zone_idstringThe ID of the private DNS zone to create the Flexible Server.null
db_parametersobject({ postgres = optionIntel Cloud optimizations for Xeon processors{ "postgres": { "autovacuum": {},
db_allocated_storagenumberThe max storage allowed for the PostgreSQL Flexible Server. Possible values (MB)2097152
db_restore_timestringWhen create_mode is PointInTimeRestore, specifies the point in time to restore fnull
db_geo_backup_enabledboolTurn Geo-redundant server backups on/off. This allows you to choose between locafalse
db_create_source_idstringFor creation modes other than Default, the source server ID to use.null
db_collationstringSpecifies the Collation for the Database."en_US.UTF8"
db_enginestringDatabase engine for Azure database instance."postgres"
db_maintenance_hourstringThe start hour for maintenance window.null
db_firewall_ruleslist(object({ name Map of IP ranges that (if specified) will create firewall rules for the server t[]
db_backup_retention_periodnumberThe days to retain backups for. Must be between 1 and 35.7
db_create_modestringThe creation mode which can be used to restore or replicate existing servers."Default"
db_delegated_subnet_idstringThe ID of the virtual network subnet to create the Flexible Server.null
Outputs (26)
db_server_sku — Instance SKU in use for the database instance that was created.
db_resource_group_name — Resource Group where the database instance resides.
db_collation — The Collation configured on the database.
db_private_dns_zone_id — The ID of the private DNS zone that the instance will use.
db_maintenance_window_hour — Maintainence window for the database instance.
db_allocated_storage — Storage allocated to the database instance.
db_name — Name of the database that has been provisioned on the database instance.
db_restore_time — Specifies the point in time to restore from creation_source_server_id.
db_server_name — Database instance hostname.
db_location — Database instance location.
db_zone — Zone where the database instance was deployed.
db_create_mode — The creation mode that was configured on the instance.
db_maintenance_window_day — Maintainence window for the database instance.
db_maintenance_window_minute — Maintainence window for the database instance.
db_username — Database instance master username.
db_password — Database instance master password.
db_id — Database instance ID.
db_hostname — Database instance fully qualified domain name.
db_engine_version_actual — Running engine version of the database (full version number)
db_ha_standby_zone — Specifies the Availability Zone in which the standby Flexible Server should be located.
db_create_source_id — For creation modes other than Default, the source server ID to use.
db_charset — The Charset configured on the database.
db_backup_retention — Number of configured backups to keep for the database instance.
db_delegated_subnet_id — The ID of the virtual network subnet to create the MySQL Flexible Server.
db_ha_mode — The high availability mode for the MySQL Flexible Server.
db_firewall_rules — Database Firewall Rules.
Resources (4)
azurerm_postgresql_flexible_serverazurerm_postgresql_flexible_server_configurationazurerm_postgresql_flexible_server_databaseazurerm_postgresql_flexible_server_firewall_rule
Details
FrameworkTerraform Module
LanguageHCL
Version1.2.2
Cloud INTEL
Total downloads3.1k
Inputs28
Outputs26
Resources4
Examples2
Namespaceintel
Updated