linode.getDatabasePostgresqlV2

Explore with Pulumi AI

Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi

pulumi/pulumi-linode

Example Usage

Get information about a PostgreSQL database:

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

const my_db = linode.getDatabasePostgresqlV2({
    id: "12345",
});

import pulumi
import pulumi_linode as linode

my_db = linode.get_database_postgresql_v2(id="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.LookupDatabasePostgresqlV2(ctx, &linode.LookupDatabasePostgresqlV2Args{
			Id: "12345",
		}, nil)
		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 my_db = Linode.GetDatabasePostgresqlV2.Invoke(new()
    {
        Id = "12345",
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.LinodeFunctions;
import com.pulumi.linode.inputs.GetDatabasePostgresqlV2Args;
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) {
        final var my-db = LinodeFunctions.getDatabasePostgresqlV2(GetDatabasePostgresqlV2Args.builder()
            .id("12345")
            .build());

    }
}

variables:
  my-db:
    fn::invoke:
      function: linode:getDatabasePostgresqlV2
      arguments:
        id: 12345

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 - The day to perform maintenance. (monday, tuesday, …)
duration - The maximum maintenance window time in hours. (1..3)
frequency - The frequency at which maintenance occurs. (weekly)
hour_of_day - The hour to begin maintenance based in UTC time. (0..23)

Using getDatabasePostgresqlV2

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

function getDatabasePostgresqlV2(args: GetDatabasePostgresqlV2Args, opts?: InvokeOptions): Promise<GetDatabasePostgresqlV2Result>
function getDatabasePostgresqlV2Output(args: GetDatabasePostgresqlV2OutputArgs, opts?: InvokeOptions): Output<GetDatabasePostgresqlV2Result>

def get_database_postgresql_v2(id: Optional[str] = None,
                               opts: Optional[InvokeOptions] = None) -> GetDatabasePostgresqlV2Result
def get_database_postgresql_v2_output(id: Optional[pulumi.Input[str]] = None,
                               opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePostgresqlV2Result]

func LookupDatabasePostgresqlV2(ctx *Context, args *LookupDatabasePostgresqlV2Args, opts ...InvokeOption) (*LookupDatabasePostgresqlV2Result, error)
func LookupDatabasePostgresqlV2Output(ctx *Context, args *LookupDatabasePostgresqlV2OutputArgs, opts ...InvokeOption) LookupDatabasePostgresqlV2ResultOutput

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

public static class GetDatabasePostgresqlV2 
{
    public static Task<GetDatabasePostgresqlV2Result> InvokeAsync(GetDatabasePostgresqlV2Args args, InvokeOptions? opts = null)
    public static Output<GetDatabasePostgresqlV2Result> Invoke(GetDatabasePostgresqlV2InvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabasePostgresqlV2Result> getDatabasePostgresqlV2(GetDatabasePostgresqlV2Args args, InvokeOptions options)
public static Output<GetDatabasePostgresqlV2Result> getDatabasePostgresqlV2(GetDatabasePostgresqlV2Args args, InvokeOptions options)

fn::invoke:
  function: linode:index/getDatabasePostgresqlV2:getDatabasePostgresqlV2
  arguments:
    # arguments dictionary

The following arguments are supported:

Id string: The ID of the PostgreSQL database.

Id string: The ID of the PostgreSQL database.

id String: The ID of the PostgreSQL database.

id string: The ID of the PostgreSQL database.

id str: The ID of the PostgreSQL database.

id String: The ID of the PostgreSQL database.

getDatabasePostgresqlV2 Result

The following output properties are available:

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.
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.
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.
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.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private host for the managed database.
Id string
Label string: A unique, user-defined string referring to the Managed Database.
Members Dictionary<string, string>
OldestRestoreTime string
PendingUpdates List<GetDatabasePostgresqlV2PendingUpdate>
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 is suspended.
Type string: The Linode Instance type used for the nodes of the Managed Database.
Updated string: When this Managed Database was last updated.
Updates GetDatabasePostgresqlV2Updates
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.
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.
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.
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.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private host for the managed database.
Id string
Label string: A unique, user-defined string referring to the Managed Database.
Members map[string]string
OldestRestoreTime string
PendingUpdates []GetDatabasePostgresqlV2PendingUpdate
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 is suspended.
Type string: The Linode Instance type used for the nodes of the Managed Database.
Updated string: When this Managed Database was last updated.
Updates GetDatabasePostgresqlV2Updates
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.
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.
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.
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.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private host for the managed database.
id String
label String: A unique, user-defined string referring to the Managed Database.
members Map<String,String>
oldestRestoreTime String
pendingUpdates List<GetDatabasePostgresqlV2PendingUpdate>
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 is suspended.
type String: The Linode Instance type used for the nodes of the Managed Database.
updated String: When this Managed Database was last updated.
updates GetDatabasePostgresqlV2Updates
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.
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.
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.
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.
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private host for the managed database.
id string
label string: A unique, user-defined string referring to the Managed Database.
members {[key: string]: string}
oldestRestoreTime string
pendingUpdates GetDatabasePostgresqlV2PendingUpdate[]
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 is suspended.
type string: The Linode Instance type used for the nodes of the Managed Database.
updated string: When this Managed Database was last updated.
updates GetDatabasePostgresqlV2Updates
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.
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.
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.
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.
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private host for the managed database.
id str
label str: A unique, user-defined string referring to the Managed Database.
members Mapping[str, str]
oldest_restore_time str
pending_updates Sequence[GetDatabasePostgresqlV2PendingUpdate]
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 is suspended.
type str: The Linode Instance type used for the nodes of the Managed Database.
updated str: When this Managed Database was last updated.
updates GetDatabasePostgresqlV2Updates
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.
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.
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.
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.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private host for the managed database.
id String
label String: A unique, user-defined string referring to the Managed Database.
members Map<String>
oldestRestoreTime String
pendingUpdates List<Property Map>
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 is suspended.
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
version String: The Managed Database engine version. (e.g. 13.2)