Linode

Pulumi Official
Package maintained by Pulumi
v3.9.0 published on Friday, Jun 17, 2022 by Pulumi

getDatabasePostgresql

Provides information about a Linode PostgreSQL Database.

Attributes

The linode.DatabasePostgresql data source exports the following attributes:

  • allow_list - 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.

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

  • cluster_size - The number of Linode Instance nodes deployed to the Managed Database.

  • created - When this Managed Database was created.

  • encrypted - Whether the Managed Databases is encrypted.

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

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

  • host_primary - The primary host for the Managed Database.

  • host_secondary - The secondary/private network host for the Managed Database.

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

  • region - The region that hosts this Linode Managed Database.

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

  • root_username - The root username for the Managed Database instance.

  • replication_type - The replication method used for the Managed Database. (none, asynch, semi_synch)

  • replication_commit_type - (Optional) The synchronization level of the replicating server. (on, local, remote_write, remote_apply, off)

  • ssl_connection - Whether to require SSL credentials to establish a connection to the Managed Database.

  • status - The operating status of the Managed Database.

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

  • updated - When this Managed Database was last updated.

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

  • version - The Managed Database engine version. (e.g. v8.0.26)

updates

The following arguments are exported by the updates specification block:

  • day_of_week - The day to perform maintenance. (monday, tuesday, …)

  • duration - The maximum maintenance window time in hours. (1..3)

  • frequency - Whether maintenance occurs on a weekly or monthly basis. (weekly, monthly)

  • hour_of_day - The hour to begin maintenance based in UTC time. (0..23)

  • week_of_month - The week of the month to perform monthly frequency updates. Required for monthly frequency updates. (1..4)

Example Usage

using Pulumi;
using Linode = Pulumi.Linode;

class MyStack : Stack
{
    public MyStack()
    {
        var my_db = Output.Create(Linode.GetDatabasePostgresql.InvokeAsync(new Linode.GetDatabasePostgresqlArgs
        {
            DatabaseId = 12345,
        }));
    }

}
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.LookupDatabasePostgresql(ctx, &GetDatabasePostgresqlArgs{
			DatabaseId: 12345,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import java.util.*;
import java.io.*;
import java.nio.*;
import com.pulumi.*;

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

    public static void stack(Context ctx) {
        final var my-db = Output.of(LinodeFunctions.getDatabasePostgresql(GetDatabasePostgresqlArgs.builder()
            .databaseId(12345)
            .build()));

        }
}
import pulumi
import pulumi_linode as linode

my_db = linode.get_database_postgresql(database_id=12345)
import * as pulumi from "@pulumi/pulumi";
import * as linode from "@pulumi/linode";

const my_db = pulumi.output(linode.getDatabasePostgresql({
    databaseId: 12345,
}));
variables:
  my-db:
    Fn::Invoke:
      Function: linode:getDatabasePostgresql
      Arguments:
        databaseId: 12345

Using getDatabasePostgresql

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getDatabasePostgresql(args: GetDatabasePostgresqlArgs, opts?: InvokeOptions): Promise<GetDatabasePostgresqlResult>
function getDatabasePostgresqlOutput(args: GetDatabasePostgresqlOutputArgs, opts?: InvokeOptions): Output<GetDatabasePostgresqlResult>
def get_database_postgresql(database_id: Optional[int] = None,
                            opts: Optional[InvokeOptions] = None) -> GetDatabasePostgresqlResult
def get_database_postgresql_output(database_id: Optional[pulumi.Input[int]] = None,
                            opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePostgresqlResult]
func LookupDatabasePostgresql(ctx *Context, args *LookupDatabasePostgresqlArgs, opts ...InvokeOption) (*LookupDatabasePostgresqlResult, error)
func LookupDatabasePostgresqlOutput(ctx *Context, args *LookupDatabasePostgresqlOutputArgs, opts ...InvokeOption) LookupDatabasePostgresqlResultOutput

> Note: This function is named LookupDatabasePostgresql in the Go SDK.

public static class GetDatabasePostgresql 
{
    public static Task<GetDatabasePostgresqlResult> InvokeAsync(GetDatabasePostgresqlArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabasePostgresqlResult> Invoke(GetDatabasePostgresqlInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabasePostgresqlResult> getDatabasePostgresql(GetDatabasePostgresqlArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: linode:index/getDatabasePostgresql:getDatabasePostgresql
  Arguments:
    # Arguments dictionary

The following arguments are supported:

DatabaseId int

The ID of the PostgreSQL database.

DatabaseId int

The ID of the PostgreSQL database.

databaseId Integer

The ID of the PostgreSQL database.

databaseId number

The ID of the PostgreSQL database.

database_id int

The ID of the PostgreSQL database.

databaseId Number

The ID of the PostgreSQL database.

getDatabasePostgresql Result

The following output properties are available:

AllowLists List<string>
CaCert string
ClusterSize int
Created string
DatabaseId int
Encrypted bool
Engine string
EngineId string
HostPrimary string
HostSecondary string
Id string

The provider-assigned unique ID for this managed resource.

Label string
Port int
Region string
ReplicationCommitType string
ReplicationType string
RootPassword string
RootUsername string
SslConnection bool
Status string
Type string
Updated string
Updates List<GetDatabasePostgresqlUpdate>
Version string
AllowLists []string
CaCert string
ClusterSize int
Created string
DatabaseId int
Encrypted bool
Engine string
EngineId string
HostPrimary string
HostSecondary string
Id string

The provider-assigned unique ID for this managed resource.

Label string
Port int
Region string
ReplicationCommitType string
ReplicationType string
RootPassword string
RootUsername string
SslConnection bool
Status string
Type string
Updated string
Updates []GetDatabasePostgresqlUpdate
Version string
allowLists List<String>
caCert String
clusterSize Integer
created String
databaseId Integer
encrypted Boolean
engine String
engineId String
hostPrimary String
hostSecondary String
id String

The provider-assigned unique ID for this managed resource.

label String
port Integer
region String
replicationCommitType String
replicationType String
rootPassword String
rootUsername String
sslConnection Boolean
status String
type String
updated String
updates List<GetDatabasePostgresqlUpdate>
version String
allowLists string[]
caCert string
clusterSize number
created string
databaseId number
encrypted boolean
engine string
engineId string
hostPrimary string
hostSecondary string
id string

The provider-assigned unique ID for this managed resource.

label string
port number
region string
replicationCommitType string
replicationType string
rootPassword string
rootUsername string
sslConnection boolean
status string
type string
updated string
updates GetDatabasePostgresqlUpdate[]
version string
allowLists List<String>
caCert String
clusterSize Number
created String
databaseId Number
encrypted Boolean
engine String
engineId String
hostPrimary String
hostSecondary String
id String

The provider-assigned unique ID for this managed resource.

label String
port Number
region String
replicationCommitType String
replicationType String
rootPassword String
rootUsername String
sslConnection Boolean
status String
type String
updated String
updates List<Property Map>
version String

Supporting Types

GetDatabasePostgresqlUpdate

dayOfWeek String
duration Integer
frequency String
hourOfDay Integer
weekOfMonth Integer
dayOfWeek string
duration number
frequency string
hourOfDay number
weekOfMonth number
dayOfWeek String
duration Number
frequency String
hourOfDay Number
weekOfMonth Number

Package Details

Repository
https://github.com/pulumi/pulumi-linode
License
Apache-2.0
Notes

This Pulumi package is based on the linode Terraform Provider.