Server

Manages a PostgreSQL Server.

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
    public MyStack()
    {
        var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
        {
            Location = "West Europe",
        });
        var exampleServer = new Azure.PostgreSql.Server("exampleServer", new Azure.PostgreSql.ServerArgs
        {
            Location = exampleResourceGroup.Location,
            ResourceGroupName = exampleResourceGroup.Name,
            AdministratorLogin = "psqladminun",
            AdministratorLoginPassword = "H@Sh1CoR3!",
            SkuName = "GP_Gen5_4",
            Version = "9.6",
            StorageMb = 640000,
            BackupRetentionDays = 7,
            GeoRedundantBackupEnabled = true,
            AutoGrowEnabled = true,
            PublicNetworkAccessEnabled = false,
            SslEnforcementEnabled = true,
            SslMinimalTlsVersionEnforced = "TLS1_2",
        });
    }

}
package main

import (
    "github.com/pulumi/pulumi-azure/sdk/v3/go/azure/core"
    "github.com/pulumi/pulumi-azure/sdk/v3/go/azure/postgresql"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
            Location: pulumi.String("West Europe"),
        })
        if err != nil {
            return err
        }
        _, err = postgresql.NewServer(ctx, "exampleServer", &postgresql.ServerArgs{
            Location:                     exampleResourceGroup.Location,
            ResourceGroupName:            exampleResourceGroup.Name,
            AdministratorLogin:           pulumi.String("psqladminun"),
            AdministratorLoginPassword:   pulumi.String("H@Sh1CoR3!"),
            SkuName:                      pulumi.String("GP_Gen5_4"),
            Version:                      pulumi.String("9.6"),
            StorageMb:                    pulumi.Int(640000),
            BackupRetentionDays:          pulumi.Int(7),
            GeoRedundantBackupEnabled:    pulumi.Bool(true),
            AutoGrowEnabled:              pulumi.Bool(true),
            PublicNetworkAccessEnabled:   pulumi.Bool(false),
            SslEnforcementEnabled:        pulumi.Bool(true),
            SslMinimalTlsVersionEnforced: pulumi.String("TLS1_2"),
        })
        if err != nil {
            return err
        }
        return nil
    })
}
import pulumi
import pulumi_azure as azure

example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_server = azure.postgresql.Server("exampleServer",
    location=example_resource_group.location,
    resource_group_name=example_resource_group.name,
    administrator_login="psqladminun",
    administrator_login_password="H@Sh1CoR3!",
    sku_name="GP_Gen5_4",
    version="9.6",
    storage_mb=640000,
    backup_retention_days=7,
    geo_redundant_backup_enabled=True,
    auto_grow_enabled=True,
    public_network_access_enabled=False,
    ssl_enforcement_enabled=True,
    ssl_minimal_tls_version_enforced="TLS1_2")
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleServer = new azure.postgresql.Server("exampleServer", {
    location: exampleResourceGroup.location,
    resourceGroupName: exampleResourceGroup.name,
    administratorLogin: "psqladminun",
    administratorLoginPassword: "H@Sh1CoR3!",
    skuName: "GP_Gen5_4",
    version: "9.6",
    storageMb: 640000,
    backupRetentionDays: 7,
    geoRedundantBackupEnabled: true,
    autoGrowEnabled: true,
    publicNetworkAccessEnabled: false,
    sslEnforcementEnabled: true,
    sslMinimalTlsVersionEnforced: "TLS1_2",
});

Create a Server Resource

new Server(name: string, args: ServerArgs, opts?: CustomResourceOptions);
def Server(resource_name, opts=None, administrator_login=None, administrator_login_password=None, auto_grow_enabled=None, backup_retention_days=None, create_mode=None, creation_source_server_id=None, geo_redundant_backup_enabled=None, infrastructure_encryption_enabled=None, location=None, name=None, public_network_access_enabled=None, resource_group_name=None, restore_point_in_time=None, sku_name=None, ssl_enforcement=None, ssl_enforcement_enabled=None, ssl_minimal_tls_version_enforced=None, storage_mb=None, storage_profile=None, tags=None, threat_detection_policy=None, version=None, __props__=None);
func NewServer(ctx *Context, name string, args ServerArgs, opts ...ResourceOption) (*Server, error)
public Server(string name, ServerArgs args, CustomResourceOptions? opts = null)
name string
The unique name of the resource.
args ServerArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
opts ResourceOptions
A bag of options that control this resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args ServerArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args ServerArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.

Server Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Programming Model docs.

Inputs

The Server resource accepts the following input properties:

ResourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

SkuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

Version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

AdministratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

AdministratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

AutoGrowEnabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

CreateMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

CreationSourceServerId string

For creation modes other then default the source server ID to use.

GeoRedundantBackupEnabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

InfrastructureEncryptionEnabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

Location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

PublicNetworkAccessEnabled bool

Whether or not public network access is allowed for this server. Defaults to true.

RestorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

SslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

SslEnforcementEnabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

SslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

StorageProfile ServerStorageProfileArgs

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

Tags Dictionary<string, string>

A mapping of tags to assign to the resource.

ThreatDetectionPolicy ServerThreatDetectionPolicyArgs

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

ResourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

SkuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

Version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

AdministratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

AdministratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

AutoGrowEnabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

CreateMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

CreationSourceServerId string

For creation modes other then default the source server ID to use.

GeoRedundantBackupEnabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

InfrastructureEncryptionEnabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

Location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

PublicNetworkAccessEnabled bool

Whether or not public network access is allowed for this server. Defaults to true.

RestorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

SslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

SslEnforcementEnabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

SslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

StorageProfile ServerStorageProfile

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

Tags map[string]string

A mapping of tags to assign to the resource.

ThreatDetectionPolicy ServerThreatDetectionPolicy

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

resourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

skuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

administratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

administratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

autoGrowEnabled boolean

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

backupRetentionDays number

Backup retention days for the server, supported values are between 7 and 35 days.

createMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

creationSourceServerId string

For creation modes other then default the source server ID to use.

geoRedundantBackupEnabled boolean

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

infrastructureEncryptionEnabled boolean

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

publicNetworkAccessEnabled boolean

Whether or not public network access is allowed for this server. Defaults to true.

restorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

sslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

sslEnforcementEnabled boolean

Specifies if SSL should be enforced on connections. Possible values are true and false.

sslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

storageMb number

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

storageProfile ServerStorageProfile

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

tags {[key: string]: string}

A mapping of tags to assign to the resource.

threatDetectionPolicy ServerThreatDetectionPolicy

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

resource_group_name str

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

sku_name str

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

version str

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

administrator_login str

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

administrator_login_password str

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

auto_grow_enabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

backup_retention_days float

Backup retention days for the server, supported values are between 7 and 35 days.

create_mode str

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

creation_source_server_id str

For creation modes other then default the source server ID to use.

geo_redundant_backup_enabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

infrastructure_encryption_enabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

location str

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

name str

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

public_network_access_enabled bool

Whether or not public network access is allowed for this server. Defaults to true.

restore_point_in_time str

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

ssl_enforcement str

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

ssl_enforcement_enabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

ssl_minimal_tls_version_enforced str

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

storage_mb float

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

storage_profile Dict[ServerStorageProfile]

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

tags Dict[str, str]

A mapping of tags to assign to the resource.

threat_detection_policy Dict[ServerThreatDetectionPolicy]

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

Outputs

All input properties are implicitly available as output properties. Additionally, the Server resource produces the following output properties:

Fqdn string

The FQDN of the PostgreSQL Server.

Id string
The provider-assigned unique ID for this managed resource.
Fqdn string

The FQDN of the PostgreSQL Server.

Id string
The provider-assigned unique ID for this managed resource.
fqdn string

The FQDN of the PostgreSQL Server.

id string
The provider-assigned unique ID for this managed resource.
fqdn str

The FQDN of the PostgreSQL Server.

id str
The provider-assigned unique ID for this managed resource.

Look up an Existing Server Resource

Get an existing Server resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: ServerState, opts?: CustomResourceOptions): Server
static get(resource_name, id, opts=None, administrator_login=None, administrator_login_password=None, auto_grow_enabled=None, backup_retention_days=None, create_mode=None, creation_source_server_id=None, fqdn=None, geo_redundant_backup_enabled=None, infrastructure_encryption_enabled=None, location=None, name=None, public_network_access_enabled=None, resource_group_name=None, restore_point_in_time=None, sku_name=None, ssl_enforcement=None, ssl_enforcement_enabled=None, ssl_minimal_tls_version_enforced=None, storage_mb=None, storage_profile=None, tags=None, threat_detection_policy=None, version=None, __props__=None);
func GetServer(ctx *Context, name string, id IDInput, state *ServerState, opts ...ResourceOption) (*Server, error)
public static Server Get(string name, Input<string> id, ServerState? state, CustomResourceOptions? opts = null)
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.

The following state arguments are supported:

AdministratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

AdministratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

AutoGrowEnabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

CreateMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

CreationSourceServerId string

For creation modes other then default the source server ID to use.

Fqdn string

The FQDN of the PostgreSQL Server.

GeoRedundantBackupEnabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

InfrastructureEncryptionEnabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

Location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

PublicNetworkAccessEnabled bool

Whether or not public network access is allowed for this server. Defaults to true.

ResourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

RestorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

SkuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

SslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

SslEnforcementEnabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

SslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

StorageProfile ServerStorageProfileArgs

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

Tags Dictionary<string, string>

A mapping of tags to assign to the resource.

ThreatDetectionPolicy ServerThreatDetectionPolicyArgs

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

Version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

AdministratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

AdministratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

AutoGrowEnabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

CreateMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

CreationSourceServerId string

For creation modes other then default the source server ID to use.

Fqdn string

The FQDN of the PostgreSQL Server.

GeoRedundantBackupEnabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

InfrastructureEncryptionEnabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

Location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

PublicNetworkAccessEnabled bool

Whether or not public network access is allowed for this server. Defaults to true.

ResourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

RestorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

SkuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

SslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

SslEnforcementEnabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

SslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

StorageProfile ServerStorageProfile

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

Tags map[string]string

A mapping of tags to assign to the resource.

ThreatDetectionPolicy ServerThreatDetectionPolicy

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

Version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

administratorLogin string

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

administratorLoginPassword string

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

autoGrowEnabled boolean

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

backupRetentionDays number

Backup retention days for the server, supported values are between 7 and 35 days.

createMode string

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

creationSourceServerId string

For creation modes other then default the source server ID to use.

fqdn string

The FQDN of the PostgreSQL Server.

geoRedundantBackupEnabled boolean

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

infrastructureEncryptionEnabled boolean

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

location string

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

name string

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

publicNetworkAccessEnabled boolean

Whether or not public network access is allowed for this server. Defaults to true.

resourceGroupName string

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

restorePointInTime string

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

skuName string

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

sslEnforcement string

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

sslEnforcementEnabled boolean

Specifies if SSL should be enforced on connections. Possible values are true and false.

sslMinimalTlsVersionEnforced string

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

storageMb number

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

storageProfile ServerStorageProfile

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

tags {[key: string]: string}

A mapping of tags to assign to the resource.

threatDetectionPolicy ServerThreatDetectionPolicy

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

version string

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

administrator_login str

The Administrator Login for the PostgreSQL Server. Required when create_mode is Default. Changing this forces a new resource to be created.

administrator_login_password str

The Password associated with the administrator_login for the PostgreSQL Server. Required when create_mode is Default.

auto_grow_enabled bool

Enable/Disable auto-growing of the storage. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.

backup_retention_days float

Backup retention days for the server, supported values are between 7 and 35 days.

create_mode str

The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.

creation_source_server_id str

For creation modes other then default the source server ID to use.

fqdn str

The FQDN of the PostgreSQL Server.

geo_redundant_backup_enabled bool

Turn Geo-redundant server backups on/off. This allows you to choose between locally redundant or geo-redundant backup storage in the General Purpose and Memory Optimized tiers. When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center. This provides better protection and ability to restore your server in a different region in the event of a disaster. This is not support for the Basic tier.

infrastructure_encryption_enabled bool

Whether or not infrastructure is encrypted for this server. Defaults to false. Changing this forces a new resource to be created.

location str

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

name str

Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.

public_network_access_enabled bool

Whether or not public network access is allowed for this server. Defaults to true.

resource_group_name str

The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.

restore_point_in_time str

When create_mode is PointInTimeRestore the point in time to restore from creation_source_server_id.

sku_name str

Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8). For more information see the product documentation.

ssl_enforcement str

Deprecated: this has been renamed to the boolean ssl_enforcement_enabled and will be removed in version 3.0 of the provider.

ssl_enforcement_enabled bool

Specifies if SSL should be enforced on connections. Possible values are true and false.

ssl_minimal_tls_version_enforced str

The mimimun TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLSEnforcementDisabled.

storage_mb float

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

storage_profile Dict[ServerStorageProfile]

Deprecated: all storage_profile properties have been move to the top level. This block will be removed in version 3.0 of the provider.

tags Dict[str, str]

A mapping of tags to assign to the resource.

threat_detection_policy Dict[ServerThreatDetectionPolicy]

Threat detection policy configuration, known in the API as Server Security Alerts Policy. The threat_detection_policy block supports fields documented below.

version str

Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10, 10.0, and 11. Changing this forces a new resource to be created.

Supporting Types

ServerStorageProfile

See the input and output API doc for this type.

See the input and output API doc for this type.

See the input and output API doc for this type.

AutoGrow string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

GeoRedundantBackup string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

AutoGrow string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

BackupRetentionDays int

Backup retention days for the server, supported values are between 7 and 35 days.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

GeoRedundantBackup string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

StorageMb int

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

autoGrow string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

backupRetentionDays number

Backup retention days for the server, supported values are between 7 and 35 days.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

geoRedundantBackup string

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

storageMb number

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

autoGrow str

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

backup_retention_days float

Backup retention days for the server, supported values are between 7 and 35 days.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

geoRedundantBackup str

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

storage_mb float

Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs. For more information see the product documentation.

Deprecated: this has been moved to the top level and will be removed in version 3.0 of the provider.

ServerThreatDetectionPolicy

See the input and output API doc for this type.

See the input and output API doc for this type.

See the input and output API doc for this type.

DisabledAlerts List<string>

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

EmailAccountAdmins bool

Should the account administrators be emailed when this alert is triggered?

EmailAddresses List<string>

A list of email addresses which alerts should be sent to.

Enabled bool

Is the policy enabled?

RetentionDays int

Specifies the number of days to keep in the Threat Detection audit logs.

StorageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account.

StorageEndpoint string

Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

DisabledAlerts []string

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

EmailAccountAdmins bool

Should the account administrators be emailed when this alert is triggered?

EmailAddresses []string

A list of email addresses which alerts should be sent to.

Enabled bool

Is the policy enabled?

RetentionDays int

Specifies the number of days to keep in the Threat Detection audit logs.

StorageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account.

StorageEndpoint string

Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

disabledAlerts string[]

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

emailAccountAdmins boolean

Should the account administrators be emailed when this alert is triggered?

emailAddresses string[]

A list of email addresses which alerts should be sent to.

enabled boolean

Is the policy enabled?

retentionDays number

Specifies the number of days to keep in the Threat Detection audit logs.

storageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account.

storageEndpoint string

Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

disabled_alerts List[str]

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

email_account_admins bool

Should the account administrators be emailed when this alert is triggered?

email_addresses List[str]

A list of email addresses which alerts should be sent to.

enabled bool

Is the policy enabled?

retention_days float

Specifies the number of days to keep in the Threat Detection audit logs.

storage_account_access_key str

Specifies the identifier key of the Threat Detection audit storage account.

storage_endpoint str

Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

Package Details

Repository
https://github.com/pulumi/pulumi-azure
License
Apache-2.0
Notes
This Pulumi package is based on the azurerm Terraform Provider.