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)

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

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:

getDatabasePostgresql Result

The following output properties are available:

Supporting Types

GetDatabasePostgresqlUpdate

Package Details

Repository

https://github.com/pulumi/pulumi-linode

License

Apache-2.0

Notes

This Pulumi package is based on the linode Terraform Provider.