Linode v4.6.1, Sep 15 23

Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi

linode.DatabasePostgresql

Explore with Pulumi AI

Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi

pulumi/pulumi-linode

updates

The following arguments are supported in the updates specification block:

day_of_week - (Required) The day to perform maintenance. (monday, tuesday, …)
duration - (Required) The maximum maintenance window time in hours. (1..3)
frequency - (Required) Whether maintenance occurs on a weekly or monthly basis. (weekly, monthly)
hour_of_day - (Required) The hour to begin maintenance based in UTC time. (0..23)
week_of_month - (Optional) The week of the month to perform monthly frequency updates. Required for monthly frequency updates. (1..4)

Example Usage

Creating a simple PostgreSQL database instance

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Linode = Pulumi.Linode;

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabasePostgresql("foobar", new()
    {
        EngineId = "postgresql/13.2",
        Label = "mydatabase",
        Region = "us-southeast",
        Type = "g6-nanode-1",
    });

});

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v4/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabasePostgresql(ctx, "foobar", &linode.DatabasePostgresqlArgs{
			EngineId: pulumi.String("postgresql/13.2"),
			Label:    pulumi.String("mydatabase"),
			Region:   pulumi.String("us-southeast"),
			Type:     pulumi.String("g6-nanode-1"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresql;
import com.pulumi.linode.DatabasePostgresqlArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabasePostgresql("foobar", DatabasePostgresqlArgs.builder()        
            .engineId("postgresql/13.2")
            .label("mydatabase")
            .region("us-southeast")
            .type("g6-nanode-1")
            .build());

    }
}

import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresql("foobar",
    engine_id="postgresql/13.2",
    label="mydatabase",
    region="us-southeast",
    type="g6-nanode-1")

import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabasePostgresql("foobar", {
    engineId: "postgresql/13.2",
    label: "mydatabase",
    region: "us-southeast",
    type: "g6-nanode-1",
});

resources:
  foobar:
    type: linode:DatabasePostgresql
    properties:
      engineId: postgresql/13.2
      label: mydatabase
      region: us-southeast
      type: g6-nanode-1

Creating a complex PostgreSQL database instance

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Linode = Pulumi.Linode;

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabasePostgresql("foobar", new()
    {
        AllowLists = new[]
        {
            "0.0.0.0/0",
        },
        ClusterSize = 3,
        Encrypted = true,
        EngineId = "postgresql/13.2",
        Label = "mydatabase",
        Region = "us-southeast",
        ReplicationCommitType = "remote_write",
        ReplicationType = "semi_synch",
        SslConnection = true,
        Type = "g6-nanode-1",
        Updates = new Linode.Inputs.DatabasePostgresqlUpdatesArgs
        {
            DayOfWeek = "saturday",
            Duration = 1,
            Frequency = "monthly",
            HourOfDay = 22,
            WeekOfMonth = 2,
        },
    });

});

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v4/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabasePostgresql(ctx, "foobar", &linode.DatabasePostgresqlArgs{
			AllowLists: pulumi.StringArray{
				pulumi.String("0.0.0.0/0"),
			},
			ClusterSize:           pulumi.Int(3),
			Encrypted:             pulumi.Bool(true),
			EngineId:              pulumi.String("postgresql/13.2"),
			Label:                 pulumi.String("mydatabase"),
			Region:                pulumi.String("us-southeast"),
			ReplicationCommitType: pulumi.String("remote_write"),
			ReplicationType:       pulumi.String("semi_synch"),
			SslConnection:         pulumi.Bool(true),
			Type:                  pulumi.String("g6-nanode-1"),
			Updates: &linode.DatabasePostgresqlUpdatesArgs{
				DayOfWeek:   pulumi.String("saturday"),
				Duration:    pulumi.Int(1),
				Frequency:   pulumi.String("monthly"),
				HourOfDay:   pulumi.Int(22),
				WeekOfMonth: pulumi.Int(2),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresql;
import com.pulumi.linode.DatabasePostgresqlArgs;
import com.pulumi.linode.inputs.DatabasePostgresqlUpdatesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var foobar = new DatabasePostgresql("foobar", DatabasePostgresqlArgs.builder()        
            .allowLists("0.0.0.0/0")
            .clusterSize(3)
            .encrypted(true)
            .engineId("postgresql/13.2")
            .label("mydatabase")
            .region("us-southeast")
            .replicationCommitType("remote_write")
            .replicationType("semi_synch")
            .sslConnection(true)
            .type("g6-nanode-1")
            .updates(DatabasePostgresqlUpdatesArgs.builder()
                .dayOfWeek("saturday")
                .duration(1)
                .frequency("monthly")
                .hourOfDay(22)
                .weekOfMonth(2)
                .build())
            .build());

    }
}

import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresql("foobar",
    allow_lists=["0.0.0.0/0"],
    cluster_size=3,
    encrypted=True,
    engine_id="postgresql/13.2",
    label="mydatabase",
    region="us-southeast",
    replication_commit_type="remote_write",
    replication_type="semi_synch",
    ssl_connection=True,
    type="g6-nanode-1",
    updates=linode.DatabasePostgresqlUpdatesArgs(
        day_of_week="saturday",
        duration=1,
        frequency="monthly",
        hour_of_day=22,
        week_of_month=2,
    ))

import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const foobar = new linode.DatabasePostgresql("foobar", {
    allowLists: ["0.0.0.0/0"],
    clusterSize: 3,
    encrypted: true,
    engineId: "postgresql/13.2",
    label: "mydatabase",
    region: "us-southeast",
    replicationCommitType: "remote_write",
    replicationType: "semi_synch",
    sslConnection: true,
    type: "g6-nanode-1",
    updates: {
        dayOfWeek: "saturday",
        duration: 1,
        frequency: "monthly",
        hourOfDay: 22,
        weekOfMonth: 2,
    },
});

resources:
  foobar:
    type: linode:DatabasePostgresql
    properties:
      allowLists:
        - 0.0.0.0/0
      clusterSize: 3
      encrypted: true
      engineId: postgresql/13.2
      label: mydatabase
      region: us-southeast
      replicationCommitType: remote_write
      replicationType: semi_synch
      sslConnection: true
      type: g6-nanode-1
      updates:
        dayOfWeek: saturday
        duration: 1
        frequency: monthly
        hourOfDay: 22
        weekOfMonth: 2

Create DatabasePostgresql Resource

new DatabasePostgresql(name: string, args: DatabasePostgresqlArgs, opts?: CustomResourceOptions);

@overload
def DatabasePostgresql(resource_name: str,
                       opts: Optional[ResourceOptions] = None,
                       allow_lists: Optional[Sequence[str]] = None,
                       cluster_size: Optional[int] = None,
                       encrypted: Optional[bool] = None,
                       engine_id: Optional[str] = None,
                       label: Optional[str] = None,
                       region: Optional[str] = None,
                       replication_commit_type: Optional[str] = None,
                       replication_type: Optional[str] = None,
                       ssl_connection: Optional[bool] = None,
                       type: Optional[str] = None,
                       updates: Optional[DatabasePostgresqlUpdatesArgs] = None)
@overload
def DatabasePostgresql(resource_name: str,
                       args: DatabasePostgresqlArgs,
                       opts: Optional[ResourceOptions] = None)

func NewDatabasePostgresql(ctx *Context, name string, args DatabasePostgresqlArgs, opts ...ResourceOption) (*DatabasePostgresql, error)

public DatabasePostgresql(string name, DatabasePostgresqlArgs args, CustomResourceOptions? opts = null)

public DatabasePostgresql(String name, DatabasePostgresqlArgs args)
public DatabasePostgresql(String name, DatabasePostgresqlArgs args, CustomResourceOptions options)

type: linode:DatabasePostgresql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string: The unique name of the resource.
args DatabasePostgresqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args DatabasePostgresqlArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args DatabasePostgresqlArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args DatabasePostgresqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args DatabasePostgresqlArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

DatabasePostgresql Resource Properties

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

Inputs

The DatabasePostgresql resource accepts the following input properties:

EngineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

Label string

A unique, user-defined string referring to the Managed Database.

Region string

The region to use for the Managed Database.

Type string

The Linode Instance type used for the nodes of the Managed Database instance.

AllowLists List<string>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

ClusterSize int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

Encrypted bool

Whether the Managed Databases is encrypted. (default false)

ReplicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

ReplicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

SslConnection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

Updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

EngineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

Label string

A unique, user-defined string referring to the Managed Database.

Region string

The region to use for the Managed Database.

Type string

The Linode Instance type used for the nodes of the Managed Database instance.

AllowLists []string

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

ClusterSize int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

Encrypted bool

Whether the Managed Databases is encrypted. (default false)

ReplicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

ReplicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

SslConnection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

Updates DatabasePostgresqlUpdatesArgs

Configuration settings for automated patch update maintenance for the Managed Database.

engineId String

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

label String

A unique, user-defined string referring to the Managed Database.

region String

The region to use for the Managed Database.

type String

The Linode Instance type used for the nodes of the Managed Database instance.

allowLists List<String>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

clusterSize Integer

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

encrypted Boolean

Whether the Managed Databases is encrypted. (default false)

replicationCommitType String

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType String

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

sslConnection Boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

engineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

label string

A unique, user-defined string referring to the Managed Database.

region string

The region to use for the Managed Database.

type string

The Linode Instance type used for the nodes of the Managed Database instance.

allowLists string[]

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

clusterSize number

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

encrypted boolean

Whether the Managed Databases is encrypted. (default false)

replicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

sslConnection boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

engine_id str

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

label str

A unique, user-defined string referring to the Managed Database.

region str

The region to use for the Managed Database.

type str

The Linode Instance type used for the nodes of the Managed Database instance.

allow_lists Sequence[str]

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

cluster_size int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

encrypted bool

Whether the Managed Databases is encrypted. (default false)

replication_commit_type str

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replication_type str

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

ssl_connection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

updates DatabasePostgresqlUpdatesArgs

Configuration settings for automated patch update maintenance for the Managed Database.

engineId String

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

label String

A unique, user-defined string referring to the Managed Database.

region String

The region to use for the Managed Database.

type String

The Linode Instance type used for the nodes of the Managed Database instance.

allowLists List<String>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

clusterSize Number

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

encrypted Boolean

Whether the Managed Databases is encrypted. (default false)

replicationCommitType String

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType String

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

sslConnection Boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

updates Property Map

Configuration settings for automated patch update maintenance for the Managed Database.

Outputs

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

CaCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
Created string: When this Managed Database was created.
Engine string: The Managed Database engine. (e.g. postgresql)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id string: The provider-assigned unique ID for this managed resource.
Port int: The access port for this Managed Database.
RootPassword string: The randomly-generated root password for the Managed Database instance.
RootUsername string: The root username for the Managed Database instance.
Status string: The operating status of the Managed Database.
Updated string: When this Managed Database was last updated.
Version string: The Managed Database engine version. (e.g. 13.2)

CaCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
Created string: When this Managed Database was created.
Engine string: The Managed Database engine. (e.g. postgresql)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id string: The provider-assigned unique ID for this managed resource.
Port int: The access port for this Managed Database.
RootPassword string: The randomly-generated root password for the Managed Database instance.
RootUsername string: The root username for the Managed Database instance.
Status string: The operating status of the Managed Database.
Updated string: When this Managed Database was last updated.
Version string: The Managed Database engine version. (e.g. 13.2)

caCert String: The base64-encoded SSL CA certificate for the Managed Database instance.
created String: When this Managed Database was created.
engine String: The Managed Database engine. (e.g. postgresql)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id String: The provider-assigned unique ID for this managed resource.
port Integer: The access port for this Managed Database.
rootPassword String: The randomly-generated root password for the Managed Database instance.
rootUsername String: The root username for the Managed Database instance.
status String: The operating status of the Managed Database.
updated String: When this Managed Database was last updated.
version String: The Managed Database engine version. (e.g. 13.2)

caCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
created string: When this Managed Database was created.
engine string: The Managed Database engine. (e.g. postgresql)
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private network host for the Managed Database.
id string: The provider-assigned unique ID for this managed resource.
port number: The access port for this Managed Database.
rootPassword string: The randomly-generated root password for the Managed Database instance.
rootUsername string: The root username for the Managed Database instance.
status string: The operating status of the Managed Database.
updated string: When this Managed Database was last updated.
version string: The Managed Database engine version. (e.g. 13.2)

ca_cert str: The base64-encoded SSL CA certificate for the Managed Database instance.
created str: When this Managed Database was created.
engine str: The Managed Database engine. (e.g. postgresql)
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private network host for the Managed Database.
id str: The provider-assigned unique ID for this managed resource.
port int: The access port for this Managed Database.
root_password str: The randomly-generated root password for the Managed Database instance.
root_username str: The root username for the Managed Database instance.
status str: The operating status of the Managed Database.
updated str: When this Managed Database was last updated.
version str: The Managed Database engine version. (e.g. 13.2)

caCert String: The base64-encoded SSL CA certificate for the Managed Database instance.
created String: When this Managed Database was created.
engine String: The Managed Database engine. (e.g. postgresql)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id String: The provider-assigned unique ID for this managed resource.
port Number: The access port for this Managed Database.
rootPassword String: The randomly-generated root password for the Managed Database instance.
rootUsername String: The root username for the Managed Database instance.
status String: The operating status of the Managed Database.
updated String: When this Managed Database was last updated.
version String: The Managed Database engine version. (e.g. 13.2)

Look up Existing DatabasePostgresql Resource

Get an existing DatabasePostgresql 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?: DatabasePostgresqlState, opts?: CustomResourceOptions): DatabasePostgresql

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        allow_lists: Optional[Sequence[str]] = None,
        ca_cert: Optional[str] = None,
        cluster_size: Optional[int] = None,
        created: Optional[str] = None,
        encrypted: Optional[bool] = None,
        engine: Optional[str] = None,
        engine_id: Optional[str] = None,
        host_primary: Optional[str] = None,
        host_secondary: Optional[str] = None,
        label: Optional[str] = None,
        port: Optional[int] = None,
        region: Optional[str] = None,
        replication_commit_type: Optional[str] = None,
        replication_type: Optional[str] = None,
        root_password: Optional[str] = None,
        root_username: Optional[str] = None,
        ssl_connection: Optional[bool] = None,
        status: Optional[str] = None,
        type: Optional[str] = None,
        updated: Optional[str] = None,
        updates: Optional[DatabasePostgresqlUpdatesArgs] = None,
        version: Optional[str] = None) -> DatabasePostgresql

func GetDatabasePostgresql(ctx *Context, name string, id IDInput, state *DatabasePostgresqlState, opts ...ResourceOption) (*DatabasePostgresql, error)

public static DatabasePostgresql Get(string name, Input<string> id, DatabasePostgresqlState? state, CustomResourceOptions? opts = null)

public static DatabasePostgresql get(String name, Output<String> id, DatabasePostgresqlState state, CustomResourceOptions options)

Resource lookup is not supported in YAML

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.

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:

AllowLists List<string>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

CaCert string

The base64-encoded SSL CA certificate for the Managed Database instance.

ClusterSize int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

Created string

When this Managed Database was created.

Encrypted bool

Whether the Managed Databases is encrypted. (default false)

Engine string

The Managed Database engine. (e.g. postgresql)

EngineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

HostPrimary string

The primary host for the Managed Database.

HostSecondary string

The secondary/private network host for the Managed Database.

Label string

A unique, user-defined string referring to the Managed Database.

Port int

The access port for this Managed Database.

Region string

The region to use for the Managed Database.

ReplicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

ReplicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

RootPassword string

The randomly-generated root password for the Managed Database instance.

RootUsername string

The root username for the Managed Database instance.

SslConnection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

Status string

The operating status of the Managed Database.

Type string

The Linode Instance type used for the nodes of the Managed Database instance.

Updated string

When this Managed Database was last updated.

Updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

Version string

The Managed Database engine version. (e.g. 13.2)

AllowLists []string

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

CaCert string

The base64-encoded SSL CA certificate for the Managed Database instance.

ClusterSize int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

Created string

When this Managed Database was created.

Encrypted bool

Whether the Managed Databases is encrypted. (default false)

Engine string

The Managed Database engine. (e.g. postgresql)

EngineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

HostPrimary string

The primary host for the Managed Database.

HostSecondary string

The secondary/private network host for the Managed Database.

Label string

A unique, user-defined string referring to the Managed Database.

Port int

The access port for this Managed Database.

Region string

The region to use for the Managed Database.

ReplicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

ReplicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

RootPassword string

The randomly-generated root password for the Managed Database instance.

RootUsername string

The root username for the Managed Database instance.

SslConnection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

Status string

The operating status of the Managed Database.

Type string

The Linode Instance type used for the nodes of the Managed Database instance.

Updated string

When this Managed Database was last updated.

Updates DatabasePostgresqlUpdatesArgs

Configuration settings for automated patch update maintenance for the Managed Database.

Version string

The Managed Database engine version. (e.g. 13.2)

allowLists List<String>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

caCert String

The base64-encoded SSL CA certificate for the Managed Database instance.

clusterSize Integer

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

created String

When this Managed Database was created.

encrypted Boolean

Whether the Managed Databases is encrypted. (default false)

engine String

The Managed Database engine. (e.g. postgresql)

engineId String

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

hostPrimary String

The primary host for the Managed Database.

hostSecondary String

The secondary/private network host for the Managed Database.

label String

A unique, user-defined string referring to the Managed Database.

port Integer

The access port for this Managed Database.

region String

The region to use for the Managed Database.

replicationCommitType String

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType String

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

rootPassword String

The randomly-generated root password for the Managed Database instance.

rootUsername String

The root username for the Managed Database instance.

sslConnection Boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

status String

The operating status of the Managed Database.

type String

The Linode Instance type used for the nodes of the Managed Database instance.

updated String

When this Managed Database was last updated.

updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

version String

The Managed Database engine version. (e.g. 13.2)

allowLists string[]

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

caCert string

The base64-encoded SSL CA certificate for the Managed Database instance.

clusterSize number

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

created string

When this Managed Database was created.

encrypted boolean

Whether the Managed Databases is encrypted. (default false)

engine string

The Managed Database engine. (e.g. postgresql)

engineId string

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

hostPrimary string

The primary host for the Managed Database.

hostSecondary string

The secondary/private network host for the Managed Database.

label string

A unique, user-defined string referring to the Managed Database.

port number

The access port for this Managed Database.

region string

The region to use for the Managed Database.

replicationCommitType string

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType string

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

rootPassword string

The randomly-generated root password for the Managed Database instance.

rootUsername string

The root username for the Managed Database instance.

sslConnection boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

status string

The operating status of the Managed Database.

type string

The Linode Instance type used for the nodes of the Managed Database instance.

updated string

When this Managed Database was last updated.

updates DatabasePostgresqlUpdates

Configuration settings for automated patch update maintenance for the Managed Database.

version string

The Managed Database engine version. (e.g. 13.2)

allow_lists Sequence[str]

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

ca_cert str

The base64-encoded SSL CA certificate for the Managed Database instance.

cluster_size int

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

created str

When this Managed Database was created.

encrypted bool

Whether the Managed Databases is encrypted. (default false)

engine str

The Managed Database engine. (e.g. postgresql)

engine_id str

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

host_primary str

The primary host for the Managed Database.

host_secondary str

The secondary/private network host for the Managed Database.

label str

A unique, user-defined string referring to the Managed Database.

port int

The access port for this Managed Database.

region str

The region to use for the Managed Database.

replication_commit_type str

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replication_type str

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

root_password str

The randomly-generated root password for the Managed Database instance.

root_username str

The root username for the Managed Database instance.

ssl_connection bool

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

status str

The operating status of the Managed Database.

type str

The Linode Instance type used for the nodes of the Managed Database instance.

updated str

When this Managed Database was last updated.

updates DatabasePostgresqlUpdatesArgs

Configuration settings for automated patch update maintenance for the Managed Database.

version str

The Managed Database engine version. (e.g. 13.2)

allowLists List<String>

A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.

caCert String

The base64-encoded SSL CA certificate for the Managed Database instance.

clusterSize Number

The number of Linode Instance nodes deployed to the Managed Database. (default 1)

created String

When this Managed Database was created.

encrypted Boolean

Whether the Managed Databases is encrypted. (default false)

engine String

The Managed Database engine. (e.g. postgresql)

engineId String

The Managed Database engine in engine/version format. (e.g. postgresql/13.2)

hostPrimary String

The primary host for the Managed Database.

hostSecondary String

The secondary/private network host for the Managed Database.

label String

A unique, user-defined string referring to the Managed Database.

port Number

The access port for this Managed Database.

region String

The region to use for the Managed Database.

replicationCommitType String

The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off; default off)

Must be local or off for the asynch replication type.
Must be on, remote_write, or remote_apply for the semi_synch replication type.

replicationType String

The replication method used for the Managed Database. (none, asynch, semi_synch; default none)

Must be none for a single node cluster.
Must be asynch or semi_synch for a high availability cluster.

rootPassword String

The randomly-generated root password for the Managed Database instance.

rootUsername String

The root username for the Managed Database instance.

sslConnection Boolean

Whether to require SSL credentials to establish a connection to the Managed Database. (default false)

updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.

status String

The operating status of the Managed Database.

type String

The Linode Instance type used for the nodes of the Managed Database instance.

updated String

When this Managed Database was last updated.

updates Property Map

Configuration settings for automated patch update maintenance for the Managed Database.

version String

The Managed Database engine version. (e.g. 13.2)

Supporting Types

DatabasePostgresqlUpdates, DatabasePostgresqlUpdatesArgs

DayOfWeek string
Duration int
Frequency string
HourOfDay int
WeekOfMonth int

DayOfWeek string
Duration int
Frequency string
HourOfDay int
WeekOfMonth int

dayOfWeek String
duration Integer
frequency String
hourOfDay Integer
weekOfMonth Integer

dayOfWeek string
duration number
frequency string
hourOfDay number
weekOfMonth number

day_of_week str
duration int
frequency str
hour_of_day int
week_of_month int

dayOfWeek String
duration Number
frequency String
hourOfDay Number
weekOfMonth Number

Import

Linode PostgreSQL Databases can be imported using the id, e.g.

 $ pulumi import linode:index/databasePostgresql:DatabasePostgresql foobar 1234567

Package Details

Repository: Linode pulumi/pulumi-linode
License: Apache-2.0
Notes: This Pulumi package is based on the linode Terraform Provider.

Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi

pulumi/pulumi-linode

linode.DatabasePostgresql

On this page

On this page

updates

Example Usage

Create DatabasePostgresql Resource

DatabasePostgresql Resource Properties

Inputs

Outputs

Look up Existing DatabasePostgresql Resource

Supporting Types

DatabasePostgresqlUpdates, DatabasePostgresqlUpdatesArgs

Import

Package Details

On this page

On this page