linode.DatabasePostgresql
Explore with Pulumi AI
Provides a Linode PostgreSQL Database resource. This can be used to create, modify, and delete Linode PostgreSQL Databases. For more information, see the Linode APIv4 docs.
Please keep in mind that Managed Databases can take up to an hour to provision.
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 formonthly
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:
- Engine
Id 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.
- Allow
Lists 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.- 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 stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- Replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_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
Database
Postgresql Updates Configuration settings for automated patch update maintenance for the Managed Database.
- Engine
Id 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.
- Allow
Lists []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.- 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 stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- Replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_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
Database
Postgresql Updates Args Configuration settings for automated patch update maintenance for the Managed Database.
- engine
Id 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.
- allow
Lists 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.- cluster
Size Integer The number of Linode Instance nodes deployed to the Managed Database. (default
1
)- encrypted Boolean
Whether the Managed Databases is encrypted. (default
false
)- replication
Commit StringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type String The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- ssl
Connection 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
Database
Postgresql Updates Configuration settings for automated patch update maintenance for the Managed Database.
- engine
Id 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.
- allow
Lists 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.- cluster
Size number The number of Linode Instance nodes deployed to the Managed Database. (default
1
)- encrypted boolean
Whether the Managed Databases is encrypted. (default
false
)- replication
Commit stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- ssl
Connection 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
Database
Postgresql Updates 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_ strtype The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication_
type str The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_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
Database
Postgresql Updates Args Configuration settings for automated patch update maintenance for the Managed Database.
- engine
Id 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.
- allow
Lists 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.- cluster
Size Number The number of Linode Instance nodes deployed to the Managed Database. (default
1
)- encrypted Boolean
Whether the Managed Databases is encrypted. (default
false
)- replication
Commit StringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type String The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- ssl
Connection 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:
- Ca
Cert 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
)- Host
Primary string The primary host for the Managed Database.
- Host
Secondary 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.
- Root
Password string The randomly-generated root password for the Managed Database instance.
- Root
Username 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 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
)- Host
Primary string The primary host for the Managed Database.
- Host
Secondary 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.
- Root
Password string The randomly-generated root password for the Managed Database instance.
- Root
Username 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 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
)- host
Primary String The primary host for the Managed Database.
- host
Secondary 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.
- root
Password String The randomly-generated root password for the Managed Database instance.
- root
Username 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 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
)- host
Primary string The primary host for the Managed Database.
- host
Secondary 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.
- root
Password string The randomly-generated root password for the Managed Database instance.
- root
Username 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
)
- ca
Cert 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
)- host
Primary String The primary host for the Managed Database.
- host
Secondary 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.
- root
Password String The randomly-generated root password for the Managed Database instance.
- root
Username 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.
- Allow
Lists 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.- Ca
Cert string 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 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
)- Engine
Id string The Managed Database engine in engine/version format. (e.g.
postgresql/13.2
)- Host
Primary string The primary host for the Managed Database.
- Host
Secondary 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.
- Replication
Commit stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- Replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- Root
Password string The randomly-generated root password for the Managed Database instance.
- Root
Username string 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 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
Database
Postgresql Updates Configuration settings for automated patch update maintenance for the Managed Database.
- Version string
The Managed Database engine version. (e.g.
13.2
)
- Allow
Lists []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.- Ca
Cert string 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 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
)- Engine
Id string The Managed Database engine in engine/version format. (e.g.
postgresql/13.2
)- Host
Primary string The primary host for the Managed Database.
- Host
Secondary 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.
- Replication
Commit stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- Replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- Root
Password string The randomly-generated root password for the Managed Database instance.
- Root
Username string 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 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
Database
Postgresql Updates Args Configuration settings for automated patch update maintenance for the Managed Database.
- Version string
The Managed Database engine version. (e.g.
13.2
)
- allow
Lists 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.- ca
Cert String The base64-encoded SSL CA certificate for the Managed Database instance.
- cluster
Size 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
)- engine
Id String The Managed Database engine in engine/version format. (e.g.
postgresql/13.2
)- host
Primary String The primary host for the Managed Database.
- host
Secondary 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.
- replication
Commit StringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type String The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- root
Password String The randomly-generated root password for the Managed Database instance.
- root
Username String The root username for the Managed Database instance.
- ssl
Connection 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
Database
Postgresql Updates Configuration settings for automated patch update maintenance for the Managed Database.
- version String
The Managed Database engine version. (e.g.
13.2
)
- allow
Lists 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.- ca
Cert string The base64-encoded SSL CA certificate for the Managed Database instance.
- cluster
Size 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
)- engine
Id string The Managed Database engine in engine/version format. (e.g.
postgresql/13.2
)- host
Primary string The primary host for the Managed Database.
- host
Secondary 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.
- replication
Commit stringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type string The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- root
Password string The randomly-generated root password for the Managed Database instance.
- root
Username string The root username for the Managed Database instance.
- ssl
Connection 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
Database
Postgresql Updates 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_ strtype The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication_
type str The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_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
Database
Postgresql Updates Args Configuration settings for automated patch update maintenance for the Managed Database.
- version str
The Managed Database engine version. (e.g.
13.2
)
- allow
Lists 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.- ca
Cert String The base64-encoded SSL CA certificate for the Managed Database instance.
- cluster
Size 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
)- engine
Id String The Managed Database engine in engine/version format. (e.g.
postgresql/13.2
)- host
Primary String The primary host for the Managed Database.
- host
Secondary 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.
- replication
Commit StringType The synchronization level of the replicating server. (
on
,local
,remote_write
,remote_apply
,off
; defaultoff
)Must be
local
oroff
for theasynch
replication type.Must be
on
,remote_write
, orremote_apply
for thesemi_synch
replication type.
- replication
Type String The replication method used for the Managed Database. (
none
,asynch
,semi_synch
; defaultnone
)Must be
none
for a single node cluster.Must be
asynch
orsemi_synch
for a high availability cluster.
- root
Password String The randomly-generated root password for the Managed Database instance.
- root
Username String The root username for the Managed Database instance.
- ssl
Connection 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
- Day
Of stringWeek - Duration int
- Frequency string
- Hour
Of intDay - Week
Of intMonth
- Day
Of stringWeek - Duration int
- Frequency string
- Hour
Of intDay - Week
Of intMonth
- day
Of StringWeek - duration Integer
- frequency String
- hour
Of IntegerDay - week
Of IntegerMonth
- day
Of stringWeek - duration number
- frequency string
- hour
Of numberDay - week
Of numberMonth
- day_
of_ strweek - duration int
- frequency str
- hour_
of_ intday - week_
of_ intmonth
- day
Of StringWeek - duration Number
- frequency String
- hour
Of NumberDay - week
Of NumberMonth
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.