Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi IDP Pulumi Cloud Packages Tutorials
  1. Packages
  2. Linode Provider
  3. API Docs
  4. DatabasePostgresqlV2
Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
pulumi/pulumi-linode

linode.DatabasePostgresqlV2

Explore with Pulumi AI

linode logo
Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
pulumi/pulumi-linode

    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 half an hour to provision.

    Example Usage

    Creating a simple PostgreSQL database that does not allow connections:

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

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

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresqlV2("foobar",
    label="mydatabase",
    engine_id="postgresql/16",
    region="us-mia",
    type="g6-nanode-1")

    package main

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

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

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

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

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresqlV2;
import com.pulumi.linode.DatabasePostgresqlV2Args;
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 DatabasePostgresqlV2("foobar", DatabasePostgresqlV2Args.builder()
            .label("mydatabase")
            .engineId("postgresql/16")
            .region("us-mia")
            .type("g6-nanode-1")
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabasePostgresqlV2
    properties:
      label: mydatabase
      engineId: postgresql/16
      region: us-mia
      type: g6-nanode-1

    Creating a simple PostgreSQL database that allows connections from all IPv4 addresses:

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

const foobar = new linode.DatabasePostgresqlV2("foobar", {
    label: "mydatabase",
    engineId: "postgresql/16",
    region: "us-mia",
    type: "g6-nanode-1",
    allowLists: ["0.0.0.0/0"],
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresqlV2("foobar",
    label="mydatabase",
    engine_id="postgresql/16",
    region="us-mia",
    type="g6-nanode-1",
    allow_lists=["0.0.0.0/0"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabasePostgresqlV2(ctx, "foobar", &linode.DatabasePostgresqlV2Args{
			Label:    pulumi.String("mydatabase"),
			EngineId: pulumi.String("postgresql/16"),
			Region:   pulumi.String("us-mia"),
			Type:     pulumi.String("g6-nanode-1"),
			AllowLists: pulumi.StringArray{
				pulumi.String("0.0.0.0/0"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabasePostgresqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "postgresql/16",
        Region = "us-mia",
        Type = "g6-nanode-1",
        AllowLists = new[]
        {
            "0.0.0.0/0",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresqlV2;
import com.pulumi.linode.DatabasePostgresqlV2Args;
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 DatabasePostgresqlV2("foobar", DatabasePostgresqlV2Args.builder()
            .label("mydatabase")
            .engineId("postgresql/16")
            .region("us-mia")
            .type("g6-nanode-1")
            .allowLists("0.0.0.0/0")
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabasePostgresqlV2
    properties:
      label: mydatabase
      engineId: postgresql/16
      region: us-mia
      type: g6-nanode-1
      allowLists:
        - 0.0.0.0/0

    Creating a complex PostgreSQL database:

    Example coming soon!

    Example coming soon!

    Example coming soon!

    Example coming soon!

    Example coming soon!

    resources:
  foobar:
    type: linode:DatabasePostgresqlV2
    properties:
      label: mydatabase
      engineId: postgresql/16
      region: us-mia
      type: g6-nanode-1
      allowLists:
        - 10.0.0.3/32
      clusterSize: 3
      updates:
        duration: 4
        frequency: weekly
        hour_of_day: 22
        day_of_week: 2

    Creating a PostgreSQL database with engine config fields specified:

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

const foobar = new linode.DatabasePostgresqlV2("foobar", {
    label: "mydatabase",
    engineId: "postgresql/16",
    region: "us-mia",
    type: "g6-nanode-1",
    engineConfigPgAutovacuumAnalyzeScaleFactor: 0.1,
    engineConfigPgAutovacuumAnalyzeThreshold: 50,
    engineConfigPgAutovacuumMaxWorkers: 3,
    engineConfigPgAutovacuumNaptime: 100,
    engineConfigPgAutovacuumVacuumCostDelay: 20,
    engineConfigPgAutovacuumVacuumCostLimit: 200,
    engineConfigPgAutovacuumVacuumScaleFactor: 0.2,
    engineConfigPgAutovacuumVacuumThreshold: 100,
    engineConfigPgBgwriterDelay: 1000,
    engineConfigPgBgwriterFlushAfter: 512,
    engineConfigPgBgwriterLruMaxpages: 100,
    engineConfigPgBgwriterLruMultiplier: 2,
    engineConfigPgDeadlockTimeout: 1000,
    engineConfigPgDefaultToastCompression: "pglz",
    engineConfigPgIdleInTransactionSessionTimeout: 60000,
    engineConfigPgJit: true,
    engineConfigPgMaxFilesPerProcess: 1000,
    engineConfigPgMaxLocksPerTransaction: 64,
    engineConfigPgMaxLogicalReplicationWorkers: 4,
    engineConfigPgMaxParallelWorkers: 8,
    engineConfigPgMaxParallelWorkersPerGather: 2,
    engineConfigPgMaxPredLocksPerTransaction: 128,
    engineConfigPgMaxReplicationSlots: 8,
    engineConfigPgMaxSlotWalKeepSize: 128,
    engineConfigPgMaxStackDepth: 2097152,
    engineConfigPgMaxStandbyArchiveDelay: 60000,
    engineConfigPgMaxStandbyStreamingDelay: 60000,
    engineConfigPgMaxWalSenders: 20,
    engineConfigPgMaxWorkerProcesses: 8,
    engineConfigPgPasswordEncryption: "scram-sha-256",
    engineConfigPgPgPartmanBgwInterval: 3600,
    engineConfigPgPgPartmanBgwRole: "myrolename",
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan: true,
    engineConfigPgPgStatMonitorPgsmMaxBuckets: 5,
    engineConfigPgPgStatStatementsTrack: "all",
    engineConfigPgTempFileLimit: 100,
    engineConfigPgTimezone: "Europe/Helsinki",
    engineConfigPgTrackActivityQuerySize: 2048,
    engineConfigPgTrackCommitTimestamp: "on",
    engineConfigPgTrackFunctions: "all",
    engineConfigPgTrackIoTiming: "on",
    engineConfigPgWalSenderTimeout: 60000,
    engineConfigPgWalWriterDelay: 200,
    engineConfigPgStatMonitorEnable: true,
    engineConfigPglookoutMaxFailoverReplicationTimeLag: 10000,
    engineConfigSharedBuffersPercentage: 25,
    engineConfigWorkMem: 400,
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresqlV2("foobar",
    label="mydatabase",
    engine_id="postgresql/16",
    region="us-mia",
    type="g6-nanode-1",
    engine_config_pg_autovacuum_analyze_scale_factor=0.1,
    engine_config_pg_autovacuum_analyze_threshold=50,
    engine_config_pg_autovacuum_max_workers=3,
    engine_config_pg_autovacuum_naptime=100,
    engine_config_pg_autovacuum_vacuum_cost_delay=20,
    engine_config_pg_autovacuum_vacuum_cost_limit=200,
    engine_config_pg_autovacuum_vacuum_scale_factor=0.2,
    engine_config_pg_autovacuum_vacuum_threshold=100,
    engine_config_pg_bgwriter_delay=1000,
    engine_config_pg_bgwriter_flush_after=512,
    engine_config_pg_bgwriter_lru_maxpages=100,
    engine_config_pg_bgwriter_lru_multiplier=2,
    engine_config_pg_deadlock_timeout=1000,
    engine_config_pg_default_toast_compression="pglz",
    engine_config_pg_idle_in_transaction_session_timeout=60000,
    engine_config_pg_jit=True,
    engine_config_pg_max_files_per_process=1000,
    engine_config_pg_max_locks_per_transaction=64,
    engine_config_pg_max_logical_replication_workers=4,
    engine_config_pg_max_parallel_workers=8,
    engine_config_pg_max_parallel_workers_per_gather=2,
    engine_config_pg_max_pred_locks_per_transaction=128,
    engine_config_pg_max_replication_slots=8,
    engine_config_pg_max_slot_wal_keep_size=128,
    engine_config_pg_max_stack_depth=2097152,
    engine_config_pg_max_standby_archive_delay=60000,
    engine_config_pg_max_standby_streaming_delay=60000,
    engine_config_pg_max_wal_senders=20,
    engine_config_pg_max_worker_processes=8,
    engine_config_pg_password_encryption="scram-sha-256",
    engine_config_pg_pg_partman_bgw_interval=3600,
    engine_config_pg_pg_partman_bgw_role="myrolename",
    engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan=True,
    engine_config_pg_pg_stat_monitor_pgsm_max_buckets=5,
    engine_config_pg_pg_stat_statements_track="all",
    engine_config_pg_temp_file_limit=100,
    engine_config_pg_timezone="Europe/Helsinki",
    engine_config_pg_track_activity_query_size=2048,
    engine_config_pg_track_commit_timestamp="on",
    engine_config_pg_track_functions="all",
    engine_config_pg_track_io_timing="on",
    engine_config_pg_wal_sender_timeout=60000,
    engine_config_pg_wal_writer_delay=200,
    engine_config_pg_stat_monitor_enable=True,
    engine_config_pglookout_max_failover_replication_time_lag=10000,
    engine_config_shared_buffers_percentage=25,
    engine_config_work_mem=400)

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabasePostgresqlV2(ctx, "foobar", &linode.DatabasePostgresqlV2Args{
			Label:    pulumi.String("mydatabase"),
			EngineId: pulumi.String("postgresql/16"),
			Region:   pulumi.String("us-mia"),
			Type:     pulumi.String("g6-nanode-1"),
			EngineConfigPgAutovacuumAnalyzeScaleFactor:         pulumi.Float64(0.1),
			EngineConfigPgAutovacuumAnalyzeThreshold:           pulumi.Int(50),
			EngineConfigPgAutovacuumMaxWorkers:                 pulumi.Int(3),
			EngineConfigPgAutovacuumNaptime:                    pulumi.Int(100),
			EngineConfigPgAutovacuumVacuumCostDelay:            pulumi.Int(20),
			EngineConfigPgAutovacuumVacuumCostLimit:            pulumi.Int(200),
			EngineConfigPgAutovacuumVacuumScaleFactor:          pulumi.Float64(0.2),
			EngineConfigPgAutovacuumVacuumThreshold:            pulumi.Int(100),
			EngineConfigPgBgwriterDelay:                        pulumi.Int(1000),
			EngineConfigPgBgwriterFlushAfter:                   pulumi.Int(512),
			EngineConfigPgBgwriterLruMaxpages:                  pulumi.Int(100),
			EngineConfigPgBgwriterLruMultiplier:                pulumi.Float64(2),
			EngineConfigPgDeadlockTimeout:                      pulumi.Int(1000),
			EngineConfigPgDefaultToastCompression:              pulumi.String("pglz"),
			EngineConfigPgIdleInTransactionSessionTimeout:      pulumi.Int(60000),
			EngineConfigPgJit:                                  pulumi.Bool(true),
			EngineConfigPgMaxFilesPerProcess:                   pulumi.Int(1000),
			EngineConfigPgMaxLocksPerTransaction:               pulumi.Int(64),
			EngineConfigPgMaxLogicalReplicationWorkers:         pulumi.Int(4),
			EngineConfigPgMaxParallelWorkers:                   pulumi.Int(8),
			EngineConfigPgMaxParallelWorkersPerGather:          pulumi.Int(2),
			EngineConfigPgMaxPredLocksPerTransaction:           pulumi.Int(128),
			EngineConfigPgMaxReplicationSlots:                  pulumi.Int(8),
			EngineConfigPgMaxSlotWalKeepSize:                   pulumi.Int(128),
			EngineConfigPgMaxStackDepth:                        pulumi.Int(2097152),
			EngineConfigPgMaxStandbyArchiveDelay:               pulumi.Int(60000),
			EngineConfigPgMaxStandbyStreamingDelay:             pulumi.Int(60000),
			EngineConfigPgMaxWalSenders:                        pulumi.Int(20),
			EngineConfigPgMaxWorkerProcesses:                   pulumi.Int(8),
			EngineConfigPgPasswordEncryption:                   pulumi.String("scram-sha-256"),
			EngineConfigPgPgPartmanBgwInterval:                 pulumi.Int(3600),
			EngineConfigPgPgPartmanBgwRole:                     pulumi.String("myrolename"),
			EngineConfigPgPgStatMonitorPgsmEnableQueryPlan:     pulumi.Bool(true),
			EngineConfigPgPgStatMonitorPgsmMaxBuckets:          pulumi.Int(5),
			EngineConfigPgPgStatStatementsTrack:                pulumi.String("all"),
			EngineConfigPgTempFileLimit:                        pulumi.Int(100),
			EngineConfigPgTimezone:                             pulumi.String("Europe/Helsinki"),
			EngineConfigPgTrackActivityQuerySize:               pulumi.Int(2048),
			EngineConfigPgTrackCommitTimestamp:                 pulumi.String("on"),
			EngineConfigPgTrackFunctions:                       pulumi.String("all"),
			EngineConfigPgTrackIoTiming:                        pulumi.String("on"),
			EngineConfigPgWalSenderTimeout:                     pulumi.Int(60000),
			EngineConfigPgWalWriterDelay:                       pulumi.Int(200),
			EngineConfigPgStatMonitorEnable:                    pulumi.Bool(true),
			EngineConfigPglookoutMaxFailoverReplicationTimeLag: pulumi.Int(10000),
			EngineConfigSharedBuffersPercentage:                pulumi.Float64(25),
			EngineConfigWorkMem:                                pulumi.Int(400),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabasePostgresqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "postgresql/16",
        Region = "us-mia",
        Type = "g6-nanode-1",
        EngineConfigPgAutovacuumAnalyzeScaleFactor = 0.1,
        EngineConfigPgAutovacuumAnalyzeThreshold = 50,
        EngineConfigPgAutovacuumMaxWorkers = 3,
        EngineConfigPgAutovacuumNaptime = 100,
        EngineConfigPgAutovacuumVacuumCostDelay = 20,
        EngineConfigPgAutovacuumVacuumCostLimit = 200,
        EngineConfigPgAutovacuumVacuumScaleFactor = 0.2,
        EngineConfigPgAutovacuumVacuumThreshold = 100,
        EngineConfigPgBgwriterDelay = 1000,
        EngineConfigPgBgwriterFlushAfter = 512,
        EngineConfigPgBgwriterLruMaxpages = 100,
        EngineConfigPgBgwriterLruMultiplier = 2,
        EngineConfigPgDeadlockTimeout = 1000,
        EngineConfigPgDefaultToastCompression = "pglz",
        EngineConfigPgIdleInTransactionSessionTimeout = 60000,
        EngineConfigPgJit = true,
        EngineConfigPgMaxFilesPerProcess = 1000,
        EngineConfigPgMaxLocksPerTransaction = 64,
        EngineConfigPgMaxLogicalReplicationWorkers = 4,
        EngineConfigPgMaxParallelWorkers = 8,
        EngineConfigPgMaxParallelWorkersPerGather = 2,
        EngineConfigPgMaxPredLocksPerTransaction = 128,
        EngineConfigPgMaxReplicationSlots = 8,
        EngineConfigPgMaxSlotWalKeepSize = 128,
        EngineConfigPgMaxStackDepth = 2097152,
        EngineConfigPgMaxStandbyArchiveDelay = 60000,
        EngineConfigPgMaxStandbyStreamingDelay = 60000,
        EngineConfigPgMaxWalSenders = 20,
        EngineConfigPgMaxWorkerProcesses = 8,
        EngineConfigPgPasswordEncryption = "scram-sha-256",
        EngineConfigPgPgPartmanBgwInterval = 3600,
        EngineConfigPgPgPartmanBgwRole = "myrolename",
        EngineConfigPgPgStatMonitorPgsmEnableQueryPlan = true,
        EngineConfigPgPgStatMonitorPgsmMaxBuckets = 5,
        EngineConfigPgPgStatStatementsTrack = "all",
        EngineConfigPgTempFileLimit = 100,
        EngineConfigPgTimezone = "Europe/Helsinki",
        EngineConfigPgTrackActivityQuerySize = 2048,
        EngineConfigPgTrackCommitTimestamp = "on",
        EngineConfigPgTrackFunctions = "all",
        EngineConfigPgTrackIoTiming = "on",
        EngineConfigPgWalSenderTimeout = 60000,
        EngineConfigPgWalWriterDelay = 200,
        EngineConfigPgStatMonitorEnable = true,
        EngineConfigPglookoutMaxFailoverReplicationTimeLag = 10000,
        EngineConfigSharedBuffersPercentage = 25,
        EngineConfigWorkMem = 400,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresqlV2;
import com.pulumi.linode.DatabasePostgresqlV2Args;
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 DatabasePostgresqlV2("foobar", DatabasePostgresqlV2Args.builder()
            .label("mydatabase")
            .engineId("postgresql/16")
            .region("us-mia")
            .type("g6-nanode-1")
            .engineConfigPgAutovacuumAnalyzeScaleFactor(0.1)
            .engineConfigPgAutovacuumAnalyzeThreshold(50)
            .engineConfigPgAutovacuumMaxWorkers(3)
            .engineConfigPgAutovacuumNaptime(100)
            .engineConfigPgAutovacuumVacuumCostDelay(20)
            .engineConfigPgAutovacuumVacuumCostLimit(200)
            .engineConfigPgAutovacuumVacuumScaleFactor(0.2)
            .engineConfigPgAutovacuumVacuumThreshold(100)
            .engineConfigPgBgwriterDelay(1000)
            .engineConfigPgBgwriterFlushAfter(512)
            .engineConfigPgBgwriterLruMaxpages(100)
            .engineConfigPgBgwriterLruMultiplier(2.0)
            .engineConfigPgDeadlockTimeout(1000)
            .engineConfigPgDefaultToastCompression("pglz")
            .engineConfigPgIdleInTransactionSessionTimeout(60000)
            .engineConfigPgJit(true)
            .engineConfigPgMaxFilesPerProcess(1000)
            .engineConfigPgMaxLocksPerTransaction(64)
            .engineConfigPgMaxLogicalReplicationWorkers(4)
            .engineConfigPgMaxParallelWorkers(8)
            .engineConfigPgMaxParallelWorkersPerGather(2)
            .engineConfigPgMaxPredLocksPerTransaction(128)
            .engineConfigPgMaxReplicationSlots(8)
            .engineConfigPgMaxSlotWalKeepSize(128)
            .engineConfigPgMaxStackDepth(2097152)
            .engineConfigPgMaxStandbyArchiveDelay(60000)
            .engineConfigPgMaxStandbyStreamingDelay(60000)
            .engineConfigPgMaxWalSenders(20)
            .engineConfigPgMaxWorkerProcesses(8)
            .engineConfigPgPasswordEncryption("scram-sha-256")
            .engineConfigPgPgPartmanBgwInterval(3600)
            .engineConfigPgPgPartmanBgwRole("myrolename")
            .engineConfigPgPgStatMonitorPgsmEnableQueryPlan(true)
            .engineConfigPgPgStatMonitorPgsmMaxBuckets(5)
            .engineConfigPgPgStatStatementsTrack("all")
            .engineConfigPgTempFileLimit(100)
            .engineConfigPgTimezone("Europe/Helsinki")
            .engineConfigPgTrackActivityQuerySize(2048)
            .engineConfigPgTrackCommitTimestamp("on")
            .engineConfigPgTrackFunctions("all")
            .engineConfigPgTrackIoTiming("on")
            .engineConfigPgWalSenderTimeout(60000)
            .engineConfigPgWalWriterDelay(200)
            .engineConfigPgStatMonitorEnable(true)
            .engineConfigPglookoutMaxFailoverReplicationTimeLag(10000)
            .engineConfigSharedBuffersPercentage(25.0)
            .engineConfigWorkMem(400)
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabasePostgresqlV2
    properties:
      label: mydatabase
      engineId: postgresql/16
      region: us-mia
      type: g6-nanode-1
      engineConfigPgAutovacuumAnalyzeScaleFactor: 0.1
      engineConfigPgAutovacuumAnalyzeThreshold: 50
      engineConfigPgAutovacuumMaxWorkers: 3
      engineConfigPgAutovacuumNaptime: 100
      engineConfigPgAutovacuumVacuumCostDelay: 20
      engineConfigPgAutovacuumVacuumCostLimit: 200
      engineConfigPgAutovacuumVacuumScaleFactor: 0.2
      engineConfigPgAutovacuumVacuumThreshold: 100
      engineConfigPgBgwriterDelay: 1000
      engineConfigPgBgwriterFlushAfter: 512
      engineConfigPgBgwriterLruMaxpages: 100
      engineConfigPgBgwriterLruMultiplier: 2
      engineConfigPgDeadlockTimeout: 1000
      engineConfigPgDefaultToastCompression: pglz
      engineConfigPgIdleInTransactionSessionTimeout: 60000
      engineConfigPgJit: true
      engineConfigPgMaxFilesPerProcess: 1000
      engineConfigPgMaxLocksPerTransaction: 64
      engineConfigPgMaxLogicalReplicationWorkers: 4
      engineConfigPgMaxParallelWorkers: 8
      engineConfigPgMaxParallelWorkersPerGather: 2
      engineConfigPgMaxPredLocksPerTransaction: 128
      engineConfigPgMaxReplicationSlots: 8
      engineConfigPgMaxSlotWalKeepSize: 128
      engineConfigPgMaxStackDepth: 2.097152e+06
      engineConfigPgMaxStandbyArchiveDelay: 60000
      engineConfigPgMaxStandbyStreamingDelay: 60000
      engineConfigPgMaxWalSenders: 20
      engineConfigPgMaxWorkerProcesses: 8
      engineConfigPgPasswordEncryption: scram-sha-256
      engineConfigPgPgPartmanBgwInterval: 3600
      engineConfigPgPgPartmanBgwRole: myrolename
      engineConfigPgPgStatMonitorPgsmEnableQueryPlan: true
      engineConfigPgPgStatMonitorPgsmMaxBuckets: 5
      engineConfigPgPgStatStatementsTrack: all
      engineConfigPgTempFileLimit: 100
      engineConfigPgTimezone: Europe/Helsinki
      engineConfigPgTrackActivityQuerySize: 2048
      engineConfigPgTrackCommitTimestamp: on
      engineConfigPgTrackFunctions: all
      engineConfigPgTrackIoTiming: on
      engineConfigPgWalSenderTimeout: 60000
      engineConfigPgWalWriterDelay: 200
      engineConfigPgStatMonitorEnable: true
      engineConfigPglookoutMaxFailoverReplicationTimeLag: 10000
      engineConfigSharedBuffersPercentage: 25
      engineConfigWorkMem: 400

    Creating a forked PostgreSQL database:

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

const foobar = new linode.DatabasePostgresqlV2("foobar", {
    label: "mydatabase",
    engineId: "postgresql/16",
    region: "us-mia",
    type: "g6-nanode-1",
    forkSource: 12345,
});

    import pulumi
import pulumi_linode as linode

foobar = linode.DatabasePostgresqlV2("foobar",
    label="mydatabase",
    engine_id="postgresql/16",
    region="us-mia",
    type="g6-nanode-1",
    fork_source=12345)

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.NewDatabasePostgresqlV2(ctx, "foobar", &linode.DatabasePostgresqlV2Args{
			Label:      pulumi.String("mydatabase"),
			EngineId:   pulumi.String("postgresql/16"),
			Region:     pulumi.String("us-mia"),
			Type:       pulumi.String("g6-nanode-1"),
			ForkSource: pulumi.Int(12345),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var foobar = new Linode.DatabasePostgresqlV2("foobar", new()
    {
        Label = "mydatabase",
        EngineId = "postgresql/16",
        Region = "us-mia",
        Type = "g6-nanode-1",
        ForkSource = 12345,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.DatabasePostgresqlV2;
import com.pulumi.linode.DatabasePostgresqlV2Args;
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 DatabasePostgresqlV2("foobar", DatabasePostgresqlV2Args.builder()
            .label("mydatabase")
            .engineId("postgresql/16")
            .region("us-mia")
            .type("g6-nanode-1")
            .forkSource(12345)
            .build());

    }
}

    resources:
  foobar:
    type: linode:DatabasePostgresqlV2
    properties:
      label: mydatabase
      engineId: postgresql/16
      region: us-mia
      type: g6-nanode-1
      forkSource: 12345

    NOTE: The name of the default database in the returned database cluster is defaultdb.

    pending_updates

    The following arguments are exposed by each entry in the pending_updates attribute:

    • deadline - The time when a mandatory update needs to be applied.

    • description - A description of the update.

    • planned_for - The date and time a maintenance update will be applied.

    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) The frequency at which maintenance occurs. (weekly)

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

    Create DatabasePostgresqlV2 Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new DatabasePostgresqlV2(name: string, args: DatabasePostgresqlV2Args, opts?: CustomResourceOptions);
    @overload
def DatabasePostgresqlV2(resource_name: str,
                         args: DatabasePostgresqlV2Args,
                         opts: Optional[ResourceOptions] = None)

@overload
def DatabasePostgresqlV2(resource_name: str,
                         opts: Optional[ResourceOptions] = None,
                         engine_id: Optional[str] = None,
                         label: Optional[str] = None,
                         region: Optional[str] = None,
                         type: Optional[str] = None,
                         allow_lists: Optional[Sequence[str]] = None,
                         cluster_size: Optional[int] = None,
                         engine_config_pg_autovacuum_analyze_scale_factor: Optional[float] = None,
                         engine_config_pg_autovacuum_analyze_threshold: Optional[int] = None,
                         engine_config_pg_autovacuum_max_workers: Optional[int] = None,
                         engine_config_pg_autovacuum_naptime: Optional[int] = None,
                         engine_config_pg_autovacuum_vacuum_cost_delay: Optional[int] = None,
                         engine_config_pg_autovacuum_vacuum_cost_limit: Optional[int] = None,
                         engine_config_pg_autovacuum_vacuum_scale_factor: Optional[float] = None,
                         engine_config_pg_autovacuum_vacuum_threshold: Optional[int] = None,
                         engine_config_pg_bgwriter_delay: Optional[int] = None,
                         engine_config_pg_bgwriter_flush_after: Optional[int] = None,
                         engine_config_pg_bgwriter_lru_maxpages: Optional[int] = None,
                         engine_config_pg_bgwriter_lru_multiplier: Optional[float] = None,
                         engine_config_pg_deadlock_timeout: Optional[int] = None,
                         engine_config_pg_default_toast_compression: Optional[str] = None,
                         engine_config_pg_idle_in_transaction_session_timeout: Optional[int] = None,
                         engine_config_pg_jit: Optional[bool] = None,
                         engine_config_pg_max_files_per_process: Optional[int] = None,
                         engine_config_pg_max_locks_per_transaction: Optional[int] = None,
                         engine_config_pg_max_logical_replication_workers: Optional[int] = None,
                         engine_config_pg_max_parallel_workers: Optional[int] = None,
                         engine_config_pg_max_parallel_workers_per_gather: Optional[int] = None,
                         engine_config_pg_max_pred_locks_per_transaction: Optional[int] = None,
                         engine_config_pg_max_replication_slots: Optional[int] = None,
                         engine_config_pg_max_slot_wal_keep_size: Optional[int] = None,
                         engine_config_pg_max_stack_depth: Optional[int] = None,
                         engine_config_pg_max_standby_archive_delay: Optional[int] = None,
                         engine_config_pg_max_standby_streaming_delay: Optional[int] = None,
                         engine_config_pg_max_wal_senders: Optional[int] = None,
                         engine_config_pg_max_worker_processes: Optional[int] = None,
                         engine_config_pg_password_encryption: Optional[str] = None,
                         engine_config_pg_pg_partman_bgw_interval: Optional[int] = None,
                         engine_config_pg_pg_partman_bgw_role: Optional[str] = None,
                         engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan: Optional[bool] = None,
                         engine_config_pg_pg_stat_monitor_pgsm_max_buckets: Optional[int] = None,
                         engine_config_pg_pg_stat_statements_track: Optional[str] = None,
                         engine_config_pg_stat_monitor_enable: Optional[bool] = None,
                         engine_config_pg_temp_file_limit: Optional[int] = None,
                         engine_config_pg_timezone: Optional[str] = None,
                         engine_config_pg_track_activity_query_size: Optional[int] = None,
                         engine_config_pg_track_commit_timestamp: Optional[str] = None,
                         engine_config_pg_track_functions: Optional[str] = None,
                         engine_config_pg_track_io_timing: Optional[str] = None,
                         engine_config_pg_wal_sender_timeout: Optional[int] = None,
                         engine_config_pg_wal_writer_delay: Optional[int] = None,
                         engine_config_pglookout_max_failover_replication_time_lag: Optional[int] = None,
                         engine_config_shared_buffers_percentage: Optional[float] = None,
                         engine_config_work_mem: Optional[int] = None,
                         fork_restore_time: Optional[str] = None,
                         fork_source: Optional[int] = None,
                         suspended: Optional[bool] = None,
                         timeouts: Optional[DatabasePostgresqlV2TimeoutsArgs] = None,
                         updates: Optional[DatabasePostgresqlV2UpdatesArgs] = None)
    func NewDatabasePostgresqlV2(ctx *Context, name string, args DatabasePostgresqlV2Args, opts ...ResourceOption) (*DatabasePostgresqlV2, error)
    public DatabasePostgresqlV2(string name, DatabasePostgresqlV2Args args, CustomResourceOptions? opts = null)
    public DatabasePostgresqlV2(String name, DatabasePostgresqlV2Args args)
public DatabasePostgresqlV2(String name, DatabasePostgresqlV2Args args, CustomResourceOptions options)

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

    Parameters

    name string
    The unique name of the resource.
    args DatabasePostgresqlV2Args
    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 DatabasePostgresqlV2Args
    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 DatabasePostgresqlV2Args
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabasePostgresqlV2Args
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabasePostgresqlV2Args
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var databasePostgresqlV2Resource = new Linode.DatabasePostgresqlV2("databasePostgresqlV2Resource", new()
{
    EngineId = "string",
    Label = "string",
    Region = "string",
    Type = "string",
    AllowLists = new[]
    {
        "string",
    },
    ClusterSize = 0,
    EngineConfigPgAutovacuumAnalyzeScaleFactor = 0,
    EngineConfigPgAutovacuumAnalyzeThreshold = 0,
    EngineConfigPgAutovacuumMaxWorkers = 0,
    EngineConfigPgAutovacuumNaptime = 0,
    EngineConfigPgAutovacuumVacuumCostDelay = 0,
    EngineConfigPgAutovacuumVacuumCostLimit = 0,
    EngineConfigPgAutovacuumVacuumScaleFactor = 0,
    EngineConfigPgAutovacuumVacuumThreshold = 0,
    EngineConfigPgBgwriterDelay = 0,
    EngineConfigPgBgwriterFlushAfter = 0,
    EngineConfigPgBgwriterLruMaxpages = 0,
    EngineConfigPgBgwriterLruMultiplier = 0,
    EngineConfigPgDeadlockTimeout = 0,
    EngineConfigPgDefaultToastCompression = "string",
    EngineConfigPgIdleInTransactionSessionTimeout = 0,
    EngineConfigPgJit = false,
    EngineConfigPgMaxFilesPerProcess = 0,
    EngineConfigPgMaxLocksPerTransaction = 0,
    EngineConfigPgMaxLogicalReplicationWorkers = 0,
    EngineConfigPgMaxParallelWorkers = 0,
    EngineConfigPgMaxParallelWorkersPerGather = 0,
    EngineConfigPgMaxPredLocksPerTransaction = 0,
    EngineConfigPgMaxReplicationSlots = 0,
    EngineConfigPgMaxSlotWalKeepSize = 0,
    EngineConfigPgMaxStackDepth = 0,
    EngineConfigPgMaxStandbyArchiveDelay = 0,
    EngineConfigPgMaxStandbyStreamingDelay = 0,
    EngineConfigPgMaxWalSenders = 0,
    EngineConfigPgMaxWorkerProcesses = 0,
    EngineConfigPgPasswordEncryption = "string",
    EngineConfigPgPgPartmanBgwInterval = 0,
    EngineConfigPgPgPartmanBgwRole = "string",
    EngineConfigPgPgStatMonitorPgsmEnableQueryPlan = false,
    EngineConfigPgPgStatMonitorPgsmMaxBuckets = 0,
    EngineConfigPgPgStatStatementsTrack = "string",
    EngineConfigPgStatMonitorEnable = false,
    EngineConfigPgTempFileLimit = 0,
    EngineConfigPgTimezone = "string",
    EngineConfigPgTrackActivityQuerySize = 0,
    EngineConfigPgTrackCommitTimestamp = "string",
    EngineConfigPgTrackFunctions = "string",
    EngineConfigPgTrackIoTiming = "string",
    EngineConfigPgWalSenderTimeout = 0,
    EngineConfigPgWalWriterDelay = 0,
    EngineConfigPglookoutMaxFailoverReplicationTimeLag = 0,
    EngineConfigSharedBuffersPercentage = 0,
    EngineConfigWorkMem = 0,
    ForkRestoreTime = "string",
    ForkSource = 0,
    Suspended = false,
    Timeouts = new Linode.Inputs.DatabasePostgresqlV2TimeoutsArgs
    {
        Create = "string",
        Delete = "string",
        Update = "string",
    },
    Updates = new Linode.Inputs.DatabasePostgresqlV2UpdatesArgs
    {
        DayOfWeek = 0,
        Duration = 0,
        Frequency = "string",
        HourOfDay = 0,
    },
});

    example, err := linode.NewDatabasePostgresqlV2(ctx, "databasePostgresqlV2Resource", &linode.DatabasePostgresqlV2Args{
	EngineId: pulumi.String("string"),
	Label:    pulumi.String("string"),
	Region:   pulumi.String("string"),
	Type:     pulumi.String("string"),
	AllowLists: pulumi.StringArray{
		pulumi.String("string"),
	},
	ClusterSize: pulumi.Int(0),
	EngineConfigPgAutovacuumAnalyzeScaleFactor:         pulumi.Float64(0),
	EngineConfigPgAutovacuumAnalyzeThreshold:           pulumi.Int(0),
	EngineConfigPgAutovacuumMaxWorkers:                 pulumi.Int(0),
	EngineConfigPgAutovacuumNaptime:                    pulumi.Int(0),
	EngineConfigPgAutovacuumVacuumCostDelay:            pulumi.Int(0),
	EngineConfigPgAutovacuumVacuumCostLimit:            pulumi.Int(0),
	EngineConfigPgAutovacuumVacuumScaleFactor:          pulumi.Float64(0),
	EngineConfigPgAutovacuumVacuumThreshold:            pulumi.Int(0),
	EngineConfigPgBgwriterDelay:                        pulumi.Int(0),
	EngineConfigPgBgwriterFlushAfter:                   pulumi.Int(0),
	EngineConfigPgBgwriterLruMaxpages:                  pulumi.Int(0),
	EngineConfigPgBgwriterLruMultiplier:                pulumi.Float64(0),
	EngineConfigPgDeadlockTimeout:                      pulumi.Int(0),
	EngineConfigPgDefaultToastCompression:              pulumi.String("string"),
	EngineConfigPgIdleInTransactionSessionTimeout:      pulumi.Int(0),
	EngineConfigPgJit:                                  pulumi.Bool(false),
	EngineConfigPgMaxFilesPerProcess:                   pulumi.Int(0),
	EngineConfigPgMaxLocksPerTransaction:               pulumi.Int(0),
	EngineConfigPgMaxLogicalReplicationWorkers:         pulumi.Int(0),
	EngineConfigPgMaxParallelWorkers:                   pulumi.Int(0),
	EngineConfigPgMaxParallelWorkersPerGather:          pulumi.Int(0),
	EngineConfigPgMaxPredLocksPerTransaction:           pulumi.Int(0),
	EngineConfigPgMaxReplicationSlots:                  pulumi.Int(0),
	EngineConfigPgMaxSlotWalKeepSize:                   pulumi.Int(0),
	EngineConfigPgMaxStackDepth:                        pulumi.Int(0),
	EngineConfigPgMaxStandbyArchiveDelay:               pulumi.Int(0),
	EngineConfigPgMaxStandbyStreamingDelay:             pulumi.Int(0),
	EngineConfigPgMaxWalSenders:                        pulumi.Int(0),
	EngineConfigPgMaxWorkerProcesses:                   pulumi.Int(0),
	EngineConfigPgPasswordEncryption:                   pulumi.String("string"),
	EngineConfigPgPgPartmanBgwInterval:                 pulumi.Int(0),
	EngineConfigPgPgPartmanBgwRole:                     pulumi.String("string"),
	EngineConfigPgPgStatMonitorPgsmEnableQueryPlan:     pulumi.Bool(false),
	EngineConfigPgPgStatMonitorPgsmMaxBuckets:          pulumi.Int(0),
	EngineConfigPgPgStatStatementsTrack:                pulumi.String("string"),
	EngineConfigPgStatMonitorEnable:                    pulumi.Bool(false),
	EngineConfigPgTempFileLimit:                        pulumi.Int(0),
	EngineConfigPgTimezone:                             pulumi.String("string"),
	EngineConfigPgTrackActivityQuerySize:               pulumi.Int(0),
	EngineConfigPgTrackCommitTimestamp:                 pulumi.String("string"),
	EngineConfigPgTrackFunctions:                       pulumi.String("string"),
	EngineConfigPgTrackIoTiming:                        pulumi.String("string"),
	EngineConfigPgWalSenderTimeout:                     pulumi.Int(0),
	EngineConfigPgWalWriterDelay:                       pulumi.Int(0),
	EngineConfigPglookoutMaxFailoverReplicationTimeLag: pulumi.Int(0),
	EngineConfigSharedBuffersPercentage:                pulumi.Float64(0),
	EngineConfigWorkMem:                                pulumi.Int(0),
	ForkRestoreTime:                                    pulumi.String("string"),
	ForkSource:                                         pulumi.Int(0),
	Suspended:                                          pulumi.Bool(false),
	Timeouts: &linode.DatabasePostgresqlV2TimeoutsArgs{
		Create: pulumi.String("string"),
		Delete: pulumi.String("string"),
		Update: pulumi.String("string"),
	},
	Updates: &linode.DatabasePostgresqlV2UpdatesArgs{
		DayOfWeek: pulumi.Int(0),
		Duration:  pulumi.Int(0),
		Frequency: pulumi.String("string"),
		HourOfDay: pulumi.Int(0),
	},
})

    var databasePostgresqlV2Resource = new DatabasePostgresqlV2("databasePostgresqlV2Resource", DatabasePostgresqlV2Args.builder()
    .engineId("string")
    .label("string")
    .region("string")
    .type("string")
    .allowLists("string")
    .clusterSize(0)
    .engineConfigPgAutovacuumAnalyzeScaleFactor(0.0)
    .engineConfigPgAutovacuumAnalyzeThreshold(0)
    .engineConfigPgAutovacuumMaxWorkers(0)
    .engineConfigPgAutovacuumNaptime(0)
    .engineConfigPgAutovacuumVacuumCostDelay(0)
    .engineConfigPgAutovacuumVacuumCostLimit(0)
    .engineConfigPgAutovacuumVacuumScaleFactor(0.0)
    .engineConfigPgAutovacuumVacuumThreshold(0)
    .engineConfigPgBgwriterDelay(0)
    .engineConfigPgBgwriterFlushAfter(0)
    .engineConfigPgBgwriterLruMaxpages(0)
    .engineConfigPgBgwriterLruMultiplier(0.0)
    .engineConfigPgDeadlockTimeout(0)
    .engineConfigPgDefaultToastCompression("string")
    .engineConfigPgIdleInTransactionSessionTimeout(0)
    .engineConfigPgJit(false)
    .engineConfigPgMaxFilesPerProcess(0)
    .engineConfigPgMaxLocksPerTransaction(0)
    .engineConfigPgMaxLogicalReplicationWorkers(0)
    .engineConfigPgMaxParallelWorkers(0)
    .engineConfigPgMaxParallelWorkersPerGather(0)
    .engineConfigPgMaxPredLocksPerTransaction(0)
    .engineConfigPgMaxReplicationSlots(0)
    .engineConfigPgMaxSlotWalKeepSize(0)
    .engineConfigPgMaxStackDepth(0)
    .engineConfigPgMaxStandbyArchiveDelay(0)
    .engineConfigPgMaxStandbyStreamingDelay(0)
    .engineConfigPgMaxWalSenders(0)
    .engineConfigPgMaxWorkerProcesses(0)
    .engineConfigPgPasswordEncryption("string")
    .engineConfigPgPgPartmanBgwInterval(0)
    .engineConfigPgPgPartmanBgwRole("string")
    .engineConfigPgPgStatMonitorPgsmEnableQueryPlan(false)
    .engineConfigPgPgStatMonitorPgsmMaxBuckets(0)
    .engineConfigPgPgStatStatementsTrack("string")
    .engineConfigPgStatMonitorEnable(false)
    .engineConfigPgTempFileLimit(0)
    .engineConfigPgTimezone("string")
    .engineConfigPgTrackActivityQuerySize(0)
    .engineConfigPgTrackCommitTimestamp("string")
    .engineConfigPgTrackFunctions("string")
    .engineConfigPgTrackIoTiming("string")
    .engineConfigPgWalSenderTimeout(0)
    .engineConfigPgWalWriterDelay(0)
    .engineConfigPglookoutMaxFailoverReplicationTimeLag(0)
    .engineConfigSharedBuffersPercentage(0.0)
    .engineConfigWorkMem(0)
    .forkRestoreTime("string")
    .forkSource(0)
    .suspended(false)
    .timeouts(DatabasePostgresqlV2TimeoutsArgs.builder()
        .create("string")
        .delete("string")
        .update("string")
        .build())
    .updates(DatabasePostgresqlV2UpdatesArgs.builder()
        .dayOfWeek(0)
        .duration(0)
        .frequency("string")
        .hourOfDay(0)
        .build())
    .build());

    database_postgresql_v2_resource = linode.DatabasePostgresqlV2("databasePostgresqlV2Resource",
    engine_id="string",
    label="string",
    region="string",
    type="string",
    allow_lists=["string"],
    cluster_size=0,
    engine_config_pg_autovacuum_analyze_scale_factor=0,
    engine_config_pg_autovacuum_analyze_threshold=0,
    engine_config_pg_autovacuum_max_workers=0,
    engine_config_pg_autovacuum_naptime=0,
    engine_config_pg_autovacuum_vacuum_cost_delay=0,
    engine_config_pg_autovacuum_vacuum_cost_limit=0,
    engine_config_pg_autovacuum_vacuum_scale_factor=0,
    engine_config_pg_autovacuum_vacuum_threshold=0,
    engine_config_pg_bgwriter_delay=0,
    engine_config_pg_bgwriter_flush_after=0,
    engine_config_pg_bgwriter_lru_maxpages=0,
    engine_config_pg_bgwriter_lru_multiplier=0,
    engine_config_pg_deadlock_timeout=0,
    engine_config_pg_default_toast_compression="string",
    engine_config_pg_idle_in_transaction_session_timeout=0,
    engine_config_pg_jit=False,
    engine_config_pg_max_files_per_process=0,
    engine_config_pg_max_locks_per_transaction=0,
    engine_config_pg_max_logical_replication_workers=0,
    engine_config_pg_max_parallel_workers=0,
    engine_config_pg_max_parallel_workers_per_gather=0,
    engine_config_pg_max_pred_locks_per_transaction=0,
    engine_config_pg_max_replication_slots=0,
    engine_config_pg_max_slot_wal_keep_size=0,
    engine_config_pg_max_stack_depth=0,
    engine_config_pg_max_standby_archive_delay=0,
    engine_config_pg_max_standby_streaming_delay=0,
    engine_config_pg_max_wal_senders=0,
    engine_config_pg_max_worker_processes=0,
    engine_config_pg_password_encryption="string",
    engine_config_pg_pg_partman_bgw_interval=0,
    engine_config_pg_pg_partman_bgw_role="string",
    engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan=False,
    engine_config_pg_pg_stat_monitor_pgsm_max_buckets=0,
    engine_config_pg_pg_stat_statements_track="string",
    engine_config_pg_stat_monitor_enable=False,
    engine_config_pg_temp_file_limit=0,
    engine_config_pg_timezone="string",
    engine_config_pg_track_activity_query_size=0,
    engine_config_pg_track_commit_timestamp="string",
    engine_config_pg_track_functions="string",
    engine_config_pg_track_io_timing="string",
    engine_config_pg_wal_sender_timeout=0,
    engine_config_pg_wal_writer_delay=0,
    engine_config_pglookout_max_failover_replication_time_lag=0,
    engine_config_shared_buffers_percentage=0,
    engine_config_work_mem=0,
    fork_restore_time="string",
    fork_source=0,
    suspended=False,
    timeouts={
        "create": "string",
        "delete": "string",
        "update": "string",
    },
    updates={
        "day_of_week": 0,
        "duration": 0,
        "frequency": "string",
        "hour_of_day": 0,
    })

    const databasePostgresqlV2Resource = new linode.DatabasePostgresqlV2("databasePostgresqlV2Resource", {
    engineId: "string",
    label: "string",
    region: "string",
    type: "string",
    allowLists: ["string"],
    clusterSize: 0,
    engineConfigPgAutovacuumAnalyzeScaleFactor: 0,
    engineConfigPgAutovacuumAnalyzeThreshold: 0,
    engineConfigPgAutovacuumMaxWorkers: 0,
    engineConfigPgAutovacuumNaptime: 0,
    engineConfigPgAutovacuumVacuumCostDelay: 0,
    engineConfigPgAutovacuumVacuumCostLimit: 0,
    engineConfigPgAutovacuumVacuumScaleFactor: 0,
    engineConfigPgAutovacuumVacuumThreshold: 0,
    engineConfigPgBgwriterDelay: 0,
    engineConfigPgBgwriterFlushAfter: 0,
    engineConfigPgBgwriterLruMaxpages: 0,
    engineConfigPgBgwriterLruMultiplier: 0,
    engineConfigPgDeadlockTimeout: 0,
    engineConfigPgDefaultToastCompression: "string",
    engineConfigPgIdleInTransactionSessionTimeout: 0,
    engineConfigPgJit: false,
    engineConfigPgMaxFilesPerProcess: 0,
    engineConfigPgMaxLocksPerTransaction: 0,
    engineConfigPgMaxLogicalReplicationWorkers: 0,
    engineConfigPgMaxParallelWorkers: 0,
    engineConfigPgMaxParallelWorkersPerGather: 0,
    engineConfigPgMaxPredLocksPerTransaction: 0,
    engineConfigPgMaxReplicationSlots: 0,
    engineConfigPgMaxSlotWalKeepSize: 0,
    engineConfigPgMaxStackDepth: 0,
    engineConfigPgMaxStandbyArchiveDelay: 0,
    engineConfigPgMaxStandbyStreamingDelay: 0,
    engineConfigPgMaxWalSenders: 0,
    engineConfigPgMaxWorkerProcesses: 0,
    engineConfigPgPasswordEncryption: "string",
    engineConfigPgPgPartmanBgwInterval: 0,
    engineConfigPgPgPartmanBgwRole: "string",
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan: false,
    engineConfigPgPgStatMonitorPgsmMaxBuckets: 0,
    engineConfigPgPgStatStatementsTrack: "string",
    engineConfigPgStatMonitorEnable: false,
    engineConfigPgTempFileLimit: 0,
    engineConfigPgTimezone: "string",
    engineConfigPgTrackActivityQuerySize: 0,
    engineConfigPgTrackCommitTimestamp: "string",
    engineConfigPgTrackFunctions: "string",
    engineConfigPgTrackIoTiming: "string",
    engineConfigPgWalSenderTimeout: 0,
    engineConfigPgWalWriterDelay: 0,
    engineConfigPglookoutMaxFailoverReplicationTimeLag: 0,
    engineConfigSharedBuffersPercentage: 0,
    engineConfigWorkMem: 0,
    forkRestoreTime: "string",
    forkSource: 0,
    suspended: false,
    timeouts: {
        create: "string",
        "delete": "string",
        update: "string",
    },
    updates: {
        dayOfWeek: 0,
        duration: 0,
        frequency: "string",
        hourOfDay: 0,
    },
});

    type: linode:DatabasePostgresqlV2
properties:
    allowLists:
        - string
    clusterSize: 0
    engineConfigPgAutovacuumAnalyzeScaleFactor: 0
    engineConfigPgAutovacuumAnalyzeThreshold: 0
    engineConfigPgAutovacuumMaxWorkers: 0
    engineConfigPgAutovacuumNaptime: 0
    engineConfigPgAutovacuumVacuumCostDelay: 0
    engineConfigPgAutovacuumVacuumCostLimit: 0
    engineConfigPgAutovacuumVacuumScaleFactor: 0
    engineConfigPgAutovacuumVacuumThreshold: 0
    engineConfigPgBgwriterDelay: 0
    engineConfigPgBgwriterFlushAfter: 0
    engineConfigPgBgwriterLruMaxpages: 0
    engineConfigPgBgwriterLruMultiplier: 0
    engineConfigPgDeadlockTimeout: 0
    engineConfigPgDefaultToastCompression: string
    engineConfigPgIdleInTransactionSessionTimeout: 0
    engineConfigPgJit: false
    engineConfigPgMaxFilesPerProcess: 0
    engineConfigPgMaxLocksPerTransaction: 0
    engineConfigPgMaxLogicalReplicationWorkers: 0
    engineConfigPgMaxParallelWorkers: 0
    engineConfigPgMaxParallelWorkersPerGather: 0
    engineConfigPgMaxPredLocksPerTransaction: 0
    engineConfigPgMaxReplicationSlots: 0
    engineConfigPgMaxSlotWalKeepSize: 0
    engineConfigPgMaxStackDepth: 0
    engineConfigPgMaxStandbyArchiveDelay: 0
    engineConfigPgMaxStandbyStreamingDelay: 0
    engineConfigPgMaxWalSenders: 0
    engineConfigPgMaxWorkerProcesses: 0
    engineConfigPgPasswordEncryption: string
    engineConfigPgPgPartmanBgwInterval: 0
    engineConfigPgPgPartmanBgwRole: string
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan: false
    engineConfigPgPgStatMonitorPgsmMaxBuckets: 0
    engineConfigPgPgStatStatementsTrack: string
    engineConfigPgStatMonitorEnable: false
    engineConfigPgTempFileLimit: 0
    engineConfigPgTimezone: string
    engineConfigPgTrackActivityQuerySize: 0
    engineConfigPgTrackCommitTimestamp: string
    engineConfigPgTrackFunctions: string
    engineConfigPgTrackIoTiming: string
    engineConfigPgWalSenderTimeout: 0
    engineConfigPgWalWriterDelay: 0
    engineConfigPglookoutMaxFailoverReplicationTimeLag: 0
    engineConfigSharedBuffersPercentage: 0
    engineConfigWorkMem: 0
    engineId: string
    forkRestoreTime: string
    forkSource: 0
    label: string
    region: string
    suspended: false
    timeouts:
        create: string
        delete: string
        update: string
    type: string
    updates:
        dayOfWeek: 0
        duration: 0
        frequency: string
        hourOfDay: 0

    DatabasePostgresqlV2 Resource Properties

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

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The DatabasePostgresqlV2 resource accepts the following input properties:

    EngineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    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.

    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)
    EngineConfigPgAutovacuumAnalyzeScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    EngineConfigPgAutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    EngineConfigPgAutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    EngineConfigPgAutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    EngineConfigPgAutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    EngineConfigPgAutovacuumVacuumScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    EngineConfigPgBgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    EngineConfigPgBgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    EngineConfigPgBgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    EngineConfigPgBgwriterLruMultiplier double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    EngineConfigPgDeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    EngineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    EngineConfigPgIdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    EngineConfigPgJit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    EngineConfigPgMaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    EngineConfigPgMaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    EngineConfigPgMaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    EngineConfigPgMaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    EngineConfigPgMaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    EngineConfigPgMaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    EngineConfigPgMaxReplicationSlots int
    PostgreSQL maximum replication slots.
    EngineConfigPgMaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    EngineConfigPgMaxStackDepth int
    Maximum depth of the stack in bytes.
    EngineConfigPgMaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    EngineConfigPgMaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    EngineConfigPgMaxWalSenders int
    PostgreSQL maximum WAL senders.
    EngineConfigPgMaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    EngineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    EngineConfigPgPgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    EngineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    EngineConfigPgPgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    EngineConfigPgPgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    EngineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    EngineConfigPgStatMonitorEnable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    EngineConfigPgTempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    EngineConfigPgTimezone string
    PostgreSQL service timezone.
    EngineConfigPgTrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    EngineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    EngineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    EngineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    EngineConfigPgWalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    EngineConfigPgWalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    EngineConfigPglookoutMaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    EngineConfigSharedBuffersPercentage double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    EngineConfigWorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabasePostgresqlV2Timeouts
    Updates DatabasePostgresqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    EngineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    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.

    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)
    EngineConfigPgAutovacuumAnalyzeScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    EngineConfigPgAutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    EngineConfigPgAutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    EngineConfigPgAutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    EngineConfigPgAutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    EngineConfigPgAutovacuumVacuumScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    EngineConfigPgBgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    EngineConfigPgBgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    EngineConfigPgBgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    EngineConfigPgBgwriterLruMultiplier float64
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    EngineConfigPgDeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    EngineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    EngineConfigPgIdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    EngineConfigPgJit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    EngineConfigPgMaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    EngineConfigPgMaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    EngineConfigPgMaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    EngineConfigPgMaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    EngineConfigPgMaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    EngineConfigPgMaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    EngineConfigPgMaxReplicationSlots int
    PostgreSQL maximum replication slots.
    EngineConfigPgMaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    EngineConfigPgMaxStackDepth int
    Maximum depth of the stack in bytes.
    EngineConfigPgMaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    EngineConfigPgMaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    EngineConfigPgMaxWalSenders int
    PostgreSQL maximum WAL senders.
    EngineConfigPgMaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    EngineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    EngineConfigPgPgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    EngineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    EngineConfigPgPgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    EngineConfigPgPgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    EngineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    EngineConfigPgStatMonitorEnable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    EngineConfigPgTempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    EngineConfigPgTimezone string
    PostgreSQL service timezone.
    EngineConfigPgTrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    EngineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    EngineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    EngineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    EngineConfigPgWalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    EngineConfigPgWalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    EngineConfigPglookoutMaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    EngineConfigSharedBuffersPercentage float64
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    EngineConfigWorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabasePostgresqlV2TimeoutsArgs
    Updates DatabasePostgresqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId String
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    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.

    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)
    engineConfigPgAutovacuumAnalyzeScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold Integer
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers Integer
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime Integer
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay Integer
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit Integer
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold Integer
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay Integer
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter Integer
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages Integer
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier Double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout Integer
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout Integer
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess Integer
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction Integer
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers Integer
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers Integer
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather Integer
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction Integer
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots Integer
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize Integer
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth Integer
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay Integer
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay Integer
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders Integer
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses Integer
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption String
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval Integer
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets Integer
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable Boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit Integer
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone String
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize Integer
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp String
    Record commit time of transactions.
    engineConfigPgTrackFunctions String
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming String
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout Integer
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay Integer
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag Integer
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage Double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem Integer
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Integer
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2Timeouts
    updates DatabasePostgresqlV2Updates
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    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.

    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)
    engineConfigPgAutovacuumAnalyzeScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout number
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess number
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction number
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers number
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction number
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots number
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth number
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay number
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay number
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders number
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses number
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval number
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets number
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone string
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    engineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag number
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    forkRestoreTime string
    The database timestamp from which it was restored.
    forkSource number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended boolean
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2Timeouts
    updates DatabasePostgresqlV2Updates
    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/16)
    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.

    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)
    engine_config_pg_autovacuum_analyze_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engine_config_pg_autovacuum_analyze_threshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engine_config_pg_autovacuum_max_workers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engine_config_pg_autovacuum_naptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engine_config_pg_autovacuum_vacuum_cost_delay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engine_config_pg_autovacuum_vacuum_cost_limit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engine_config_pg_autovacuum_vacuum_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engine_config_pg_autovacuum_vacuum_threshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engine_config_pg_bgwriter_delay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engine_config_pg_bgwriter_flush_after int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engine_config_pg_bgwriter_lru_maxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engine_config_pg_bgwriter_lru_multiplier float
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engine_config_pg_deadlock_timeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engine_config_pg_default_toast_compression str
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engine_config_pg_idle_in_transaction_session_timeout int
    Time out sessions with open transactions after this number of milliseconds.
    engine_config_pg_jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engine_config_pg_max_files_per_process int
    PostgreSQL maximum number of files that can be open per process.
    engine_config_pg_max_locks_per_transaction int
    PostgreSQL maximum locks per transaction.
    engine_config_pg_max_logical_replication_workers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engine_config_pg_max_parallel_workers int
    Sets the maximum number of workers that the system can support for parallel queries.
    engine_config_pg_max_parallel_workers_per_gather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engine_config_pg_max_pred_locks_per_transaction int
    PostgreSQL maximum predicate locks per transaction.
    engine_config_pg_max_replication_slots int
    PostgreSQL maximum replication slots.
    engine_config_pg_max_slot_wal_keep_size int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engine_config_pg_max_stack_depth int
    Maximum depth of the stack in bytes.
    engine_config_pg_max_standby_archive_delay int
    Max standby archive delay in milliseconds.
    engine_config_pg_max_standby_streaming_delay int
    Max standby streaming delay in milliseconds.
    engine_config_pg_max_wal_senders int
    PostgreSQL maximum WAL senders.
    engine_config_pg_max_worker_processes int
    Sets the maximum number of background processes that the system can support.
    engine_config_pg_password_encryption str
    Chooses the algorithm for encrypting passwords. (default md5)
    engine_config_pg_pg_partman_bgw_interval int
    Sets the time interval to run pg_partman's scheduled tasks.
    engine_config_pg_pg_partman_bgw_role str
    Controls which role to use for pg_partman's scheduled background tasks.
    engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan bool
    Enables or disables query plan monitoring.
    engine_config_pg_pg_stat_monitor_pgsm_max_buckets int
    Sets the maximum number of buckets.
    engine_config_pg_pg_stat_statements_track str
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engine_config_pg_stat_monitor_enable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engine_config_pg_temp_file_limit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engine_config_pg_timezone str
    PostgreSQL service timezone.
    engine_config_pg_track_activity_query_size int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engine_config_pg_track_commit_timestamp str
    Record commit time of transactions.
    engine_config_pg_track_functions str
    Enables tracking of function call counts and time used.
    engine_config_pg_track_io_timing str
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engine_config_pg_wal_sender_timeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engine_config_pg_wal_writer_delay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engine_config_pglookout_max_failover_replication_time_lag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engine_config_shared_buffers_percentage float
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engine_config_work_mem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    fork_restore_time str
    The database timestamp from which it was restored.
    fork_source int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended bool
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2TimeoutsArgs
    updates DatabasePostgresqlV2UpdatesArgs
    Configuration settings for automated patch update maintenance for the Managed Database.
    engineId String
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    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.

    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)
    engineConfigPgAutovacuumAnalyzeScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold Number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers Number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime Number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay Number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit Number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold Number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay Number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter Number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages Number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier Number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout Number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout Number
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess Number
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction Number
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers Number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers Number
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather Number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction Number
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots Number
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize Number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth Number
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay Number
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay Number
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders Number
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses Number
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption String
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval Number
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets Number
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable Boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit Number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone String
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize Number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp String
    Record commit time of transactions.
    engineConfigPgTrackFunctions String
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming String
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout Number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay Number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag Number
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage Number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem Number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts Property Map
    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 DatabasePostgresqlV2 resource produces the following output properties:

    CaCert string
    The base64-encoded SSL CA certificate for the Managed Database.
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. postgresql)
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Id string
    The provider-assigned unique ID for this managed resource.
    Members Dictionary<string, string>
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates List<DatabasePostgresqlV2PendingUpdate>
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    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.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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.
    Created string
    When this Managed Database was created.
    Encrypted bool
    Whether the Managed Databases is encrypted.
    Engine string
    The Managed Database engine. (e.g. postgresql)
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Id string
    The provider-assigned unique ID for this managed resource.
    Members map[string]string
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates []DatabasePostgresqlV2PendingUpdate
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    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.
    SslConnection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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.
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. postgresql)
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    id String
    The provider-assigned unique ID for this managed resource.
    members Map<String,String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<DatabasePostgresqlV2PendingUpdate>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    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.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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.
    created string
    When this Managed Database was created.
    encrypted boolean
    Whether the Managed Databases is encrypted.
    engine string
    The Managed Database engine. (e.g. postgresql)
    hostPrimary string
    The primary host for the Managed Database.
    hostSecondary string
    The secondary/private host for the managed database.
    id string
    The provider-assigned unique ID for this managed resource.
    members {[key: string]: string}
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime string
    The oldest time to which a database can be restored.
    pendingUpdates DatabasePostgresqlV2PendingUpdate[]
    A set of pending updates.
    platform string
    The back-end platform for relational databases used by the service.
    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.
    sslConnection boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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.
    created str
    When this Managed Database was created.
    encrypted bool
    Whether the Managed Databases is encrypted.
    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 host for the managed database.
    id str
    The provider-assigned unique ID for this managed resource.
    members Mapping[str, str]
    A mapping between IP addresses and strings designating them as primary or failover.
    oldest_restore_time str
    The oldest time to which a database can be restored.
    pending_updates Sequence[DatabasePostgresqlV2PendingUpdate]
    A set of pending updates.
    platform str
    The back-end platform for relational databases used by the service.
    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.
    ssl_connection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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.
    created String
    When this Managed Database was created.
    encrypted Boolean
    Whether the Managed Databases is encrypted.
    engine String
    The Managed Database engine. (e.g. postgresql)
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    id String
    The provider-assigned unique ID for this managed resource.
    members Map<String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<Property Map>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    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.
    sslConnection Boolean
    Whether to require SSL credentials to establish a connection to the Managed Database.
    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 DatabasePostgresqlV2 Resource

    Get an existing DatabasePostgresqlV2 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?: DatabasePostgresqlV2State, opts?: CustomResourceOptions): DatabasePostgresqlV2
    @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_config_pg_autovacuum_analyze_scale_factor: Optional[float] = None,
        engine_config_pg_autovacuum_analyze_threshold: Optional[int] = None,
        engine_config_pg_autovacuum_max_workers: Optional[int] = None,
        engine_config_pg_autovacuum_naptime: Optional[int] = None,
        engine_config_pg_autovacuum_vacuum_cost_delay: Optional[int] = None,
        engine_config_pg_autovacuum_vacuum_cost_limit: Optional[int] = None,
        engine_config_pg_autovacuum_vacuum_scale_factor: Optional[float] = None,
        engine_config_pg_autovacuum_vacuum_threshold: Optional[int] = None,
        engine_config_pg_bgwriter_delay: Optional[int] = None,
        engine_config_pg_bgwriter_flush_after: Optional[int] = None,
        engine_config_pg_bgwriter_lru_maxpages: Optional[int] = None,
        engine_config_pg_bgwriter_lru_multiplier: Optional[float] = None,
        engine_config_pg_deadlock_timeout: Optional[int] = None,
        engine_config_pg_default_toast_compression: Optional[str] = None,
        engine_config_pg_idle_in_transaction_session_timeout: Optional[int] = None,
        engine_config_pg_jit: Optional[bool] = None,
        engine_config_pg_max_files_per_process: Optional[int] = None,
        engine_config_pg_max_locks_per_transaction: Optional[int] = None,
        engine_config_pg_max_logical_replication_workers: Optional[int] = None,
        engine_config_pg_max_parallel_workers: Optional[int] = None,
        engine_config_pg_max_parallel_workers_per_gather: Optional[int] = None,
        engine_config_pg_max_pred_locks_per_transaction: Optional[int] = None,
        engine_config_pg_max_replication_slots: Optional[int] = None,
        engine_config_pg_max_slot_wal_keep_size: Optional[int] = None,
        engine_config_pg_max_stack_depth: Optional[int] = None,
        engine_config_pg_max_standby_archive_delay: Optional[int] = None,
        engine_config_pg_max_standby_streaming_delay: Optional[int] = None,
        engine_config_pg_max_wal_senders: Optional[int] = None,
        engine_config_pg_max_worker_processes: Optional[int] = None,
        engine_config_pg_password_encryption: Optional[str] = None,
        engine_config_pg_pg_partman_bgw_interval: Optional[int] = None,
        engine_config_pg_pg_partman_bgw_role: Optional[str] = None,
        engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan: Optional[bool] = None,
        engine_config_pg_pg_stat_monitor_pgsm_max_buckets: Optional[int] = None,
        engine_config_pg_pg_stat_statements_track: Optional[str] = None,
        engine_config_pg_stat_monitor_enable: Optional[bool] = None,
        engine_config_pg_temp_file_limit: Optional[int] = None,
        engine_config_pg_timezone: Optional[str] = None,
        engine_config_pg_track_activity_query_size: Optional[int] = None,
        engine_config_pg_track_commit_timestamp: Optional[str] = None,
        engine_config_pg_track_functions: Optional[str] = None,
        engine_config_pg_track_io_timing: Optional[str] = None,
        engine_config_pg_wal_sender_timeout: Optional[int] = None,
        engine_config_pg_wal_writer_delay: Optional[int] = None,
        engine_config_pglookout_max_failover_replication_time_lag: Optional[int] = None,
        engine_config_shared_buffers_percentage: Optional[float] = None,
        engine_config_work_mem: Optional[int] = None,
        engine_id: Optional[str] = None,
        fork_restore_time: Optional[str] = None,
        fork_source: Optional[int] = None,
        host_primary: Optional[str] = None,
        host_secondary: Optional[str] = None,
        label: Optional[str] = None,
        members: Optional[Mapping[str, str]] = None,
        oldest_restore_time: Optional[str] = None,
        pending_updates: Optional[Sequence[DatabasePostgresqlV2PendingUpdateArgs]] = None,
        platform: Optional[str] = None,
        port: Optional[int] = None,
        region: Optional[str] = None,
        root_password: Optional[str] = None,
        root_username: Optional[str] = None,
        ssl_connection: Optional[bool] = None,
        status: Optional[str] = None,
        suspended: Optional[bool] = None,
        timeouts: Optional[DatabasePostgresqlV2TimeoutsArgs] = None,
        type: Optional[str] = None,
        updated: Optional[str] = None,
        updates: Optional[DatabasePostgresqlV2UpdatesArgs] = None,
        version: Optional[str] = None) -> DatabasePostgresqlV2
    func GetDatabasePostgresqlV2(ctx *Context, name string, id IDInput, state *DatabasePostgresqlV2State, opts ...ResourceOption) (*DatabasePostgresqlV2, error)
    public static DatabasePostgresqlV2 Get(string name, Input<string> id, DatabasePostgresqlV2State? state, CustomResourceOptions? opts = null)
    public static DatabasePostgresqlV2 get(String name, Output<String> id, DatabasePostgresqlV2State state, CustomResourceOptions options)
    resources:  _:    type: linode:DatabasePostgresqlV2    get:      id: ${id}
    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.
    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.
    Engine string
    The Managed Database engine. (e.g. postgresql)
    EngineConfigPgAutovacuumAnalyzeScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    EngineConfigPgAutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    EngineConfigPgAutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    EngineConfigPgAutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    EngineConfigPgAutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    EngineConfigPgAutovacuumVacuumScaleFactor double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    EngineConfigPgBgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    EngineConfigPgBgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    EngineConfigPgBgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    EngineConfigPgBgwriterLruMultiplier double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    EngineConfigPgDeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    EngineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    EngineConfigPgIdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    EngineConfigPgJit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    EngineConfigPgMaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    EngineConfigPgMaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    EngineConfigPgMaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    EngineConfigPgMaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    EngineConfigPgMaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    EngineConfigPgMaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    EngineConfigPgMaxReplicationSlots int
    PostgreSQL maximum replication slots.
    EngineConfigPgMaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    EngineConfigPgMaxStackDepth int
    Maximum depth of the stack in bytes.
    EngineConfigPgMaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    EngineConfigPgMaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    EngineConfigPgMaxWalSenders int
    PostgreSQL maximum WAL senders.
    EngineConfigPgMaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    EngineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    EngineConfigPgPgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    EngineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    EngineConfigPgPgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    EngineConfigPgPgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    EngineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    EngineConfigPgStatMonitorEnable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    EngineConfigPgTempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    EngineConfigPgTimezone string
    PostgreSQL service timezone.
    EngineConfigPgTrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    EngineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    EngineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    EngineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    EngineConfigPgWalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    EngineConfigPgWalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    EngineConfigPglookoutMaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    EngineConfigSharedBuffersPercentage double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    EngineConfigWorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    EngineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Label string
    A unique, user-defined string referring to the Managed Database.
    Members Dictionary<string, string>
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates List<DatabasePostgresqlV2PendingUpdate>
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    Region string
    The region to use for the Managed Database.
    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.
    Status string
    The operating status of the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabasePostgresqlV2Timeouts
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    Updated string
    When this Managed Database was last updated.
    Updates DatabasePostgresqlV2Updates
    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.
    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.
    Engine string
    The Managed Database engine. (e.g. postgresql)
    EngineConfigPgAutovacuumAnalyzeScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumAnalyzeThreshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    EngineConfigPgAutovacuumMaxWorkers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    EngineConfigPgAutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    EngineConfigPgAutovacuumVacuumCostDelay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    EngineConfigPgAutovacuumVacuumCostLimit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    EngineConfigPgAutovacuumVacuumScaleFactor float64
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    EngineConfigPgAutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    EngineConfigPgBgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    EngineConfigPgBgwriterFlushAfter int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    EngineConfigPgBgwriterLruMaxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    EngineConfigPgBgwriterLruMultiplier float64
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    EngineConfigPgDeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    EngineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    EngineConfigPgIdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    EngineConfigPgJit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    EngineConfigPgMaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    EngineConfigPgMaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    EngineConfigPgMaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    EngineConfigPgMaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    EngineConfigPgMaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    EngineConfigPgMaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    EngineConfigPgMaxReplicationSlots int
    PostgreSQL maximum replication slots.
    EngineConfigPgMaxSlotWalKeepSize int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    EngineConfigPgMaxStackDepth int
    Maximum depth of the stack in bytes.
    EngineConfigPgMaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    EngineConfigPgMaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    EngineConfigPgMaxWalSenders int
    PostgreSQL maximum WAL senders.
    EngineConfigPgMaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    EngineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    EngineConfigPgPgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    EngineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    EngineConfigPgPgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    EngineConfigPgPgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    EngineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    EngineConfigPgStatMonitorEnable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    EngineConfigPgTempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    EngineConfigPgTimezone string
    PostgreSQL service timezone.
    EngineConfigPgTrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    EngineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    EngineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    EngineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    EngineConfigPgWalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    EngineConfigPgWalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    EngineConfigPglookoutMaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    EngineConfigSharedBuffersPercentage float64
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    EngineConfigWorkMem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    EngineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    ForkRestoreTime string
    The database timestamp from which it was restored.
    ForkSource int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    HostPrimary string
    The primary host for the Managed Database.
    HostSecondary string
    The secondary/private host for the managed database.
    Label string
    A unique, user-defined string referring to the Managed Database.
    Members map[string]string
    A mapping between IP addresses and strings designating them as primary or failover.
    OldestRestoreTime string
    The oldest time to which a database can be restored.
    PendingUpdates []DatabasePostgresqlV2PendingUpdateArgs
    A set of pending updates.
    Platform string
    The back-end platform for relational databases used by the service.
    Port int
    The access port for this Managed Database.
    Region string
    The region to use for the Managed Database.
    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.
    Status string
    The operating status of the Managed Database.
    Suspended bool
    Whether this Managed Database should be suspended.
    Timeouts DatabasePostgresqlV2TimeoutsArgs
    Type string
    The Linode Instance type used for the nodes of the Managed Database.

    Updated string
    When this Managed Database was last updated.
    Updates DatabasePostgresqlV2UpdatesArgs
    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.
    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.
    engine String
    The Managed Database engine. (e.g. postgresql)
    engineConfigPgAutovacuumAnalyzeScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold Integer
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers Integer
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime Integer
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay Integer
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit Integer
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor Double
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold Integer
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay Integer
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter Integer
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages Integer
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier Double
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout Integer
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout Integer
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess Integer
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction Integer
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers Integer
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers Integer
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather Integer
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction Integer
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots Integer
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize Integer
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth Integer
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay Integer
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay Integer
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders Integer
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses Integer
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption String
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval Integer
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets Integer
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable Boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit Integer
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone String
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize Integer
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp String
    Record commit time of transactions.
    engineConfigPgTrackFunctions String
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming String
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout Integer
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay Integer
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag Integer
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage Double
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem Integer
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    engineId String
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Integer
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    label String
    A unique, user-defined string referring to the Managed Database.
    members Map<String,String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<DatabasePostgresqlV2PendingUpdate>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Integer
    The access port for this Managed Database.
    region String
    The region to use for the Managed Database.
    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.
    status String
    The operating status of the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2Timeouts
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    updated String
    When this Managed Database was last updated.
    updates DatabasePostgresqlV2Updates
    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.
    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.
    engine string
    The Managed Database engine. (e.g. postgresql)
    engineConfigPgAutovacuumAnalyzeScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout number
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess number
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction number
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers number
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction number
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots number
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth number
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay number
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay number
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders number
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses number
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption string
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval number
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets number
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack string
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone string
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp string
    Record commit time of transactions.
    engineConfigPgTrackFunctions string
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming string
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag number
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    engineId string
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    forkRestoreTime string
    The database timestamp from which it was restored.
    forkSource number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary string
    The primary host for the Managed Database.
    hostSecondary string
    The secondary/private host for the managed database.
    label string
    A unique, user-defined string referring to the Managed Database.
    members {[key: string]: string}
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime string
    The oldest time to which a database can be restored.
    pendingUpdates DatabasePostgresqlV2PendingUpdate[]
    A set of pending updates.
    platform string
    The back-end platform for relational databases used by the service.
    port number
    The access port for this Managed Database.
    region string
    The region to use for the Managed Database.
    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.
    status string
    The operating status of the Managed Database.
    suspended boolean
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2Timeouts
    type string
    The Linode Instance type used for the nodes of the Managed Database.

    updated string
    When this Managed Database was last updated.
    updates DatabasePostgresqlV2Updates
    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.
    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.
    engine str
    The Managed Database engine. (e.g. postgresql)
    engine_config_pg_autovacuum_analyze_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engine_config_pg_autovacuum_analyze_threshold int
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engine_config_pg_autovacuum_max_workers int
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engine_config_pg_autovacuum_naptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engine_config_pg_autovacuum_vacuum_cost_delay int
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engine_config_pg_autovacuum_vacuum_cost_limit int
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engine_config_pg_autovacuum_vacuum_scale_factor float
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engine_config_pg_autovacuum_vacuum_threshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engine_config_pg_bgwriter_delay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engine_config_pg_bgwriter_flush_after int
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engine_config_pg_bgwriter_lru_maxpages int
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engine_config_pg_bgwriter_lru_multiplier float
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engine_config_pg_deadlock_timeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engine_config_pg_default_toast_compression str
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engine_config_pg_idle_in_transaction_session_timeout int
    Time out sessions with open transactions after this number of milliseconds.
    engine_config_pg_jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engine_config_pg_max_files_per_process int
    PostgreSQL maximum number of files that can be open per process.
    engine_config_pg_max_locks_per_transaction int
    PostgreSQL maximum locks per transaction.
    engine_config_pg_max_logical_replication_workers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engine_config_pg_max_parallel_workers int
    Sets the maximum number of workers that the system can support for parallel queries.
    engine_config_pg_max_parallel_workers_per_gather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engine_config_pg_max_pred_locks_per_transaction int
    PostgreSQL maximum predicate locks per transaction.
    engine_config_pg_max_replication_slots int
    PostgreSQL maximum replication slots.
    engine_config_pg_max_slot_wal_keep_size int
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engine_config_pg_max_stack_depth int
    Maximum depth of the stack in bytes.
    engine_config_pg_max_standby_archive_delay int
    Max standby archive delay in milliseconds.
    engine_config_pg_max_standby_streaming_delay int
    Max standby streaming delay in milliseconds.
    engine_config_pg_max_wal_senders int
    PostgreSQL maximum WAL senders.
    engine_config_pg_max_worker_processes int
    Sets the maximum number of background processes that the system can support.
    engine_config_pg_password_encryption str
    Chooses the algorithm for encrypting passwords. (default md5)
    engine_config_pg_pg_partman_bgw_interval int
    Sets the time interval to run pg_partman's scheduled tasks.
    engine_config_pg_pg_partman_bgw_role str
    Controls which role to use for pg_partman's scheduled background tasks.
    engine_config_pg_pg_stat_monitor_pgsm_enable_query_plan bool
    Enables or disables query plan monitoring.
    engine_config_pg_pg_stat_monitor_pgsm_max_buckets int
    Sets the maximum number of buckets.
    engine_config_pg_pg_stat_statements_track str
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engine_config_pg_stat_monitor_enable bool
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engine_config_pg_temp_file_limit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engine_config_pg_timezone str
    PostgreSQL service timezone.
    engine_config_pg_track_activity_query_size int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engine_config_pg_track_commit_timestamp str
    Record commit time of transactions.
    engine_config_pg_track_functions str
    Enables tracking of function call counts and time used.
    engine_config_pg_track_io_timing str
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engine_config_pg_wal_sender_timeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engine_config_pg_wal_writer_delay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engine_config_pglookout_max_failover_replication_time_lag int
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engine_config_shared_buffers_percentage float
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engine_config_work_mem int
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    engine_id str
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    fork_restore_time str
    The database timestamp from which it was restored.
    fork_source int
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    host_primary str
    The primary host for the Managed Database.
    host_secondary str
    The secondary/private host for the managed database.
    label str
    A unique, user-defined string referring to the Managed Database.
    members Mapping[str, str]
    A mapping between IP addresses and strings designating them as primary or failover.
    oldest_restore_time str
    The oldest time to which a database can be restored.
    pending_updates Sequence[DatabasePostgresqlV2PendingUpdateArgs]
    A set of pending updates.
    platform str
    The back-end platform for relational databases used by the service.
    port int
    The access port for this Managed Database.
    region str
    The region to use for the 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.
    ssl_connection bool
    Whether to require SSL credentials to establish a connection to the Managed Database.
    status str
    The operating status of the Managed Database.
    suspended bool
    Whether this Managed Database should be suspended.
    timeouts DatabasePostgresqlV2TimeoutsArgs
    type str
    The Linode Instance type used for the nodes of the Managed Database.

    updated str
    When this Managed Database was last updated.
    updates DatabasePostgresqlV2UpdatesArgs
    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.
    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.
    engine String
    The Managed Database engine. (e.g. postgresql)
    engineConfigPgAutovacuumAnalyzeScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumAnalyzeThreshold Number
    Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
    engineConfigPgAutovacuumMaxWorkers Number
    Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.
    engineConfigPgAutovacuumNaptime Number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute
    engineConfigPgAutovacuumVacuumCostDelay Number
    Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds
    engineConfigPgAutovacuumVacuumCostLimit Number
    Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.
    engineConfigPgAutovacuumVacuumScaleFactor Number
    Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)
    engineConfigPgAutovacuumVacuumThreshold Number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    engineConfigPgBgwriterDelay Number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    engineConfigPgBgwriterFlushAfter Number
    Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
    engineConfigPgBgwriterLruMaxpages Number
    In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.
    engineConfigPgBgwriterLruMultiplier Number
    The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.
    engineConfigPgDeadlockTimeout Number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    engineConfigPgDefaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    engineConfigPgIdleInTransactionSessionTimeout Number
    Time out sessions with open transactions after this number of milliseconds.
    engineConfigPgJit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    engineConfigPgMaxFilesPerProcess Number
    PostgreSQL maximum number of files that can be open per process.
    engineConfigPgMaxLocksPerTransaction Number
    PostgreSQL maximum locks per transaction.
    engineConfigPgMaxLogicalReplicationWorkers Number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    engineConfigPgMaxParallelWorkers Number
    Sets the maximum number of workers that the system can support for parallel queries.
    engineConfigPgMaxParallelWorkersPerGather Number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    engineConfigPgMaxPredLocksPerTransaction Number
    PostgreSQL maximum predicate locks per transaction.
    engineConfigPgMaxReplicationSlots Number
    PostgreSQL maximum replication slots.
    engineConfigPgMaxSlotWalKeepSize Number
    PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.
    engineConfigPgMaxStackDepth Number
    Maximum depth of the stack in bytes.
    engineConfigPgMaxStandbyArchiveDelay Number
    Max standby archive delay in milliseconds.
    engineConfigPgMaxStandbyStreamingDelay Number
    Max standby streaming delay in milliseconds.
    engineConfigPgMaxWalSenders Number
    PostgreSQL maximum WAL senders.
    engineConfigPgMaxWorkerProcesses Number
    Sets the maximum number of background processes that the system can support.
    engineConfigPgPasswordEncryption String
    Chooses the algorithm for encrypting passwords. (default md5)
    engineConfigPgPgPartmanBgwInterval Number
    Sets the time interval to run pg_partman's scheduled tasks.
    engineConfigPgPgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    engineConfigPgPgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    engineConfigPgPgStatMonitorPgsmMaxBuckets Number
    Sets the maximum number of buckets.
    engineConfigPgPgStatStatementsTrack String
    Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.
    engineConfigPgStatMonitorEnable Boolean
    Enable the pg_stat_monitor extension. Enabling this extension will cause the cluster to be restarted. When this extension is enabled, pg_stat_statements results for utility commands are unreliable. (default false)
    engineConfigPgTempFileLimit Number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    engineConfigPgTimezone String
    PostgreSQL service timezone.
    engineConfigPgTrackActivityQuerySize Number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    engineConfigPgTrackCommitTimestamp String
    Record commit time of transactions.
    engineConfigPgTrackFunctions String
    Enables tracking of function call counts and time used.
    engineConfigPgTrackIoTiming String
    Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.
    engineConfigPgWalSenderTimeout Number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    engineConfigPgWalWriterDelay Number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    engineConfigPglookoutMaxFailoverReplicationTimeLag Number
    Number of seconds of master unavailability before triggering database failover to standby. (default 60)
    engineConfigSharedBuffersPercentage Number
    Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.
    engineConfigWorkMem Number
    Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).
    engineId String
    The Managed Database engine in engine/version format. (e.g. postgresql/16)
    forkRestoreTime String
    The database timestamp from which it was restored.
    forkSource Number
    The ID of the database that was forked from.

    • updates - (Optional) Configuration settings for automated patch update maintenance for the Managed Database.
    hostPrimary String
    The primary host for the Managed Database.
    hostSecondary String
    The secondary/private host for the managed database.
    label String
    A unique, user-defined string referring to the Managed Database.
    members Map<String>
    A mapping between IP addresses and strings designating them as primary or failover.
    oldestRestoreTime String
    The oldest time to which a database can be restored.
    pendingUpdates List<Property Map>
    A set of pending updates.
    platform String
    The back-end platform for relational databases used by the service.
    port Number
    The access port for this Managed Database.
    region String
    The region to use for the Managed Database.
    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.
    status String
    The operating status of the Managed Database.
    suspended Boolean
    Whether this Managed Database should be suspended.
    timeouts Property Map
    type String
    The Linode Instance type used for the nodes of the Managed Database.

    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

    DatabasePostgresqlV2PendingUpdate, DatabasePostgresqlV2PendingUpdateArgs

    Deadline string
    Description string
    PlannedFor string
    Deadline string
    Description string
    PlannedFor string
    deadline String
    description String
    plannedFor String
    deadline string
    description string
    plannedFor string
    deadline String
    description String
    plannedFor String

    DatabasePostgresqlV2Timeouts, DatabasePostgresqlV2TimeoutsArgs

    Create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    Update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    Delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    Update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update string
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update str
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    create String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
    delete String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
    update String
    A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).

    DatabasePostgresqlV2Updates, DatabasePostgresqlV2UpdatesArgs

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

    Import

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

    $ pulumi import linode:index/databasePostgresqlV2:DatabasePostgresqlV2 foobar 1234567

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Linode pulumi/pulumi-linode
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the linode Terraform Provider.
    linode logo
    Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi
    pulumi/pulumi-linode