Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
@file:Suppress("NAME_SHADOWING", "DEPRECATION")
package com.pulumi.digitalocean.kotlin
import com.pulumi.core.Output
import com.pulumi.core.Output.of
import com.pulumi.digitalocean.DatabasePostgresqlConfigArgs.builder
import com.pulumi.digitalocean.kotlin.inputs.DatabasePostgresqlConfigPgbouncerArgs
import com.pulumi.digitalocean.kotlin.inputs.DatabasePostgresqlConfigPgbouncerArgsBuilder
import com.pulumi.digitalocean.kotlin.inputs.DatabasePostgresqlConfigTimescaledbArgs
import com.pulumi.digitalocean.kotlin.inputs.DatabasePostgresqlConfigTimescaledbArgsBuilder
import com.pulumi.kotlin.ConvertibleToJava
import com.pulumi.kotlin.PulumiTagMarker
import com.pulumi.kotlin.applySuspend
import kotlin.Boolean
import kotlin.Double
import kotlin.Int
import kotlin.String
import kotlin.Suppress
import kotlin.Unit
import kotlin.collections.List
import kotlin.jvm.JvmName
/**
* Provides a virtual resource that can be used to change advanced configuration
* options for a DigitalOcean managed PostgreSQL database cluster.
* > **Note** PostgreSQL configurations are only removed from state when destroyed. The remote configuration is not unset.
* ## Example Usage
*
* ```typescript
* import * as pulumi from "@pulumi/pulumi";
* import * as digitalocean from "@pulumi/digitalocean";
* const exampleDatabaseCluster = new digitalocean.DatabaseCluster("example", {
* name: "example-postgresql-cluster",
* engine: "pg",
* version: "15",
* size: digitalocean.DatabaseSlug.DB_1VPCU1GB,
* region: digitalocean.Region.NYC1,
* nodeCount: 1,
* });
* const example = new digitalocean.DatabasePostgresqlConfig("example", {
* clusterId: exampleDatabaseCluster.id,
* timezone: "UTC",
* workMem: 16,
* });
* ```
* ```python
* import pulumi
* import pulumi_digitalocean as digitalocean
* example_database_cluster = digitalocean.DatabaseCluster("example",
* name="example-postgresql-cluster",
* engine="pg",
* version="15",
* size=digitalocean.DatabaseSlug.D_B_1_VPCU1_GB,
* region=digitalocean.Region.NYC1,
* node_count=1)
* example = digitalocean.DatabasePostgresqlConfig("example",
* cluster_id=example_database_cluster.id,
* timezone="UTC",
* work_mem=16)
* ```
* ```csharp
* using System.Collections.Generic;
* using System.Linq;
* using Pulumi;
* using DigitalOcean = Pulumi.DigitalOcean;
* return await Deployment.RunAsync(() =>
* {
* var exampleDatabaseCluster = new DigitalOcean.DatabaseCluster("example", new()
* {
* Name = "example-postgresql-cluster",
* Engine = "pg",
* Version = "15",
* Size = DigitalOcean.DatabaseSlug.DB_1VPCU1GB,
* Region = DigitalOcean.Region.NYC1,
* NodeCount = 1,
* });
* var example = new DigitalOcean.DatabasePostgresqlConfig("example", new()
* {
* ClusterId = exampleDatabaseCluster.Id,
* Timezone = "UTC",
* WorkMem = 16,
* });
* });
* ```
* ```go
* package main
* import (
* "github.com/pulumi/pulumi-digitalocean/sdk/v4/go/digitalocean"
* "github.com/pulumi/pulumi/sdk/v3/go/pulumi"
* )
* func main() {
* pulumi.Run(func(ctx *pulumi.Context) error {
* exampleDatabaseCluster, err := digitalocean.NewDatabaseCluster(ctx, "example", &digitalocean.DatabaseClusterArgs{
* Name: pulumi.String("example-postgresql-cluster"),
* Engine: pulumi.String("pg"),
* Version: pulumi.String("15"),
* Size: pulumi.String(digitalocean.DatabaseSlug_DB_1VPCU1GB),
* Region: pulumi.String(digitalocean.RegionNYC1),
* NodeCount: pulumi.Int(1),
* })
* if err != nil {
* return err
* }
* _, err = digitalocean.NewDatabasePostgresqlConfig(ctx, "example", &digitalocean.DatabasePostgresqlConfigArgs{
* ClusterId: exampleDatabaseCluster.ID(),
* Timezone: pulumi.String("UTC"),
* WorkMem: pulumi.Int(16),
* })
* if err != nil {
* return err
* }
* return nil
* })
* }
* ```
* ```java
* package generated_program;
* import com.pulumi.Context;
* import com.pulumi.Pulumi;
* import com.pulumi.core.Output;
* import com.pulumi.digitalocean.DatabaseCluster;
* import com.pulumi.digitalocean.DatabaseClusterArgs;
* import com.pulumi.digitalocean.DatabasePostgresqlConfig;
* import com.pulumi.digitalocean.DatabasePostgresqlConfigArgs;
* import java.util.List;
* import java.util.ArrayList;
* import java.util.Map;
* import java.io.File;
* import java.nio.file.Files;
* import java.nio.file.Paths;
* public class App {
* public static void main(String[] args) {
* Pulumi.run(App::stack);
* }
* public static void stack(Context ctx) {
* var exampleDatabaseCluster = new DatabaseCluster("exampleDatabaseCluster", DatabaseClusterArgs.builder()
* .name("example-postgresql-cluster")
* .engine("pg")
* .version("15")
* .size("db-s-1vcpu-1gb")
* .region("nyc1")
* .nodeCount(1)
* .build());
* var example = new DatabasePostgresqlConfig("example", DatabasePostgresqlConfigArgs.builder()
* .clusterId(exampleDatabaseCluster.id())
* .timezone("UTC")
* .workMem(16)
* .build());
* }
* }
* ```
* ```yaml
* resources:
* example:
* type: digitalocean:DatabasePostgresqlConfig
* properties:
* clusterId: ${exampleDatabaseCluster.id}
* timezone: UTC
* workMem: 16
* exampleDatabaseCluster:
* type: digitalocean:DatabaseCluster
* name: example
* properties:
* name: example-postgresql-cluster
* engine: pg
* version: '15'
* size: db-s-1vcpu-1gb
* region: nyc1
* nodeCount: 1
* ```
*
* ## Import
* A PostgreSQL database cluster's configuration can be imported using the `id` the parent cluster, e.g.
* bash
* ```sh
* $ pulumi import digitalocean:index/databasePostgresqlConfig:DatabasePostgresqlConfig example 52556c07-788e-4d41-b8a7-c796432197d1
* ```
* @property autovacuumAnalyzeScaleFactor Specifies a fraction, in a decimal value, 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).
* @property autovacuumAnalyzeThreshold Specifies the minimum number of inserted, updated, or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
* @property autovacuumFreezeMaxAge 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.
* @property autovacuumMaxWorkers 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.
* @property autovacuumNaptime Specifies the minimum delay, in seconds, between autovacuum runs on any given database. The default is one minute.
* @property autovacuumVacuumCostDelay Specifies the cost delay value, in milliseconds, that will be used in automatic VACUUM operations. If -1, uses the regular vacuum_cost_delay value, which is 20 milliseconds.
* @property autovacuumVacuumCostLimit 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.
* @property autovacuumVacuumScaleFactor Specifies a fraction, in a decimal value, 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).
* @property autovacuumVacuumThreshold Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
* @property backupHour The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
* @property backupMinute The minute of the backup hour when backup for the service starts. New backup is only started if previous backup has already completed.
* @property bgwriterDelay Specifies the delay, in milliseconds, between activity rounds for the background writer. Default is 200 ms.
* @property bgwriterFlushAfter The amount of kilobytes that need to be written by the background writer before attempting to force the OS to issue these writes to underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
* @property bgwriterLruMaxpages The maximum number of buffers that the background writer can write. Setting this to zero disables background writing. Default is 100.
* @property bgwriterLruMultiplier 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.
* @property clusterId The ID of the target PostgreSQL cluster.
* @property deadlockTimeout The amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
* @property defaultToastCompression Specifies the default TOAST compression method for values of compressible columns (the default is lz4). Supported values are: `lz4`, `pglz`.
* @property idleInTransactionSessionTimeout Time out sessions with open transactions after this number of milliseconds
* @property jit Activates, in a boolean, the system-wide use of Just-in-Time Compilation (JIT).
* @property logAutovacuumMinDuration 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.
* @property logErrorVerbosity Controls the amount of detail written in the server log for each message that is logged. Supported values are: `TERSE`, `DEFAULT`, `VERBOSE`.
* @property logLinePrefix Selects one of the available log-formats. These can support popular log analyzers like pgbadger, pganalyze, etc. Supported values are: `pid=%p,user=%u,db=%d,app=%a,client=%h`, `%m [%p] %q[user=%u,db=%d,app=%a]`, `%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h`.
* @property logMinDurationStatement Log statements that take more than this number of milliseconds to run. If -1, disables.
* @property maxFilesPerProcess PostgreSQL maximum number of files that can be open per process.
* @property maxLocksPerTransaction PostgreSQL maximum locks per transaction. Once increased, this parameter cannot be lowered from its set value.
* @property maxLogicalReplicationWorkers PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
* @property maxParallelWorkers Sets the maximum number of workers that the system can support for parallel queries.
* @property maxParallelWorkersPerGather Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
* @property maxPredLocksPerTransaction PostgreSQL maximum predicate locks per transaction.
* @property maxPreparedTransactions PostgreSQL maximum prepared transactions. Once increased, this parameter cannot be lowered from its set value.
* @property maxReplicationSlots PostgreSQL maximum replication slots.
* @property maxStackDepth Maximum depth of the stack in bytes.
* @property maxStandbyArchiveDelay Max standby archive delay in milliseconds.
* @property maxStandbyStreamingDelay Max standby streaming delay in milliseconds.
* @property maxWalSenders PostgreSQL maximum WAL senders. Once increased, this parameter cannot be lowered from its set value.
* @property maxWorkerProcesses Sets the maximum number of background processes that the system can support. Once increased, this parameter cannot be lowered from its set value.
* @property pgPartmanBgwInterval Sets the time interval to run pg_partman's scheduled tasks.
* @property pgPartmanBgwRole Controls which role to use for pg_partman's scheduled background tasks. Must consist of alpha-numeric characters, dots, underscores, or dashes. May not start with dash or dot. Maximum of 64 characters.
* @property pgStatStatementsTrack 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. Supported values are: `all`, `top`, `none`.
* @property pgbouncers PGBouncer connection pooling settings
* @property sharedBuffersPercentage 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.
* @property tempFileLimit PostgreSQL temporary file limit in KiB. If -1, sets to unlimited.
* @property timescaledbs TimescaleDB extension configuration values
* @property timezone PostgreSQL service timezone
* @property trackActivityQuerySize Specifies the number of bytes reserved to track the currently executing command for each active session.
* @property trackCommitTimestamp Record commit time of transactions. The default value is top. Supported values are: `off`, `on`.
* @property trackFunctions Enables tracking of function call counts and time used. The default value is top. Supported values are: `all`, `pl`, `none`.
* @property trackIoTiming 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. The default value is top. Supported values are: `off`, `on`.
* @property walSenderTimeout Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout. Must be either 0 or between 5000 and 10800000.
* @property walWriterDelay WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance
* @property workMem The maximum amount of memory, in MB, used by a query operation (such as a sort or hash table) before writing to temporary disk files. Default is 1MB + 0.075% of total RAM (up to 32MB).
*/
public data class DatabasePostgresqlConfigArgs(
public val autovacuumAnalyzeScaleFactor: Output? = null,
public val autovacuumAnalyzeThreshold: Output? = null,
public val autovacuumFreezeMaxAge: Output? = null,
public val autovacuumMaxWorkers: Output? = null,
public val autovacuumNaptime: Output? = null,
public val autovacuumVacuumCostDelay: Output? = null,
public val autovacuumVacuumCostLimit: Output? = null,
public val autovacuumVacuumScaleFactor: Output? = null,
public val autovacuumVacuumThreshold: Output? = null,
public val backupHour: Output? = null,
public val backupMinute: Output? = null,
public val bgwriterDelay: Output? = null,
public val bgwriterFlushAfter: Output? = null,
public val bgwriterLruMaxpages: Output? = null,
public val bgwriterLruMultiplier: Output? = null,
public val clusterId: Output? = null,
public val deadlockTimeout: Output? = null,
public val defaultToastCompression: Output? = null,
public val idleInTransactionSessionTimeout: Output? = null,
public val jit: Output? = null,
public val logAutovacuumMinDuration: Output? = null,
public val logErrorVerbosity: Output? = null,
public val logLinePrefix: Output? = null,
public val logMinDurationStatement: Output? = null,
public val maxFilesPerProcess: Output? = null,
public val maxLocksPerTransaction: Output? = null,
public val maxLogicalReplicationWorkers: Output? = null,
public val maxParallelWorkers: Output? = null,
public val maxParallelWorkersPerGather: Output? = null,
public val maxPredLocksPerTransaction: Output? = null,
public val maxPreparedTransactions: Output? = null,
public val maxReplicationSlots: Output? = null,
public val maxStackDepth: Output? = null,
public val maxStandbyArchiveDelay: Output? = null,
public val maxStandbyStreamingDelay: Output? = null,
public val maxWalSenders: Output? = null,
public val maxWorkerProcesses: Output? = null,
public val pgPartmanBgwInterval: Output? = null,
public val pgPartmanBgwRole: Output? = null,
public val pgStatStatementsTrack: Output? = null,
public val pgbouncers: Output>? = null,
public val sharedBuffersPercentage: Output? = null,
public val tempFileLimit: Output? = null,
public val timescaledbs: Output>? = null,
public val timezone: Output? = null,
public val trackActivityQuerySize: Output? = null,
public val trackCommitTimestamp: Output? = null,
public val trackFunctions: Output? = null,
public val trackIoTiming: Output? = null,
public val walSenderTimeout: Output? = null,
public val walWriterDelay: Output? = null,
public val workMem: Output? = null,
) : ConvertibleToJava {
override fun toJava(): com.pulumi.digitalocean.DatabasePostgresqlConfigArgs =
com.pulumi.digitalocean.DatabasePostgresqlConfigArgs.builder()
.autovacuumAnalyzeScaleFactor(autovacuumAnalyzeScaleFactor?.applyValue({ args0 -> args0 }))
.autovacuumAnalyzeThreshold(autovacuumAnalyzeThreshold?.applyValue({ args0 -> args0 }))
.autovacuumFreezeMaxAge(autovacuumFreezeMaxAge?.applyValue({ args0 -> args0 }))
.autovacuumMaxWorkers(autovacuumMaxWorkers?.applyValue({ args0 -> args0 }))
.autovacuumNaptime(autovacuumNaptime?.applyValue({ args0 -> args0 }))
.autovacuumVacuumCostDelay(autovacuumVacuumCostDelay?.applyValue({ args0 -> args0 }))
.autovacuumVacuumCostLimit(autovacuumVacuumCostLimit?.applyValue({ args0 -> args0 }))
.autovacuumVacuumScaleFactor(autovacuumVacuumScaleFactor?.applyValue({ args0 -> args0 }))
.autovacuumVacuumThreshold(autovacuumVacuumThreshold?.applyValue({ args0 -> args0 }))
.backupHour(backupHour?.applyValue({ args0 -> args0 }))
.backupMinute(backupMinute?.applyValue({ args0 -> args0 }))
.bgwriterDelay(bgwriterDelay?.applyValue({ args0 -> args0 }))
.bgwriterFlushAfter(bgwriterFlushAfter?.applyValue({ args0 -> args0 }))
.bgwriterLruMaxpages(bgwriterLruMaxpages?.applyValue({ args0 -> args0 }))
.bgwriterLruMultiplier(bgwriterLruMultiplier?.applyValue({ args0 -> args0 }))
.clusterId(clusterId?.applyValue({ args0 -> args0 }))
.deadlockTimeout(deadlockTimeout?.applyValue({ args0 -> args0 }))
.defaultToastCompression(defaultToastCompression?.applyValue({ args0 -> args0 }))
.idleInTransactionSessionTimeout(idleInTransactionSessionTimeout?.applyValue({ args0 -> args0 }))
.jit(jit?.applyValue({ args0 -> args0 }))
.logAutovacuumMinDuration(logAutovacuumMinDuration?.applyValue({ args0 -> args0 }))
.logErrorVerbosity(logErrorVerbosity?.applyValue({ args0 -> args0 }))
.logLinePrefix(logLinePrefix?.applyValue({ args0 -> args0 }))
.logMinDurationStatement(logMinDurationStatement?.applyValue({ args0 -> args0 }))
.maxFilesPerProcess(maxFilesPerProcess?.applyValue({ args0 -> args0 }))
.maxLocksPerTransaction(maxLocksPerTransaction?.applyValue({ args0 -> args0 }))
.maxLogicalReplicationWorkers(maxLogicalReplicationWorkers?.applyValue({ args0 -> args0 }))
.maxParallelWorkers(maxParallelWorkers?.applyValue({ args0 -> args0 }))
.maxParallelWorkersPerGather(maxParallelWorkersPerGather?.applyValue({ args0 -> args0 }))
.maxPredLocksPerTransaction(maxPredLocksPerTransaction?.applyValue({ args0 -> args0 }))
.maxPreparedTransactions(maxPreparedTransactions?.applyValue({ args0 -> args0 }))
.maxReplicationSlots(maxReplicationSlots?.applyValue({ args0 -> args0 }))
.maxStackDepth(maxStackDepth?.applyValue({ args0 -> args0 }))
.maxStandbyArchiveDelay(maxStandbyArchiveDelay?.applyValue({ args0 -> args0 }))
.maxStandbyStreamingDelay(maxStandbyStreamingDelay?.applyValue({ args0 -> args0 }))
.maxWalSenders(maxWalSenders?.applyValue({ args0 -> args0 }))
.maxWorkerProcesses(maxWorkerProcesses?.applyValue({ args0 -> args0 }))
.pgPartmanBgwInterval(pgPartmanBgwInterval?.applyValue({ args0 -> args0 }))
.pgPartmanBgwRole(pgPartmanBgwRole?.applyValue({ args0 -> args0 }))
.pgStatStatementsTrack(pgStatStatementsTrack?.applyValue({ args0 -> args0 }))
.pgbouncers(
pgbouncers?.applyValue({ args0 ->
args0.map({ args0 ->
args0.let({ args0 ->
args0.toJava()
})
})
}),
)
.sharedBuffersPercentage(sharedBuffersPercentage?.applyValue({ args0 -> args0 }))
.tempFileLimit(tempFileLimit?.applyValue({ args0 -> args0 }))
.timescaledbs(
timescaledbs?.applyValue({ args0 ->
args0.map({ args0 ->
args0.let({ args0 ->
args0.toJava()
})
})
}),
)
.timezone(timezone?.applyValue({ args0 -> args0 }))
.trackActivityQuerySize(trackActivityQuerySize?.applyValue({ args0 -> args0 }))
.trackCommitTimestamp(trackCommitTimestamp?.applyValue({ args0 -> args0 }))
.trackFunctions(trackFunctions?.applyValue({ args0 -> args0 }))
.trackIoTiming(trackIoTiming?.applyValue({ args0 -> args0 }))
.walSenderTimeout(walSenderTimeout?.applyValue({ args0 -> args0 }))
.walWriterDelay(walWriterDelay?.applyValue({ args0 -> args0 }))
.workMem(workMem?.applyValue({ args0 -> args0 })).build()
}
/**
* Builder for [DatabasePostgresqlConfigArgs].
*/
@PulumiTagMarker
public class DatabasePostgresqlConfigArgsBuilder internal constructor() {
private var autovacuumAnalyzeScaleFactor: Output? = null
private var autovacuumAnalyzeThreshold: Output? = null
private var autovacuumFreezeMaxAge: Output? = null
private var autovacuumMaxWorkers: Output? = null
private var autovacuumNaptime: Output? = null
private var autovacuumVacuumCostDelay: Output? = null
private var autovacuumVacuumCostLimit: Output? = null
private var autovacuumVacuumScaleFactor: Output? = null
private var autovacuumVacuumThreshold: Output? = null
private var backupHour: Output? = null
private var backupMinute: Output? = null
private var bgwriterDelay: Output? = null
private var bgwriterFlushAfter: Output? = null
private var bgwriterLruMaxpages: Output? = null
private var bgwriterLruMultiplier: Output? = null
private var clusterId: Output? = null
private var deadlockTimeout: Output? = null
private var defaultToastCompression: Output? = null
private var idleInTransactionSessionTimeout: Output? = null
private var jit: Output? = null
private var logAutovacuumMinDuration: Output? = null
private var logErrorVerbosity: Output? = null
private var logLinePrefix: Output? = null
private var logMinDurationStatement: Output? = null
private var maxFilesPerProcess: Output? = null
private var maxLocksPerTransaction: Output? = null
private var maxLogicalReplicationWorkers: Output? = null
private var maxParallelWorkers: Output? = null
private var maxParallelWorkersPerGather: Output? = null
private var maxPredLocksPerTransaction: Output? = null
private var maxPreparedTransactions: Output? = null
private var maxReplicationSlots: Output? = null
private var maxStackDepth: Output? = null
private var maxStandbyArchiveDelay: Output? = null
private var maxStandbyStreamingDelay: Output? = null
private var maxWalSenders: Output? = null
private var maxWorkerProcesses: Output? = null
private var pgPartmanBgwInterval: Output? = null
private var pgPartmanBgwRole: Output? = null
private var pgStatStatementsTrack: Output? = null
private var pgbouncers: Output>? = null
private var sharedBuffersPercentage: Output? = null
private var tempFileLimit: Output? = null
private var timescaledbs: Output>? = null
private var timezone: Output? = null
private var trackActivityQuerySize: Output? = null
private var trackCommitTimestamp: Output? = null
private var trackFunctions: Output? = null
private var trackIoTiming: Output? = null
private var walSenderTimeout: Output? = null
private var walWriterDelay: Output? = null
private var workMem: Output? = null
/**
* @param value Specifies a fraction, in a decimal value, 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).
*/
@JvmName("lhhjtbbwhprmxoxn")
public suspend fun autovacuumAnalyzeScaleFactor(`value`: Output) {
this.autovacuumAnalyzeScaleFactor = value
}
/**
* @param value Specifies the minimum number of inserted, updated, or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.
*/
@JvmName("tvscyntjwdrqdfxl")
public suspend fun autovacuumAnalyzeThreshold(`value`: Output) {
this.autovacuumAnalyzeThreshold = value
}
/**
* @param value 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.
*/
@JvmName("uqnrupkngkboolrh")
public suspend fun autovacuumFreezeMaxAge(`value`: Output) {
this.autovacuumFreezeMaxAge = value
}
/**
* @param value 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.
*/
@JvmName("xrhbvtxvqspxxmdl")
public suspend fun autovacuumMaxWorkers(`value`: Output) {
this.autovacuumMaxWorkers = value
}
/**
* @param value Specifies the minimum delay, in seconds, between autovacuum runs on any given database. The default is one minute.
*/
@JvmName("icxvroogkryeoevo")
public suspend fun autovacuumNaptime(`value`: Output) {
this.autovacuumNaptime = value
}
/**
* @param value Specifies the cost delay value, in milliseconds, that will be used in automatic VACUUM operations. If -1, uses the regular vacuum_cost_delay value, which is 20 milliseconds.
*/
@JvmName("tcjbcdqxpqdwkvsj")
public suspend fun autovacuumVacuumCostDelay(`value`: Output) {
this.autovacuumVacuumCostDelay = value
}
/**
* @param value 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.
*/
@JvmName("mfbryakarsxxnwhm")
public suspend fun autovacuumVacuumCostLimit(`value`: Output) {
this.autovacuumVacuumCostLimit = value
}
/**
* @param value Specifies a fraction, in a decimal value, 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).
*/
@JvmName("wciylqeqairimfyt")
public suspend fun autovacuumVacuumScaleFactor(`value`: Output) {
this.autovacuumVacuumScaleFactor = value
}
/**
* @param value Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.
*/
@JvmName("vgwcjayjqepgtgob")
public suspend fun autovacuumVacuumThreshold(`value`: Output) {
this.autovacuumVacuumThreshold = value
}
/**
* @param value The hour of day (in UTC) when backup for the service starts. New backup only starts if previous backup has already completed.
*/
@JvmName("ajwccxpkvgffhxbv")
public suspend fun backupHour(`value`: Output) {
this.backupHour = value
}
/**
* @param value The minute of the backup hour when backup for the service starts. New backup is only started if previous backup has already completed.
*/
@JvmName("mwahrjuwalsdxvmh")
public suspend fun backupMinute(`value`: Output) {
this.backupMinute = value
}
/**
* @param value Specifies the delay, in milliseconds, between activity rounds for the background writer. Default is 200 ms.
*/
@JvmName("vxjfhlmqoabofser")
public suspend fun bgwriterDelay(`value`: Output) {
this.bgwriterDelay = value
}
/**
* @param value The amount of kilobytes that need to be written by the background writer before attempting to force the OS to issue these writes to underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.
*/
@JvmName("byjstrphchjxecro")
public suspend fun bgwriterFlushAfter(`value`: Output) {
this.bgwriterFlushAfter = value
}
/**
* @param value The maximum number of buffers that the background writer can write. Setting this to zero disables background writing. Default is 100.
*/
@JvmName("vbstwanhuebcchvq")
public suspend fun bgwriterLruMaxpages(`value`: Output) {
this.bgwriterLruMaxpages = value
}
/**
* @param value 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.
*/
@JvmName("gqnxabhodyqrhlpr")
public suspend fun bgwriterLruMultiplier(`value`: Output) {
this.bgwriterLruMultiplier = value
}
/**
* @param value The ID of the target PostgreSQL cluster.
*/
@JvmName("vdaimejhmqownenm")
public suspend fun clusterId(`value`: Output) {
this.clusterId = value
}
/**
* @param value The amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.
*/
@JvmName("oosnhhiirnkvuewq")
public suspend fun deadlockTimeout(`value`: Output) {
this.deadlockTimeout = value
}
/**
* @param value Specifies the default TOAST compression method for values of compressible columns (the default is lz4). Supported values are: `lz4`, `pglz`.
*/
@JvmName("vihmphjlywqvmajp")
public suspend fun defaultToastCompression(`value`: Output) {
this.defaultToastCompression = value
}
/**
* @param value Time out sessions with open transactions after this number of milliseconds
*/
@JvmName("paebkmrcyhcxhmfe")
public suspend fun idleInTransactionSessionTimeout(`value`: Output) {
this.idleInTransactionSessionTimeout = value
}
/**
* @param value Activates, in a boolean, the system-wide use of Just-in-Time Compilation (JIT).
*/
@JvmName("fcxebfmtjngabaki")
public suspend fun jit(`value`: Output) {
this.jit = value
}
/**
* @param value 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.
*/
@JvmName("epcjkakhchqwjpnl")
public suspend fun logAutovacuumMinDuration(`value`: Output) {
this.logAutovacuumMinDuration = value
}
/**
* @param value Controls the amount of detail written in the server log for each message that is logged. Supported values are: `TERSE`, `DEFAULT`, `VERBOSE`.
*/
@JvmName("ueorokptvgmyrbtc")
public suspend fun logErrorVerbosity(`value`: Output) {
this.logErrorVerbosity = value
}
/**
* @param value Selects one of the available log-formats. These can support popular log analyzers like pgbadger, pganalyze, etc. Supported values are: `pid=%p,user=%u,db=%d,app=%a,client=%h`, `%m [%p] %q[user=%u,db=%d,app=%a]`, `%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h`.
*/
@JvmName("bqgyhlljgexnbwtt")
public suspend fun logLinePrefix(`value`: Output) {
this.logLinePrefix = value
}
/**
* @param value Log statements that take more than this number of milliseconds to run. If -1, disables.
*/
@JvmName("pysgoixhbpbferyg")
public suspend fun logMinDurationStatement(`value`: Output) {
this.logMinDurationStatement = value
}
/**
* @param value PostgreSQL maximum number of files that can be open per process.
*/
@JvmName("pjvcdxpbvhdletek")
public suspend fun maxFilesPerProcess(`value`: Output) {
this.maxFilesPerProcess = value
}
/**
* @param value PostgreSQL maximum locks per transaction. Once increased, this parameter cannot be lowered from its set value.
*/
@JvmName("fnebditwdullgoim")
public suspend fun maxLocksPerTransaction(`value`: Output) {
this.maxLocksPerTransaction = value
}
/**
* @param value PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).
*/
@JvmName("xvrmggkaryiqpvkn")
public suspend fun maxLogicalReplicationWorkers(`value`: Output) {
this.maxLogicalReplicationWorkers = value
}
/**
* @param value Sets the maximum number of workers that the system can support for parallel queries.
*/
@JvmName("ackkfyqwegcnrehv")
public suspend fun maxParallelWorkers(`value`: Output) {
this.maxParallelWorkers = value
}
/**
* @param value Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
*/
@JvmName("ocpudyjpfcsvdwbh")
public suspend fun maxParallelWorkersPerGather(`value`: Output) {
this.maxParallelWorkersPerGather = value
}
/**
* @param value PostgreSQL maximum predicate locks per transaction.
*/
@JvmName("ckciatcfvqrlwpxl")
public suspend fun maxPredLocksPerTransaction(`value`: Output) {
this.maxPredLocksPerTransaction = value
}
/**
* @param value PostgreSQL maximum prepared transactions. Once increased, this parameter cannot be lowered from its set value.
*/
@JvmName("jaqtwacmhatxpkwd")
public suspend fun maxPreparedTransactions(`value`: Output) {
this.maxPreparedTransactions = value
}
/**
* @param value PostgreSQL maximum replication slots.
*/
@JvmName("gsgipobyjnxicueq")
public suspend fun maxReplicationSlots(`value`: Output) {
this.maxReplicationSlots = value
}
/**
* @param value Maximum depth of the stack in bytes.
*/
@JvmName("unggnpswbjumhiir")
public suspend fun maxStackDepth(`value`: Output) {
this.maxStackDepth = value
}
/**
* @param value Max standby archive delay in milliseconds.
*/
@JvmName("mnwspngunxxmhkco")
public suspend fun maxStandbyArchiveDelay(`value`: Output) {
this.maxStandbyArchiveDelay = value
}
/**
* @param value Max standby streaming delay in milliseconds.
*/
@JvmName("cwnvocsbcapdsfdw")
public suspend fun maxStandbyStreamingDelay(`value`: Output) {
this.maxStandbyStreamingDelay = value
}
/**
* @param value PostgreSQL maximum WAL senders. Once increased, this parameter cannot be lowered from its set value.
*/
@JvmName("tefeccagysdbvdts")
public suspend fun maxWalSenders(`value`: Output) {
this.maxWalSenders = value
}
/**
* @param value Sets the maximum number of background processes that the system can support. Once increased, this parameter cannot be lowered from its set value.
*/
@JvmName("xxqforgjjrmwhgmv")
public suspend fun maxWorkerProcesses(`value`: Output) {
this.maxWorkerProcesses = value
}
/**
* @param value Sets the time interval to run pg_partman's scheduled tasks.
*/
@JvmName("ymrwonlttutpxapx")
public suspend fun pgPartmanBgwInterval(`value`: Output) {
this.pgPartmanBgwInterval = value
}
/**
* @param value Controls which role to use for pg_partman's scheduled background tasks. Must consist of alpha-numeric characters, dots, underscores, or dashes. May not start with dash or dot. Maximum of 64 characters.
*/
@JvmName("aqpwqaryyutamawl")
public suspend fun pgPartmanBgwRole(`value`: Output) {
this.pgPartmanBgwRole = value
}
/**
* @param value 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. Supported values are: `all`, `top`, `none`.
*/
@JvmName("anxlhctlhltjrfhn")
public suspend fun pgStatStatementsTrack(`value`: Output) {
this.pgStatStatementsTrack = value
}
/**
* @param value PGBouncer connection pooling settings
*/
@JvmName("twqolgtveoowlsnd")
public suspend fun pgbouncers(`value`: Output>) {
this.pgbouncers = value
}
@JvmName("qbahldaactrnscsb")
public suspend fun pgbouncers(vararg values: Output) {
this.pgbouncers = Output.all(values.asList())
}
/**
* @param values PGBouncer connection pooling settings
*/
@JvmName("ksaxhjdmhllnsjud")
public suspend fun pgbouncers(values: List