Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. UpCloud
  3. API Docs
  4. ManagedDatabasePostgresql
UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

upcloud.ManagedDatabasePostgresql

Explore with Pulumi AI

upcloud logo
UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
UpCloudLtd/pulumi-upcloud

    This resource represents PostgreSQL managed database. See UpCloud Managed Databases product page for more details about the service.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as upcloud from "@upcloud/pulumi-upcloud";

// Minimal config
const example1 = new upcloud.ManagedDatabasePostgresql("example_1", {
    name: "postgres-1",
    plan: "1x1xCPU-2GB-25GB",
    title: "postgres",
    zone: "fi-hel1",
});
// Service with custom properties
const example2 = new upcloud.ManagedDatabasePostgresql("example_2", {
    name: "postgres-2",
    plan: "1x1xCPU-2GB-25GB",
    title: "postgres",
    zone: "fi-hel1",
    properties: {
        timezone: "Europe/Helsinki",
        adminUsername: "admin",
        adminPassword: "<ADMIN_PASSWORD>",
    },
});

    import pulumi
import pulumi_upcloud as upcloud

# Minimal config
example1 = upcloud.ManagedDatabasePostgresql("example_1",
    name="postgres-1",
    plan="1x1xCPU-2GB-25GB",
    title="postgres",
    zone="fi-hel1")
# Service with custom properties
example2 = upcloud.ManagedDatabasePostgresql("example_2",
    name="postgres-2",
    plan="1x1xCPU-2GB-25GB",
    title="postgres",
    zone="fi-hel1",
    properties={
        "timezone": "Europe/Helsinki",
        "admin_username": "admin",
        "admin_password": "<ADMIN_PASSWORD>",
    })

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		// Minimal config
		_, err := upcloud.NewManagedDatabasePostgresql(ctx, "example_1", &upcloud.ManagedDatabasePostgresqlArgs{
			Name:  pulumi.String("postgres-1"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Title: pulumi.String("postgres"),
			Zone:  pulumi.String("fi-hel1"),
		})
		if err != nil {
			return err
		}
		// Service with custom properties
		_, err = upcloud.NewManagedDatabasePostgresql(ctx, "example_2", &upcloud.ManagedDatabasePostgresqlArgs{
			Name:  pulumi.String("postgres-2"),
			Plan:  pulumi.String("1x1xCPU-2GB-25GB"),
			Title: pulumi.String("postgres"),
			Zone:  pulumi.String("fi-hel1"),
			Properties: &upcloud.ManagedDatabasePostgresqlPropertiesArgs{
				Timezone:      pulumi.String("Europe/Helsinki"),
				AdminUsername: pulumi.String("admin"),
				AdminPassword: pulumi.String("<ADMIN_PASSWORD>"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    // Minimal config
    var example1 = new UpCloud.ManagedDatabasePostgresql("example_1", new()
    {
        Name = "postgres-1",
        Plan = "1x1xCPU-2GB-25GB",
        Title = "postgres",
        Zone = "fi-hel1",
    });

    // Service with custom properties
    var example2 = new UpCloud.ManagedDatabasePostgresql("example_2", new()
    {
        Name = "postgres-2",
        Plan = "1x1xCPU-2GB-25GB",
        Title = "postgres",
        Zone = "fi-hel1",
        Properties = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesArgs
        {
            Timezone = "Europe/Helsinki",
            AdminUsername = "admin",
            AdminPassword = "<ADMIN_PASSWORD>",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.upcloud.ManagedDatabasePostgresql;
import com.pulumi.upcloud.ManagedDatabasePostgresqlArgs;
import com.pulumi.upcloud.inputs.ManagedDatabasePostgresqlPropertiesArgs;
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) {
        // Minimal config
        var example1 = new ManagedDatabasePostgresql("example1", ManagedDatabasePostgresqlArgs.builder()
            .name("postgres-1")
            .plan("1x1xCPU-2GB-25GB")
            .title("postgres")
            .zone("fi-hel1")
            .build());

        // Service with custom properties
        var example2 = new ManagedDatabasePostgresql("example2", ManagedDatabasePostgresqlArgs.builder()
            .name("postgres-2")
            .plan("1x1xCPU-2GB-25GB")
            .title("postgres")
            .zone("fi-hel1")
            .properties(ManagedDatabasePostgresqlPropertiesArgs.builder()
                .timezone("Europe/Helsinki")
                .adminUsername("admin")
                .adminPassword("<ADMIN_PASSWORD>")
                .build())
            .build());

    }
}

    resources:
  # Minimal config
  example1:
    type: upcloud:ManagedDatabasePostgresql
    name: example_1
    properties:
      name: postgres-1
      plan: 1x1xCPU-2GB-25GB
      title: postgres
      zone: fi-hel1
  # Service with custom properties
  example2:
    type: upcloud:ManagedDatabasePostgresql
    name: example_2
    properties:
      name: postgres-2
      plan: 1x1xCPU-2GB-25GB
      title: postgres
      zone: fi-hel1
      properties:
        timezone: Europe/Helsinki
        adminUsername: admin
        adminPassword: <ADMIN_PASSWORD>

    Create ManagedDatabasePostgresql Resource

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

    Constructor syntax

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

@overload
def ManagedDatabasePostgresql(resource_name: str,
                              opts: Optional[ResourceOptions] = None,
                              plan: Optional[str] = None,
                              title: Optional[str] = None,
                              zone: Optional[str] = None,
                              labels: Optional[Mapping[str, str]] = None,
                              maintenance_window_dow: Optional[str] = None,
                              maintenance_window_time: Optional[str] = None,
                              name: Optional[str] = None,
                              networks: Optional[Sequence[ManagedDatabasePostgresqlNetworkArgs]] = None,
                              powered: Optional[bool] = None,
                              properties: Optional[ManagedDatabasePostgresqlPropertiesArgs] = None,
                              termination_protection: Optional[bool] = None)
    func NewManagedDatabasePostgresql(ctx *Context, name string, args ManagedDatabasePostgresqlArgs, opts ...ResourceOption) (*ManagedDatabasePostgresql, error)
    public ManagedDatabasePostgresql(string name, ManagedDatabasePostgresqlArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabasePostgresql(String name, ManagedDatabasePostgresqlArgs args)
public ManagedDatabasePostgresql(String name, ManagedDatabasePostgresqlArgs args, CustomResourceOptions options)

    type: upcloud:ManagedDatabasePostgresql
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 ManagedDatabasePostgresqlArgs
    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 ManagedDatabasePostgresqlArgs
    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 ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabasePostgresqlArgs
    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 managedDatabasePostgresqlResource = new UpCloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource", new()
{
    Plan = "string",
    Title = "string",
    Zone = "string",
    Labels = 
    {
        { "string", "string" },
    },
    MaintenanceWindowDow = "string",
    MaintenanceWindowTime = "string",
    Name = "string",
    Networks = new[]
    {
        new UpCloud.Inputs.ManagedDatabasePostgresqlNetworkArgs
        {
            Family = "string",
            Name = "string",
            Type = "string",
            Uuid = "string",
        },
    },
    Powered = false,
    Properties = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesArgs
    {
        AdminPassword = "string",
        AdminUsername = "string",
        AutomaticUtilityNetworkIpFilter = false,
        AutovacuumAnalyzeScaleFactor = 0,
        AutovacuumAnalyzeThreshold = 0,
        AutovacuumFreezeMaxAge = 0,
        AutovacuumMaxWorkers = 0,
        AutovacuumNaptime = 0,
        AutovacuumVacuumCostDelay = 0,
        AutovacuumVacuumCostLimit = 0,
        AutovacuumVacuumScaleFactor = 0,
        AutovacuumVacuumThreshold = 0,
        BackupHour = 0,
        BackupMinute = 0,
        BgwriterDelay = 0,
        BgwriterFlushAfter = 0,
        BgwriterLruMaxpages = 0,
        BgwriterLruMultiplier = 0,
        DeadlockTimeout = 0,
        DefaultToastCompression = "string",
        IdleInTransactionSessionTimeout = 0,
        IpFilters = new[]
        {
            "string",
        },
        Jit = false,
        LogAutovacuumMinDuration = 0,
        LogErrorVerbosity = "string",
        LogLinePrefix = "string",
        LogMinDurationStatement = 0,
        LogTempFiles = 0,
        MaxFilesPerProcess = 0,
        MaxLocksPerTransaction = 0,
        MaxLogicalReplicationWorkers = 0,
        MaxParallelWorkers = 0,
        MaxParallelWorkersPerGather = 0,
        MaxPredLocksPerTransaction = 0,
        MaxPreparedTransactions = 0,
        MaxReplicationSlots = 0,
        MaxSlotWalKeepSize = 0,
        MaxStackDepth = 0,
        MaxStandbyArchiveDelay = 0,
        MaxStandbyStreamingDelay = 0,
        MaxWalSenders = 0,
        MaxWorkerProcesses = 0,
        Migration = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesMigrationArgs
        {
            Dbname = "string",
            Host = "string",
            IgnoreDbs = "string",
            IgnoreRoles = "string",
            Method = "string",
            Password = "string",
            Port = 0,
            Ssl = false,
            Username = "string",
        },
        PasswordEncryption = "string",
        PgPartmanBgwInterval = 0,
        PgPartmanBgwRole = "string",
        PgStatMonitorEnable = false,
        PgStatMonitorPgsmEnableQueryPlan = false,
        PgStatMonitorPgsmMaxBuckets = 0,
        PgStatStatementsTrack = "string",
        Pgbouncer = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgbouncerArgs
        {
            AutodbIdleTimeout = 0,
            AutodbMaxDbConnections = 0,
            AutodbPoolMode = "string",
            AutodbPoolSize = 0,
            IgnoreStartupParameters = new[]
            {
                "string",
            },
            MaxPreparedStatements = 0,
            MinPoolSize = 0,
            ServerIdleTimeout = 0,
            ServerLifetime = 0,
            ServerResetQueryAlways = false,
        },
        Pglookout = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPglookoutArgs
        {
            MaxFailoverReplicationTimeLag = 0,
        },
        PublicAccess = false,
        ServiceLog = false,
        SharedBuffersPercentage = 0,
        SynchronousReplication = "string",
        TempFileLimit = 0,
        Timescaledb = new UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesTimescaledbArgs
        {
            MaxBackgroundWorkers = 0,
        },
        Timezone = "string",
        TrackActivityQuerySize = 0,
        TrackCommitTimestamp = "string",
        TrackFunctions = "string",
        TrackIoTiming = "string",
        Variant = "string",
        Version = "string",
        WalSenderTimeout = 0,
        WalWriterDelay = 0,
        WorkMem = 0,
    },
    TerminationProtection = false,
});

    example, err := upcloud.NewManagedDatabasePostgresql(ctx, "managedDatabasePostgresqlResource", &upcloud.ManagedDatabasePostgresqlArgs{
	Plan:  pulumi.String("string"),
	Title: pulumi.String("string"),
	Zone:  pulumi.String("string"),
	Labels: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	MaintenanceWindowDow:  pulumi.String("string"),
	MaintenanceWindowTime: pulumi.String("string"),
	Name:                  pulumi.String("string"),
	Networks: upcloud.ManagedDatabasePostgresqlNetworkArray{
		&upcloud.ManagedDatabasePostgresqlNetworkArgs{
			Family: pulumi.String("string"),
			Name:   pulumi.String("string"),
			Type:   pulumi.String("string"),
			Uuid:   pulumi.String("string"),
		},
	},
	Powered: pulumi.Bool(false),
	Properties: &upcloud.ManagedDatabasePostgresqlPropertiesArgs{
		AdminPassword:                   pulumi.String("string"),
		AdminUsername:                   pulumi.String("string"),
		AutomaticUtilityNetworkIpFilter: pulumi.Bool(false),
		AutovacuumAnalyzeScaleFactor:    pulumi.Float64(0),
		AutovacuumAnalyzeThreshold:      pulumi.Int(0),
		AutovacuumFreezeMaxAge:          pulumi.Int(0),
		AutovacuumMaxWorkers:            pulumi.Int(0),
		AutovacuumNaptime:               pulumi.Int(0),
		AutovacuumVacuumCostDelay:       pulumi.Int(0),
		AutovacuumVacuumCostLimit:       pulumi.Int(0),
		AutovacuumVacuumScaleFactor:     pulumi.Float64(0),
		AutovacuumVacuumThreshold:       pulumi.Int(0),
		BackupHour:                      pulumi.Int(0),
		BackupMinute:                    pulumi.Int(0),
		BgwriterDelay:                   pulumi.Int(0),
		BgwriterFlushAfter:              pulumi.Int(0),
		BgwriterLruMaxpages:             pulumi.Int(0),
		BgwriterLruMultiplier:           pulumi.Float64(0),
		DeadlockTimeout:                 pulumi.Int(0),
		DefaultToastCompression:         pulumi.String("string"),
		IdleInTransactionSessionTimeout: pulumi.Int(0),
		IpFilters: pulumi.StringArray{
			pulumi.String("string"),
		},
		Jit:                          pulumi.Bool(false),
		LogAutovacuumMinDuration:     pulumi.Int(0),
		LogErrorVerbosity:            pulumi.String("string"),
		LogLinePrefix:                pulumi.String("string"),
		LogMinDurationStatement:      pulumi.Int(0),
		LogTempFiles:                 pulumi.Int(0),
		MaxFilesPerProcess:           pulumi.Int(0),
		MaxLocksPerTransaction:       pulumi.Int(0),
		MaxLogicalReplicationWorkers: pulumi.Int(0),
		MaxParallelWorkers:           pulumi.Int(0),
		MaxParallelWorkersPerGather:  pulumi.Int(0),
		MaxPredLocksPerTransaction:   pulumi.Int(0),
		MaxPreparedTransactions:      pulumi.Int(0),
		MaxReplicationSlots:          pulumi.Int(0),
		MaxSlotWalKeepSize:           pulumi.Int(0),
		MaxStackDepth:                pulumi.Int(0),
		MaxStandbyArchiveDelay:       pulumi.Int(0),
		MaxStandbyStreamingDelay:     pulumi.Int(0),
		MaxWalSenders:                pulumi.Int(0),
		MaxWorkerProcesses:           pulumi.Int(0),
		Migration: &upcloud.ManagedDatabasePostgresqlPropertiesMigrationArgs{
			Dbname:      pulumi.String("string"),
			Host:        pulumi.String("string"),
			IgnoreDbs:   pulumi.String("string"),
			IgnoreRoles: pulumi.String("string"),
			Method:      pulumi.String("string"),
			Password:    pulumi.String("string"),
			Port:        pulumi.Int(0),
			Ssl:         pulumi.Bool(false),
			Username:    pulumi.String("string"),
		},
		PasswordEncryption:               pulumi.String("string"),
		PgPartmanBgwInterval:             pulumi.Int(0),
		PgPartmanBgwRole:                 pulumi.String("string"),
		PgStatMonitorEnable:              pulumi.Bool(false),
		PgStatMonitorPgsmEnableQueryPlan: pulumi.Bool(false),
		PgStatMonitorPgsmMaxBuckets:      pulumi.Int(0),
		PgStatStatementsTrack:            pulumi.String("string"),
		Pgbouncer: &upcloud.ManagedDatabasePostgresqlPropertiesPgbouncerArgs{
			AutodbIdleTimeout:      pulumi.Int(0),
			AutodbMaxDbConnections: pulumi.Int(0),
			AutodbPoolMode:         pulumi.String("string"),
			AutodbPoolSize:         pulumi.Int(0),
			IgnoreStartupParameters: pulumi.StringArray{
				pulumi.String("string"),
			},
			MaxPreparedStatements:  pulumi.Int(0),
			MinPoolSize:            pulumi.Int(0),
			ServerIdleTimeout:      pulumi.Int(0),
			ServerLifetime:         pulumi.Int(0),
			ServerResetQueryAlways: pulumi.Bool(false),
		},
		Pglookout: &upcloud.ManagedDatabasePostgresqlPropertiesPglookoutArgs{
			MaxFailoverReplicationTimeLag: pulumi.Int(0),
		},
		PublicAccess:            pulumi.Bool(false),
		ServiceLog:              pulumi.Bool(false),
		SharedBuffersPercentage: pulumi.Float64(0),
		SynchronousReplication:  pulumi.String("string"),
		TempFileLimit:           pulumi.Int(0),
		Timescaledb: &upcloud.ManagedDatabasePostgresqlPropertiesTimescaledbArgs{
			MaxBackgroundWorkers: pulumi.Int(0),
		},
		Timezone:               pulumi.String("string"),
		TrackActivityQuerySize: pulumi.Int(0),
		TrackCommitTimestamp:   pulumi.String("string"),
		TrackFunctions:         pulumi.String("string"),
		TrackIoTiming:          pulumi.String("string"),
		Variant:                pulumi.String("string"),
		Version:                pulumi.String("string"),
		WalSenderTimeout:       pulumi.Int(0),
		WalWriterDelay:         pulumi.Int(0),
		WorkMem:                pulumi.Int(0),
	},
	TerminationProtection: pulumi.Bool(false),
})

    var managedDatabasePostgresqlResource = new ManagedDatabasePostgresql("managedDatabasePostgresqlResource", ManagedDatabasePostgresqlArgs.builder()
    .plan("string")
    .title("string")
    .zone("string")
    .labels(Map.of("string", "string"))
    .maintenanceWindowDow("string")
    .maintenanceWindowTime("string")
    .name("string")
    .networks(ManagedDatabasePostgresqlNetworkArgs.builder()
        .family("string")
        .name("string")
        .type("string")
        .uuid("string")
        .build())
    .powered(false)
    .properties(ManagedDatabasePostgresqlPropertiesArgs.builder()
        .adminPassword("string")
        .adminUsername("string")
        .automaticUtilityNetworkIpFilter(false)
        .autovacuumAnalyzeScaleFactor(0)
        .autovacuumAnalyzeThreshold(0)
        .autovacuumFreezeMaxAge(0)
        .autovacuumMaxWorkers(0)
        .autovacuumNaptime(0)
        .autovacuumVacuumCostDelay(0)
        .autovacuumVacuumCostLimit(0)
        .autovacuumVacuumScaleFactor(0)
        .autovacuumVacuumThreshold(0)
        .backupHour(0)
        .backupMinute(0)
        .bgwriterDelay(0)
        .bgwriterFlushAfter(0)
        .bgwriterLruMaxpages(0)
        .bgwriterLruMultiplier(0)
        .deadlockTimeout(0)
        .defaultToastCompression("string")
        .idleInTransactionSessionTimeout(0)
        .ipFilters("string")
        .jit(false)
        .logAutovacuumMinDuration(0)
        .logErrorVerbosity("string")
        .logLinePrefix("string")
        .logMinDurationStatement(0)
        .logTempFiles(0)
        .maxFilesPerProcess(0)
        .maxLocksPerTransaction(0)
        .maxLogicalReplicationWorkers(0)
        .maxParallelWorkers(0)
        .maxParallelWorkersPerGather(0)
        .maxPredLocksPerTransaction(0)
        .maxPreparedTransactions(0)
        .maxReplicationSlots(0)
        .maxSlotWalKeepSize(0)
        .maxStackDepth(0)
        .maxStandbyArchiveDelay(0)
        .maxStandbyStreamingDelay(0)
        .maxWalSenders(0)
        .maxWorkerProcesses(0)
        .migration(ManagedDatabasePostgresqlPropertiesMigrationArgs.builder()
            .dbname("string")
            .host("string")
            .ignoreDbs("string")
            .ignoreRoles("string")
            .method("string")
            .password("string")
            .port(0)
            .ssl(false)
            .username("string")
            .build())
        .passwordEncryption("string")
        .pgPartmanBgwInterval(0)
        .pgPartmanBgwRole("string")
        .pgStatMonitorEnable(false)
        .pgStatMonitorPgsmEnableQueryPlan(false)
        .pgStatMonitorPgsmMaxBuckets(0)
        .pgStatStatementsTrack("string")
        .pgbouncer(ManagedDatabasePostgresqlPropertiesPgbouncerArgs.builder()
            .autodbIdleTimeout(0)
            .autodbMaxDbConnections(0)
            .autodbPoolMode("string")
            .autodbPoolSize(0)
            .ignoreStartupParameters("string")
            .maxPreparedStatements(0)
            .minPoolSize(0)
            .serverIdleTimeout(0)
            .serverLifetime(0)
            .serverResetQueryAlways(false)
            .build())
        .pglookout(ManagedDatabasePostgresqlPropertiesPglookoutArgs.builder()
            .maxFailoverReplicationTimeLag(0)
            .build())
        .publicAccess(false)
        .serviceLog(false)
        .sharedBuffersPercentage(0)
        .synchronousReplication("string")
        .tempFileLimit(0)
        .timescaledb(ManagedDatabasePostgresqlPropertiesTimescaledbArgs.builder()
            .maxBackgroundWorkers(0)
            .build())
        .timezone("string")
        .trackActivityQuerySize(0)
        .trackCommitTimestamp("string")
        .trackFunctions("string")
        .trackIoTiming("string")
        .variant("string")
        .version("string")
        .walSenderTimeout(0)
        .walWriterDelay(0)
        .workMem(0)
        .build())
    .terminationProtection(false)
    .build());

    managed_database_postgresql_resource = upcloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource",
    plan="string",
    title="string",
    zone="string",
    labels={
        "string": "string",
    },
    maintenance_window_dow="string",
    maintenance_window_time="string",
    name="string",
    networks=[{
        "family": "string",
        "name": "string",
        "type": "string",
        "uuid": "string",
    }],
    powered=False,
    properties={
        "admin_password": "string",
        "admin_username": "string",
        "automatic_utility_network_ip_filter": False,
        "autovacuum_analyze_scale_factor": 0,
        "autovacuum_analyze_threshold": 0,
        "autovacuum_freeze_max_age": 0,
        "autovacuum_max_workers": 0,
        "autovacuum_naptime": 0,
        "autovacuum_vacuum_cost_delay": 0,
        "autovacuum_vacuum_cost_limit": 0,
        "autovacuum_vacuum_scale_factor": 0,
        "autovacuum_vacuum_threshold": 0,
        "backup_hour": 0,
        "backup_minute": 0,
        "bgwriter_delay": 0,
        "bgwriter_flush_after": 0,
        "bgwriter_lru_maxpages": 0,
        "bgwriter_lru_multiplier": 0,
        "deadlock_timeout": 0,
        "default_toast_compression": "string",
        "idle_in_transaction_session_timeout": 0,
        "ip_filters": ["string"],
        "jit": False,
        "log_autovacuum_min_duration": 0,
        "log_error_verbosity": "string",
        "log_line_prefix": "string",
        "log_min_duration_statement": 0,
        "log_temp_files": 0,
        "max_files_per_process": 0,
        "max_locks_per_transaction": 0,
        "max_logical_replication_workers": 0,
        "max_parallel_workers": 0,
        "max_parallel_workers_per_gather": 0,
        "max_pred_locks_per_transaction": 0,
        "max_prepared_transactions": 0,
        "max_replication_slots": 0,
        "max_slot_wal_keep_size": 0,
        "max_stack_depth": 0,
        "max_standby_archive_delay": 0,
        "max_standby_streaming_delay": 0,
        "max_wal_senders": 0,
        "max_worker_processes": 0,
        "migration": {
            "dbname": "string",
            "host": "string",
            "ignore_dbs": "string",
            "ignore_roles": "string",
            "method": "string",
            "password": "string",
            "port": 0,
            "ssl": False,
            "username": "string",
        },
        "password_encryption": "string",
        "pg_partman_bgw_interval": 0,
        "pg_partman_bgw_role": "string",
        "pg_stat_monitor_enable": False,
        "pg_stat_monitor_pgsm_enable_query_plan": False,
        "pg_stat_monitor_pgsm_max_buckets": 0,
        "pg_stat_statements_track": "string",
        "pgbouncer": {
            "autodb_idle_timeout": 0,
            "autodb_max_db_connections": 0,
            "autodb_pool_mode": "string",
            "autodb_pool_size": 0,
            "ignore_startup_parameters": ["string"],
            "max_prepared_statements": 0,
            "min_pool_size": 0,
            "server_idle_timeout": 0,
            "server_lifetime": 0,
            "server_reset_query_always": False,
        },
        "pglookout": {
            "max_failover_replication_time_lag": 0,
        },
        "public_access": False,
        "service_log": False,
        "shared_buffers_percentage": 0,
        "synchronous_replication": "string",
        "temp_file_limit": 0,
        "timescaledb": {
            "max_background_workers": 0,
        },
        "timezone": "string",
        "track_activity_query_size": 0,
        "track_commit_timestamp": "string",
        "track_functions": "string",
        "track_io_timing": "string",
        "variant": "string",
        "version": "string",
        "wal_sender_timeout": 0,
        "wal_writer_delay": 0,
        "work_mem": 0,
    },
    termination_protection=False)

    const managedDatabasePostgresqlResource = new upcloud.ManagedDatabasePostgresql("managedDatabasePostgresqlResource", {
    plan: "string",
    title: "string",
    zone: "string",
    labels: {
        string: "string",
    },
    maintenanceWindowDow: "string",
    maintenanceWindowTime: "string",
    name: "string",
    networks: [{
        family: "string",
        name: "string",
        type: "string",
        uuid: "string",
    }],
    powered: false,
    properties: {
        adminPassword: "string",
        adminUsername: "string",
        automaticUtilityNetworkIpFilter: false,
        autovacuumAnalyzeScaleFactor: 0,
        autovacuumAnalyzeThreshold: 0,
        autovacuumFreezeMaxAge: 0,
        autovacuumMaxWorkers: 0,
        autovacuumNaptime: 0,
        autovacuumVacuumCostDelay: 0,
        autovacuumVacuumCostLimit: 0,
        autovacuumVacuumScaleFactor: 0,
        autovacuumVacuumThreshold: 0,
        backupHour: 0,
        backupMinute: 0,
        bgwriterDelay: 0,
        bgwriterFlushAfter: 0,
        bgwriterLruMaxpages: 0,
        bgwriterLruMultiplier: 0,
        deadlockTimeout: 0,
        defaultToastCompression: "string",
        idleInTransactionSessionTimeout: 0,
        ipFilters: ["string"],
        jit: false,
        logAutovacuumMinDuration: 0,
        logErrorVerbosity: "string",
        logLinePrefix: "string",
        logMinDurationStatement: 0,
        logTempFiles: 0,
        maxFilesPerProcess: 0,
        maxLocksPerTransaction: 0,
        maxLogicalReplicationWorkers: 0,
        maxParallelWorkers: 0,
        maxParallelWorkersPerGather: 0,
        maxPredLocksPerTransaction: 0,
        maxPreparedTransactions: 0,
        maxReplicationSlots: 0,
        maxSlotWalKeepSize: 0,
        maxStackDepth: 0,
        maxStandbyArchiveDelay: 0,
        maxStandbyStreamingDelay: 0,
        maxWalSenders: 0,
        maxWorkerProcesses: 0,
        migration: {
            dbname: "string",
            host: "string",
            ignoreDbs: "string",
            ignoreRoles: "string",
            method: "string",
            password: "string",
            port: 0,
            ssl: false,
            username: "string",
        },
        passwordEncryption: "string",
        pgPartmanBgwInterval: 0,
        pgPartmanBgwRole: "string",
        pgStatMonitorEnable: false,
        pgStatMonitorPgsmEnableQueryPlan: false,
        pgStatMonitorPgsmMaxBuckets: 0,
        pgStatStatementsTrack: "string",
        pgbouncer: {
            autodbIdleTimeout: 0,
            autodbMaxDbConnections: 0,
            autodbPoolMode: "string",
            autodbPoolSize: 0,
            ignoreStartupParameters: ["string"],
            maxPreparedStatements: 0,
            minPoolSize: 0,
            serverIdleTimeout: 0,
            serverLifetime: 0,
            serverResetQueryAlways: false,
        },
        pglookout: {
            maxFailoverReplicationTimeLag: 0,
        },
        publicAccess: false,
        serviceLog: false,
        sharedBuffersPercentage: 0,
        synchronousReplication: "string",
        tempFileLimit: 0,
        timescaledb: {
            maxBackgroundWorkers: 0,
        },
        timezone: "string",
        trackActivityQuerySize: 0,
        trackCommitTimestamp: "string",
        trackFunctions: "string",
        trackIoTiming: "string",
        variant: "string",
        version: "string",
        walSenderTimeout: 0,
        walWriterDelay: 0,
        workMem: 0,
    },
    terminationProtection: false,
});

    type: upcloud:ManagedDatabasePostgresql
properties:
    labels:
        string: string
    maintenanceWindowDow: string
    maintenanceWindowTime: string
    name: string
    networks:
        - family: string
          name: string
          type: string
          uuid: string
    plan: string
    powered: false
    properties:
        adminPassword: string
        adminUsername: string
        automaticUtilityNetworkIpFilter: false
        autovacuumAnalyzeScaleFactor: 0
        autovacuumAnalyzeThreshold: 0
        autovacuumFreezeMaxAge: 0
        autovacuumMaxWorkers: 0
        autovacuumNaptime: 0
        autovacuumVacuumCostDelay: 0
        autovacuumVacuumCostLimit: 0
        autovacuumVacuumScaleFactor: 0
        autovacuumVacuumThreshold: 0
        backupHour: 0
        backupMinute: 0
        bgwriterDelay: 0
        bgwriterFlushAfter: 0
        bgwriterLruMaxpages: 0
        bgwriterLruMultiplier: 0
        deadlockTimeout: 0
        defaultToastCompression: string
        idleInTransactionSessionTimeout: 0
        ipFilters:
            - string
        jit: false
        logAutovacuumMinDuration: 0
        logErrorVerbosity: string
        logLinePrefix: string
        logMinDurationStatement: 0
        logTempFiles: 0
        maxFilesPerProcess: 0
        maxLocksPerTransaction: 0
        maxLogicalReplicationWorkers: 0
        maxParallelWorkers: 0
        maxParallelWorkersPerGather: 0
        maxPredLocksPerTransaction: 0
        maxPreparedTransactions: 0
        maxReplicationSlots: 0
        maxSlotWalKeepSize: 0
        maxStackDepth: 0
        maxStandbyArchiveDelay: 0
        maxStandbyStreamingDelay: 0
        maxWalSenders: 0
        maxWorkerProcesses: 0
        migration:
            dbname: string
            host: string
            ignoreDbs: string
            ignoreRoles: string
            method: string
            password: string
            port: 0
            ssl: false
            username: string
        passwordEncryption: string
        pgPartmanBgwInterval: 0
        pgPartmanBgwRole: string
        pgStatMonitorEnable: false
        pgStatMonitorPgsmEnableQueryPlan: false
        pgStatMonitorPgsmMaxBuckets: 0
        pgStatStatementsTrack: string
        pgbouncer:
            autodbIdleTimeout: 0
            autodbMaxDbConnections: 0
            autodbPoolMode: string
            autodbPoolSize: 0
            ignoreStartupParameters:
                - string
            maxPreparedStatements: 0
            minPoolSize: 0
            serverIdleTimeout: 0
            serverLifetime: 0
            serverResetQueryAlways: false
        pglookout:
            maxFailoverReplicationTimeLag: 0
        publicAccess: false
        serviceLog: false
        sharedBuffersPercentage: 0
        synchronousReplication: string
        tempFileLimit: 0
        timescaledb:
            maxBackgroundWorkers: 0
        timezone: string
        trackActivityQuerySize: 0
        trackCommitTimestamp: string
        trackFunctions: string
        trackIoTiming: string
        variant: string
        version: string
        walSenderTimeout: 0
        walWriterDelay: 0
        workMem: 0
    terminationProtection: false
    title: string
    zone: string

    ManagedDatabasePostgresql 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 ManagedDatabasePostgresql resource accepts the following input properties:

    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Title string
    Title of a managed database instance
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabasePostgresqlNetworkArgs
    Private networks attached to the managed database
    Powered bool
    The administrative power state of the service
    Properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title string
    Title of a managed database instance
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabasePostgresqlNetwork[]
    Private networks attached to the managed database
    powered boolean
    The administrative power state of the service
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title str
    Title of a managed database instance
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabasePostgresqlNetworkArgs]
    Private networks attached to the managed database
    powered bool
    The administrative power state of the service
    properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    title String
    Title of a managed database instance
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    powered Boolean
    The administrative power state of the service
    properties Property Map
    Database Engine properties for PostgreSQL
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the ManagedDatabasePostgresql resource produces the following output properties:

    Components List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabasePostgresqlComponent>
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates List<UpCloud.Pulumi.UpCloud.Outputs.ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    Type string
    Type of the service
    Components []ManagedDatabasePostgresqlComponent
    Service component information
    Id string
    The provider-assigned unique ID for this managed resource.
    NodeStates []ManagedDatabasePostgresqlNodeState
    Information about nodes providing the managed service
    PrimaryDatabase string
    Primary database name
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    Type string
    Type of the service
    components List<ManagedDatabasePostgresqlComponent>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    type String
    Type of the service
    components ManagedDatabasePostgresqlComponent[]
    Service component information
    id string
    The provider-assigned unique ID for this managed resource.
    nodeStates ManagedDatabasePostgresqlNodeState[]
    Information about nodes providing the managed service
    primaryDatabase string
    Primary database name
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    sslmode string
    SSL Connection Mode for PostgreSQL
    state string
    State of the service
    type string
    Type of the service
    components Sequence[ManagedDatabasePostgresqlComponent]
    Service component information
    id str
    The provider-assigned unique ID for this managed resource.
    node_states Sequence[ManagedDatabasePostgresqlNodeState]
    Information about nodes providing the managed service
    primary_database str
    Primary database name
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    sslmode str
    SSL Connection Mode for PostgreSQL
    state str
    State of the service
    type str
    Type of the service
    components List<Property Map>
    Service component information
    id String
    The provider-assigned unique ID for this managed resource.
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    primaryDatabase String
    Primary database name
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    type String
    Type of the service

    Look up Existing ManagedDatabasePostgresql Resource

    Get an existing ManagedDatabasePostgresql 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?: ManagedDatabasePostgresqlState, opts?: CustomResourceOptions): ManagedDatabasePostgresql
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        components: Optional[Sequence[ManagedDatabasePostgresqlComponentArgs]] = None,
        labels: Optional[Mapping[str, str]] = None,
        maintenance_window_dow: Optional[str] = None,
        maintenance_window_time: Optional[str] = None,
        name: Optional[str] = None,
        networks: Optional[Sequence[ManagedDatabasePostgresqlNetworkArgs]] = None,
        node_states: Optional[Sequence[ManagedDatabasePostgresqlNodeStateArgs]] = None,
        plan: Optional[str] = None,
        powered: Optional[bool] = None,
        primary_database: Optional[str] = None,
        properties: Optional[ManagedDatabasePostgresqlPropertiesArgs] = None,
        service_host: Optional[str] = None,
        service_password: Optional[str] = None,
        service_port: Optional[str] = None,
        service_uri: Optional[str] = None,
        service_username: Optional[str] = None,
        sslmode: Optional[str] = None,
        state: Optional[str] = None,
        termination_protection: Optional[bool] = None,
        title: Optional[str] = None,
        type: Optional[str] = None,
        zone: Optional[str] = None) -> ManagedDatabasePostgresql
    func GetManagedDatabasePostgresql(ctx *Context, name string, id IDInput, state *ManagedDatabasePostgresqlState, opts ...ResourceOption) (*ManagedDatabasePostgresql, error)
    public static ManagedDatabasePostgresql Get(string name, Input<string> id, ManagedDatabasePostgresqlState? state, CustomResourceOptions? opts = null)
    public static ManagedDatabasePostgresql get(String name, Output<String> id, ManagedDatabasePostgresqlState state, CustomResourceOptions options)
    resources:  _:    type: upcloud:ManagedDatabasePostgresql    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:
    Components List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlComponent>
    Service component information
    Labels Dictionary<string, string>
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    NodeStates List<UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    Components []ManagedDatabasePostgresqlComponentArgs
    Service component information
    Labels map[string]string
    User defined key-value pairs to classify the managed database.
    MaintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    MaintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    Name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    Networks []ManagedDatabasePostgresqlNetworkArgs
    Private networks attached to the managed database
    NodeStates []ManagedDatabasePostgresqlNodeStateArgs
    Information about nodes providing the managed service
    Plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    Powered bool
    The administrative power state of the service
    PrimaryDatabase string
    Primary database name
    Properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    ServiceHost string
    Hostname to the service instance
    ServicePassword string
    Primary username's password to the service instance
    ServicePort string
    Port to the service instance
    ServiceUri string
    URI to the service instance
    ServiceUsername string
    Primary username to the service instance
    Sslmode string
    SSL Connection Mode for PostgreSQL
    State string
    State of the service
    TerminationProtection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    Title string
    Title of a managed database instance
    Type string
    Type of the service
    Zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<ManagedDatabasePostgresqlComponent>
    Service component information
    labels Map<String,String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<ManagedDatabasePostgresqlNetwork>
    Private networks attached to the managed database
    nodeStates List<ManagedDatabasePostgresqlNodeState>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components ManagedDatabasePostgresqlComponent[]
    Service component information
    labels {[key: string]: string}
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow string
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime string
    Maintenance window UTC time in hh:mm:ss format
    name string
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks ManagedDatabasePostgresqlNetwork[]
    Private networks attached to the managed database
    nodeStates ManagedDatabasePostgresqlNodeState[]
    Information about nodes providing the managed service
    plan string
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered boolean
    The administrative power state of the service
    primaryDatabase string
    Primary database name
    properties ManagedDatabasePostgresqlProperties
    Database Engine properties for PostgreSQL
    serviceHost string
    Hostname to the service instance
    servicePassword string
    Primary username's password to the service instance
    servicePort string
    Port to the service instance
    serviceUri string
    URI to the service instance
    serviceUsername string
    Primary username to the service instance
    sslmode string
    SSL Connection Mode for PostgreSQL
    state string
    State of the service
    terminationProtection boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title string
    Title of a managed database instance
    type string
    Type of the service
    zone string
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components Sequence[ManagedDatabasePostgresqlComponentArgs]
    Service component information
    labels Mapping[str, str]
    User defined key-value pairs to classify the managed database.
    maintenance_window_dow str
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenance_window_time str
    Maintenance window UTC time in hh:mm:ss format
    name str
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks Sequence[ManagedDatabasePostgresqlNetworkArgs]
    Private networks attached to the managed database
    node_states Sequence[ManagedDatabasePostgresqlNodeStateArgs]
    Information about nodes providing the managed service
    plan str
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered bool
    The administrative power state of the service
    primary_database str
    Primary database name
    properties ManagedDatabasePostgresqlPropertiesArgs
    Database Engine properties for PostgreSQL
    service_host str
    Hostname to the service instance
    service_password str
    Primary username's password to the service instance
    service_port str
    Port to the service instance
    service_uri str
    URI to the service instance
    service_username str
    Primary username to the service instance
    sslmode str
    SSL Connection Mode for PostgreSQL
    state str
    State of the service
    termination_protection bool
    If set to true, prevents the managed service from being powered off, or deleted.
    title str
    Title of a managed database instance
    type str
    Type of the service
    zone str
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.
    components List<Property Map>
    Service component information
    labels Map<String>
    User defined key-value pairs to classify the managed database.
    maintenanceWindowDow String
    Maintenance window day of week. Lower case weekday name (monday, tuesday, ...)
    maintenanceWindowTime String
    Maintenance window UTC time in hh:mm:ss format
    name String
    Name of the service. The name is used as a prefix for the logical hostname. Must be unique within an account
    networks List<Property Map>
    Private networks attached to the managed database
    nodeStates List<Property Map>
    Information about nodes providing the managed service
    plan String
    Service plan to use. This determines how much resources the instance will have. You can list available plans with upctl database plans <type>.
    powered Boolean
    The administrative power state of the service
    primaryDatabase String
    Primary database name
    properties Property Map
    Database Engine properties for PostgreSQL
    serviceHost String
    Hostname to the service instance
    servicePassword String
    Primary username's password to the service instance
    servicePort String
    Port to the service instance
    serviceUri String
    URI to the service instance
    serviceUsername String
    Primary username to the service instance
    sslmode String
    SSL Connection Mode for PostgreSQL
    state String
    State of the service
    terminationProtection Boolean
    If set to true, prevents the managed service from being powered off, or deleted.
    title String
    Title of a managed database instance
    type String
    Type of the service
    zone String
    Zone where the instance resides, e.g. de-fra1. You can list available zones with upctl zone list.

    Supporting Types

    ManagedDatabasePostgresqlComponent, ManagedDatabasePostgresqlComponentArgs

    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    Component string
    Type of the component
    Host string
    Hostname of the component
    Port int
    Port number of the component
    Route string
    Component network route type
    Usage string
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Integer
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component
    component string
    Type of the component
    host string
    Hostname of the component
    port number
    Port number of the component
    route string
    Component network route type
    usage string
    Usage of the component
    component str
    Type of the component
    host str
    Hostname of the component
    port int
    Port number of the component
    route str
    Component network route type
    usage str
    Usage of the component
    component String
    Type of the component
    host String
    Hostname of the component
    port Number
    Port number of the component
    route String
    Component network route type
    usage String
    Usage of the component

    ManagedDatabasePostgresqlNetwork, ManagedDatabasePostgresqlNetworkArgs

    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    Family string
    Network family. Currently only IPv4 is supported.
    Name string
    The name of the network. Must be unique within the service.
    Type string
    The type of the network. Must be private.
    Uuid string
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.
    family string
    Network family. Currently only IPv4 is supported.
    name string
    The name of the network. Must be unique within the service.
    type string
    The type of the network. Must be private.
    uuid string
    Private network UUID. Must reside in the same zone as the database.
    family str
    Network family. Currently only IPv4 is supported.
    name str
    The name of the network. Must be unique within the service.
    type str
    The type of the network. Must be private.
    uuid str
    Private network UUID. Must reside in the same zone as the database.
    family String
    Network family. Currently only IPv4 is supported.
    name String
    The name of the network. Must be unique within the service.
    type String
    The type of the network. Must be private.
    uuid String
    Private network UUID. Must reside in the same zone as the database.

    ManagedDatabasePostgresqlNodeState, ManagedDatabasePostgresqlNodeStateArgs

    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    Name string
    Name plus a node iteration
    Role string
    Role of the node
    State string
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node
    name string
    Name plus a node iteration
    role string
    Role of the node
    state string
    State of the node
    name str
    Name plus a node iteration
    role str
    Role of the node
    state str
    State of the node
    name String
    Name plus a node iteration
    role String
    Role of the node
    state String
    State of the node

    ManagedDatabasePostgresqlProperties, ManagedDatabasePostgresqlPropertiesArgs

    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    AutovacuumAnalyzeScaleFactor 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).
    AutovacuumAnalyzeThreshold 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.
    AutovacuumFreezeMaxAge int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    AutovacuumMaxWorkers 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.
    AutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute.
    AutovacuumVacuumCostDelay 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.
    AutovacuumVacuumCostLimit 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.
    AutovacuumVacuumScaleFactor 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).
    AutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    BgwriterFlushAfter 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.
    BgwriterLruMaxpages 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.
    BgwriterLruMultiplier 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.
    DeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    DefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    IdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    IpFilters List<string>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    Jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    LogAutovacuumMinDuration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    LogErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    LogLinePrefix string
    Choose from one of the available log formats.
    LogMinDurationStatement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    LogTempFiles int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    MaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    MaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    MaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    MaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    MaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    MaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    MaxPreparedTransactions int
    PostgreSQL maximum prepared transactions.
    MaxReplicationSlots int
    PostgreSQL maximum replication slots.
    MaxSlotWalKeepSize 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.
    MaxStackDepth int
    Maximum depth of the stack in bytes.
    MaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    MaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    MaxWalSenders int
    PostgreSQL maximum WAL senders.
    MaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    Migration UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    PasswordEncryption string
    Chooses the algorithm for encrypting passwords.
    PgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    PgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    PgStatMonitorEnable bool
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    PgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    PgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    PgStatStatementsTrack 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.
    Pgbouncer UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    Pglookout UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SharedBuffersPercentage 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.
    SynchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    TempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    Timescaledb UpCloud.Pulumi.UpCloud.Inputs.ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    Timezone string
    PostgreSQL service timezone.
    TrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    TrackCommitTimestamp string
    Record commit time of transactions.
    TrackFunctions string
    Enables tracking of function call counts and time used.
    TrackIoTiming 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.
    Variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    Version string
    PostgreSQL major version.
    WalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    WalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    WorkMem 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).
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    AutomaticUtilityNetworkIpFilter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    AutovacuumAnalyzeScaleFactor 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).
    AutovacuumAnalyzeThreshold 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.
    AutovacuumFreezeMaxAge int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    AutovacuumMaxWorkers 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.
    AutovacuumNaptime int
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute.
    AutovacuumVacuumCostDelay 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.
    AutovacuumVacuumCostLimit 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.
    AutovacuumVacuumScaleFactor 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).
    AutovacuumVacuumThreshold int
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    BackupHour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    BackupMinute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    BgwriterDelay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    BgwriterFlushAfter 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.
    BgwriterLruMaxpages 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.
    BgwriterLruMultiplier 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.
    DeadlockTimeout int
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    DefaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    IdleInTransactionSessionTimeout int
    Time out sessions with open transactions after this number of milliseconds.
    IpFilters []string
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    Jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    LogAutovacuumMinDuration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    LogErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    LogLinePrefix string
    Choose from one of the available log formats.
    LogMinDurationStatement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    LogTempFiles int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    MaxFilesPerProcess int
    PostgreSQL maximum number of files that can be open per process.
    MaxLocksPerTransaction int
    PostgreSQL maximum locks per transaction.
    MaxLogicalReplicationWorkers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    MaxParallelWorkers int
    Sets the maximum number of workers that the system can support for parallel queries.
    MaxParallelWorkersPerGather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    MaxPredLocksPerTransaction int
    PostgreSQL maximum predicate locks per transaction.
    MaxPreparedTransactions int
    PostgreSQL maximum prepared transactions.
    MaxReplicationSlots int
    PostgreSQL maximum replication slots.
    MaxSlotWalKeepSize 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.
    MaxStackDepth int
    Maximum depth of the stack in bytes.
    MaxStandbyArchiveDelay int
    Max standby archive delay in milliseconds.
    MaxStandbyStreamingDelay int
    Max standby streaming delay in milliseconds.
    MaxWalSenders int
    PostgreSQL maximum WAL senders.
    MaxWorkerProcesses int
    Sets the maximum number of background processes that the system can support.
    Migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    PasswordEncryption string
    Chooses the algorithm for encrypting passwords.
    PgPartmanBgwInterval int
    Sets the time interval to run pg_partman's scheduled tasks.
    PgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    PgStatMonitorEnable bool
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    PgStatMonitorPgsmEnableQueryPlan bool
    Enables or disables query plan monitoring.
    PgStatMonitorPgsmMaxBuckets int
    Sets the maximum number of buckets.
    PgStatStatementsTrack 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.
    Pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    Pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    PublicAccess bool
    Public Access. Allow access to the service from the public Internet.
    ServiceLog bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    SharedBuffersPercentage 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.
    SynchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    TempFileLimit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    Timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    Timezone string
    PostgreSQL service timezone.
    TrackActivityQuerySize int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    TrackCommitTimestamp string
    Record commit time of transactions.
    TrackFunctions string
    Enables tracking of function call counts and time used.
    TrackIoTiming 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.
    Variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    Version string
    PostgreSQL major version.
    WalSenderTimeout int
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    WalWriterDelay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    WorkMem 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).
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor 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).
    autovacuumAnalyzeThreshold 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.
    autovacuumFreezeMaxAge Integer
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    autovacuumMaxWorkers 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.
    autovacuumNaptime Integer
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute.
    autovacuumVacuumCostDelay 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.
    autovacuumVacuumCostLimit 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.
    autovacuumVacuumScaleFactor 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).
    autovacuumVacuumThreshold Integer
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    backupHour Integer
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Integer
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay Integer
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    bgwriterFlushAfter 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.
    bgwriterLruMaxpages 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.
    bgwriterLruMultiplier 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.
    deadlockTimeout Integer
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    defaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    idleInTransactionSessionTimeout Integer
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration Integer
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    logErrorVerbosity String
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix String
    Choose from one of the available log formats.
    logMinDurationStatement Integer
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles Integer
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxFilesPerProcess Integer
    PostgreSQL maximum number of files that can be open per process.
    maxLocksPerTransaction Integer
    PostgreSQL maximum locks per transaction.
    maxLogicalReplicationWorkers Integer
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    maxParallelWorkers Integer
    Sets the maximum number of workers that the system can support for parallel queries.
    maxParallelWorkersPerGather Integer
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    maxPredLocksPerTransaction Integer
    PostgreSQL maximum predicate locks per transaction.
    maxPreparedTransactions Integer
    PostgreSQL maximum prepared transactions.
    maxReplicationSlots Integer
    PostgreSQL maximum replication slots.
    maxSlotWalKeepSize 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.
    maxStackDepth Integer
    Maximum depth of the stack in bytes.
    maxStandbyArchiveDelay Integer
    Max standby archive delay in milliseconds.
    maxStandbyStreamingDelay Integer
    Max standby streaming delay in milliseconds.
    maxWalSenders Integer
    PostgreSQL maximum WAL senders.
    maxWorkerProcesses Integer
    Sets the maximum number of background processes that the system can support.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    passwordEncryption String
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval Integer
    Sets the time interval to run pg_partman's scheduled tasks.
    pgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable Boolean
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    pgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    pgStatMonitorPgsmMaxBuckets Integer
    Sets the maximum number of buckets.
    pgStatStatementsTrack 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.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage 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.
    synchronousReplication String
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit Integer
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone String
    PostgreSQL service timezone.
    trackActivityQuerySize Integer
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    trackCommitTimestamp String
    Record commit time of transactions.
    trackFunctions String
    Enables tracking of function call counts and time used.
    trackIoTiming 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.
    variant String
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version String
    PostgreSQL major version.
    walSenderTimeout Integer
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay Integer
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    workMem 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).
    adminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor 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).
    autovacuumAnalyzeThreshold 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.
    autovacuumFreezeMaxAge number
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    autovacuumMaxWorkers 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.
    autovacuumNaptime number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute.
    autovacuumVacuumCostDelay 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.
    autovacuumVacuumCostLimit 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.
    autovacuumVacuumScaleFactor 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).
    autovacuumVacuumThreshold number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    backupHour number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    bgwriterFlushAfter 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.
    bgwriterLruMaxpages 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.
    bgwriterLruMultiplier 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.
    deadlockTimeout number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    defaultToastCompression string
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    idleInTransactionSessionTimeout number
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters string[]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration number
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    logErrorVerbosity string
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix string
    Choose from one of the available log formats.
    logMinDurationStatement number
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles number
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxFilesPerProcess number
    PostgreSQL maximum number of files that can be open per process.
    maxLocksPerTransaction number
    PostgreSQL maximum locks per transaction.
    maxLogicalReplicationWorkers number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    maxParallelWorkers number
    Sets the maximum number of workers that the system can support for parallel queries.
    maxParallelWorkersPerGather number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    maxPredLocksPerTransaction number
    PostgreSQL maximum predicate locks per transaction.
    maxPreparedTransactions number
    PostgreSQL maximum prepared transactions.
    maxReplicationSlots number
    PostgreSQL maximum replication slots.
    maxSlotWalKeepSize 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.
    maxStackDepth number
    Maximum depth of the stack in bytes.
    maxStandbyArchiveDelay number
    Max standby archive delay in milliseconds.
    maxStandbyStreamingDelay number
    Max standby streaming delay in milliseconds.
    maxWalSenders number
    PostgreSQL maximum WAL senders.
    maxWorkerProcesses number
    Sets the maximum number of background processes that the system can support.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    passwordEncryption string
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval number
    Sets the time interval to run pg_partman's scheduled tasks.
    pgPartmanBgwRole string
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable boolean
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    pgStatMonitorPgsmEnableQueryPlan boolean
    Enables or disables query plan monitoring.
    pgStatMonitorPgsmMaxBuckets number
    Sets the maximum number of buckets.
    pgStatStatementsTrack 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.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    publicAccess boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage 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.
    synchronousReplication string
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone string
    PostgreSQL service timezone.
    trackActivityQuerySize number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    trackCommitTimestamp string
    Record commit time of transactions.
    trackFunctions string
    Enables tracking of function call counts and time used.
    trackIoTiming 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.
    variant string
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version string
    PostgreSQL major version.
    walSenderTimeout number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    workMem 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).
    admin_password str
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    admin_username str
    Custom username for admin user. This must be set only when a new service is being created.
    automatic_utility_network_ip_filter bool
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    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).
    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.
    autovacuum_freeze_max_age int
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    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.
    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.
    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.
    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.
    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).
    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.
    backup_hour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backup_minute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriter_delay int
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    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.
    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.
    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.
    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.
    default_toast_compression str
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    idle_in_transaction_session_timeout int
    Time out sessions with open transactions after this number of milliseconds.
    ip_filters Sequence[str]
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit bool
    Controls system-wide use of Just-in-Time Compilation (JIT).
    log_autovacuum_min_duration int
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    log_error_verbosity str
    Controls the amount of detail written in the server log for each message that is logged.
    log_line_prefix str
    Choose from one of the available log formats.
    log_min_duration_statement int
    Log statements that take more than this number of milliseconds to run, -1 disables.
    log_temp_files int
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    max_files_per_process int
    PostgreSQL maximum number of files that can be open per process.
    max_locks_per_transaction int
    PostgreSQL maximum locks per transaction.
    max_logical_replication_workers int
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    max_parallel_workers int
    Sets the maximum number of workers that the system can support for parallel queries.
    max_parallel_workers_per_gather int
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    max_pred_locks_per_transaction int
    PostgreSQL maximum predicate locks per transaction.
    max_prepared_transactions int
    PostgreSQL maximum prepared transactions.
    max_replication_slots int
    PostgreSQL maximum replication slots.
    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.
    max_stack_depth int
    Maximum depth of the stack in bytes.
    max_standby_archive_delay int
    Max standby archive delay in milliseconds.
    max_standby_streaming_delay int
    Max standby streaming delay in milliseconds.
    max_wal_senders int
    PostgreSQL maximum WAL senders.
    max_worker_processes int
    Sets the maximum number of background processes that the system can support.
    migration ManagedDatabasePostgresqlPropertiesMigration
    Migrate data from existing server.
    password_encryption str
    Chooses the algorithm for encrypting passwords.
    pg_partman_bgw_interval int
    Sets the time interval to run pg_partman's scheduled tasks.
    pg_partman_bgw_role str
    Controls which role to use for pg_partman's scheduled background tasks.
    pg_stat_monitor_enable bool
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    pg_stat_monitor_pgsm_enable_query_plan bool
    Enables or disables query plan monitoring.
    pg_stat_monitor_pgsm_max_buckets int
    Sets the maximum number of buckets.
    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.
    pgbouncer ManagedDatabasePostgresqlPropertiesPgbouncer
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout ManagedDatabasePostgresqlPropertiesPglookout
    PGLookout settings. System-wide settings for pglookout.
    public_access bool
    Public Access. Allow access to the service from the public Internet.
    service_log bool
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    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.
    synchronous_replication str
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    temp_file_limit int
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb ManagedDatabasePostgresqlPropertiesTimescaledb
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone str
    PostgreSQL service timezone.
    track_activity_query_size int
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    track_commit_timestamp str
    Record commit time of transactions.
    track_functions str
    Enables tracking of function call counts and time used.
    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.
    variant str
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version str
    PostgreSQL major version.
    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.
    wal_writer_delay int
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    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).
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    automaticUtilityNetworkIpFilter Boolean
    Automatic utility network IP Filter. Automatically allow connections from servers in the utility network within the same zone.
    autovacuumAnalyzeScaleFactor 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).
    autovacuumAnalyzeThreshold 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.
    autovacuumFreezeMaxAge Number
    Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled. This parameter will cause the server to be restarted.
    autovacuumMaxWorkers 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.
    autovacuumNaptime Number
    Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute.
    autovacuumVacuumCostDelay 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.
    autovacuumVacuumCostLimit 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.
    autovacuumVacuumScaleFactor 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).
    autovacuumVacuumThreshold Number
    Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
    backupHour Number
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
    backupMinute Number
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
    bgwriterDelay Number
    Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.
    bgwriterFlushAfter 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.
    bgwriterLruMaxpages 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.
    bgwriterLruMultiplier 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.
    deadlockTimeout Number
    This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
    defaultToastCompression String
    Specifies the default TOAST compression method for values of compressible columns (the default is lz4).
    idleInTransactionSessionTimeout Number
    Time out sessions with open transactions after this number of milliseconds.
    ipFilters List<String>
    IP filter. Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    jit Boolean
    Controls system-wide use of Just-in-Time Compilation (JIT).
    logAutovacuumMinDuration Number
    Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero logs all autovacuum actions. Minus-one (the default) disables logging autovacuum actions.
    logErrorVerbosity String
    Controls the amount of detail written in the server log for each message that is logged.
    logLinePrefix String
    Choose from one of the available log formats.
    logMinDurationStatement Number
    Log statements that take more than this number of milliseconds to run, -1 disables.
    logTempFiles Number
    Log statements for each temporary file created larger than this number of kilobytes, -1 disables.
    maxFilesPerProcess Number
    PostgreSQL maximum number of files that can be open per process.
    maxLocksPerTransaction Number
    PostgreSQL maximum locks per transaction.
    maxLogicalReplicationWorkers Number
    PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
    maxParallelWorkers Number
    Sets the maximum number of workers that the system can support for parallel queries.
    maxParallelWorkersPerGather Number
    Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
    maxPredLocksPerTransaction Number
    PostgreSQL maximum predicate locks per transaction.
    maxPreparedTransactions Number
    PostgreSQL maximum prepared transactions.
    maxReplicationSlots Number
    PostgreSQL maximum replication slots.
    maxSlotWalKeepSize 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.
    maxStackDepth Number
    Maximum depth of the stack in bytes.
    maxStandbyArchiveDelay Number
    Max standby archive delay in milliseconds.
    maxStandbyStreamingDelay Number
    Max standby streaming delay in milliseconds.
    maxWalSenders Number
    PostgreSQL maximum WAL senders.
    maxWorkerProcesses Number
    Sets the maximum number of background processes that the system can support.
    migration Property Map
    Migrate data from existing server.
    passwordEncryption String
    Chooses the algorithm for encrypting passwords.
    pgPartmanBgwInterval Number
    Sets the time interval to run pg_partman's scheduled tasks.
    pgPartmanBgwRole String
    Controls which role to use for pg_partman's scheduled background tasks.
    pgStatMonitorEnable Boolean
    Enable pg_stat_monitor extension if available for the current cluster. 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.
    pgStatMonitorPgsmEnableQueryPlan Boolean
    Enables or disables query plan monitoring.
    pgStatMonitorPgsmMaxBuckets Number
    Sets the maximum number of buckets.
    pgStatStatementsTrack 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.
    pgbouncer Property Map
    PGBouncer connection pooling settings. System-wide settings for pgbouncer.
    pglookout Property Map
    PGLookout settings. System-wide settings for pglookout.
    publicAccess Boolean
    Public Access. Allow access to the service from the public Internet.
    serviceLog Boolean
    Service logging. Store logs for the service so that they are available in the HTTP API and console.
    sharedBuffersPercentage 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.
    synchronousReplication String
    Synchronous replication type. Note that the service plan also needs to support synchronous replication.
    tempFileLimit Number
    PostgreSQL temporary file limit in KiB, -1 for unlimited.
    timescaledb Property Map
    TimescaleDB extension configuration values. System-wide settings for the timescaledb extension.
    timezone String
    PostgreSQL service timezone.
    trackActivityQuerySize Number
    Specifies the number of bytes reserved to track the currently executing command for each active session.
    trackCommitTimestamp String
    Record commit time of transactions.
    trackFunctions String
    Enables tracking of function call counts and time used.
    trackIoTiming 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.
    variant String
    Variant of the PostgreSQL service, may affect the features that are exposed by default.
    version String
    PostgreSQL major version.
    walSenderTimeout Number
    Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.
    walWriterDelay Number
    WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.
    workMem 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).

    ManagedDatabasePostgresqlPropertiesMigration, ManagedDatabasePostgresqlPropertiesMigrationArgs

    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    Dbname string
    Database name for bootstrapping the initial connection.
    Host string
    Hostname or IP address of the server where to migrate data from.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    IgnoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    Method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Ssl bool
    The server where to migrate data from is secured with SSL.
    Username string
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Integer
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.
    dbname string
    Database name for bootstrapping the initial connection.
    host string
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles string
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method string
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password string
    Password for authentication with the server where to migrate data from.
    port number
    Port number of the server where to migrate data from.
    ssl boolean
    The server where to migrate data from is secured with SSL.
    username string
    User name for authentication with the server where to migrate data from.
    dbname str
    Database name for bootstrapping the initial connection.
    host str
    Hostname or IP address of the server where to migrate data from.
    ignore_dbs str
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignore_roles str
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method str
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password str
    Password for authentication with the server where to migrate data from.
    port int
    Port number of the server where to migrate data from.
    ssl bool
    The server where to migrate data from is secured with SSL.
    username str
    User name for authentication with the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    host String
    Hostname or IP address of the server where to migrate data from.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    ignoreRoles String
    Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment).
    method String
    The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from.
    port Number
    Port number of the server where to migrate data from.
    ssl Boolean
    The server where to migrate data from is secured with SSL.
    username String
    User name for authentication with the server where to migrate data from.

    ManagedDatabasePostgresqlPropertiesPgbouncer, ManagedDatabasePostgresqlPropertiesPgbouncerArgs

    AutodbIdleTimeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    AutodbMaxDbConnections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    AutodbPoolMode string
    PGBouncer pool mode.
    AutodbPoolSize int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    IgnoreStartupParameters List<string>
    List of parameters to ignore when given in startup packet.
    MaxPreparedStatements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    MinPoolSize int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    ServerIdleTimeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    ServerLifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    ServerResetQueryAlways bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    AutodbIdleTimeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    AutodbMaxDbConnections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    AutodbPoolMode string
    PGBouncer pool mode.
    AutodbPoolSize int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    IgnoreStartupParameters []string
    List of parameters to ignore when given in startup packet.
    MaxPreparedStatements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    MinPoolSize int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    ServerIdleTimeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    ServerLifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    ServerResetQueryAlways bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout Integer
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections Integer
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode String
    PGBouncer pool mode.
    autodbPoolSize Integer
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters List<String>
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements Integer
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize Integer
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout Integer
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime Integer
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways Boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout number
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections number
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode string
    PGBouncer pool mode.
    autodbPoolSize number
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters string[]
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements number
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize number
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout number
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime number
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodb_idle_timeout int
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodb_max_db_connections int
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodb_pool_mode str
    PGBouncer pool mode.
    autodb_pool_size int
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignore_startup_parameters Sequence[str]
    List of parameters to ignore when given in startup packet.
    max_prepared_statements int
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    min_pool_size int
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    server_idle_timeout int
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    server_lifetime int
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    server_reset_query_always bool
    Run server_reset_query (DISCARD ALL) in all pooling modes.
    autodbIdleTimeout Number
    If the automatically created database pools have been unused this many seconds, they are freed. If 0 then timeout is disabled. [seconds].
    autodbMaxDbConnections Number
    Do not allow more than this many server connections per database (regardless of user). Setting it to 0 means unlimited.
    autodbPoolMode String
    PGBouncer pool mode.
    autodbPoolSize Number
    If non-zero then create automatically a pool of that size per user when a pool doesn't exist.
    ignoreStartupParameters List<String>
    List of parameters to ignore when given in startup packet.
    maxPreparedStatements Number
    PgBouncer tracks protocol-level named prepared statements related commands sent by the client in transaction and statement pooling modes when max_prepared_statements is set to a non-zero value. Setting it to 0 disables prepared statements. max_prepared_statements defaults to 100, and its maximum is 3000.
    minPoolSize Number
    Add more server connections to pool if below this number. Improves behavior when usual load comes suddenly back after period of total inactivity. The value is effectively capped at the pool size.
    serverIdleTimeout Number
    If a server connection has been idle more than this many seconds it will be dropped. If 0 then timeout is disabled. [seconds].
    serverLifetime Number
    The pooler will close an unused server connection that has been connected longer than this. [seconds].
    serverResetQueryAlways Boolean
    Run server_reset_query (DISCARD ALL) in all pooling modes.

    ManagedDatabasePostgresqlPropertiesPglookout, ManagedDatabasePostgresqlPropertiesPglookoutArgs

    MaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby.
    MaxFailoverReplicationTimeLag int
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag Integer
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag number
    Number of seconds of master unavailability before triggering database failover to standby.
    max_failover_replication_time_lag int
    Number of seconds of master unavailability before triggering database failover to standby.
    maxFailoverReplicationTimeLag Number
    Number of seconds of master unavailability before triggering database failover to standby.

    ManagedDatabasePostgresqlPropertiesTimescaledb, ManagedDatabasePostgresqlPropertiesTimescaledbArgs

    MaxBackgroundWorkers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.
    MaxBackgroundWorkers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.
    maxBackgroundWorkers Integer
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.
    maxBackgroundWorkers number
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.
    max_background_workers int
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.
    maxBackgroundWorkers Number
    The number of background workers for timescaledb operations. You should configure this setting to the sum of your number of databases and the total number of concurrent background workers you want running at any given point in time.

    Package Details

    Repository
    upcloud UpCloudLtd/pulumi-upcloud
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the upcloud Terraform Provider.
    upcloud logo
    UpCloud v0.1.0 published on Friday, Mar 14, 2025 by UpCloudLtd
    UpCloudLtd/pulumi-upcloud