Skip to main content

List

Retrieves the list of PostgreSQL Cluster resources that belong to the specified folder.

import { cloudApi, serviceClients, Session } from "@yandex-cloud/nodejs-sdk";

const ListClustersRequest =
cloudApi.dataproc.cluster_service.ListClustersRequest;

(async () => {
const authToken = process.env["YC_OAUTH_TOKEN"];
const session = new Session({ oauthToken: authToken });
const client = session.client(serviceClients.ClusterServiceClient);

const result = await client.list(
ListClustersRequest.fromPartial({
folderId: "folderId",
// pageSize: 0,
// pageToken: "pageToken",
// filter: "filter"
})
);
console.log(result);
})();

ListClustersRequest​

folderId : string​

ID of the folder to list PostgreSQL clusters in. To get the folder ID, use a yandex.cloud.resourcemanager.v1.FolderService.List request.

pageSize : int64​

The maximum number of results per page to return. If the number of available results is larger than page_size, the service returns a ListClustersResponse.next_page_token that can be used to get the next page of results in subsequent list requests.

pageToken : string​

Page token. To get the next page of results, set page_token to the ListClustersResponse.next_page_token returned by the previous list request.

filter : string​

A filter expression that filters resources listed in the response. The expression must specify:

  1. The field name. Currently you can only use filtering with the Cluster.name field.
  2. An = operator.
  3. The value in double quotes ("). Must be 1-63 characters long and match the regular expression [a-zA-Z0-9_-]+.

ListClustersResponse​

clusters : Cluster​

List of PostgreSQL Cluster resources.

nextPageToken : string​

This token allows you to get the next page of results for list requests. If the number of results is larger than ListClustersRequest.page_size, use the next_page_token as the value for the ListClustersRequest.page_token parameter in the next list request. Each subsequent list request will have its own next_page_token to continue paging through the results.

Cluster​

A PostgreSQL Cluster resource. For more information, see the Concepts section of the documentation.

Environment​
  • ENVIRONMENT_UNSPECIFIED

  • PRODUCTION

    Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance.

  • PRESTABLE

    Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.

Health​
  • HEALTH_UNKNOWN

    State of the cluster is unknown ([Host.health][11] for every host in the cluster is UNKNOWN).

  • ALIVE

    Cluster is alive and well ([Host.health][12] for every host in the cluster is ALIVE).

  • DEAD

    Cluster is inoperable ([Host.health][13] for every host in the cluster is DEAD).

  • DEGRADED

    Cluster is working below capacity ([Host.health][14] for at least one host in the cluster is not ALIVE).

Status​
  • STATUS_UNKNOWN

    Cluster state is unknown.

  • CREATING

    Cluster is being created.

  • RUNNING

    Cluster is running normally.

  • ERROR

    Cluster encountered a problem and cannot operate.

  • UPDATING

    Cluster is being updated.

  • STOPPING

    Cluster is stopping.

  • STOPPED

    Cluster stopped.

  • STARTING

    Cluster is starting.

id : string​

ID of the PostgreSQL cluster. This ID is assigned by MDB at creation time.

folderId : string​

ID of the folder that the PostgreSQL cluster belongs to.

createdAt : google.protobuf.Timestamp​

Creation timestamp in RFC3339 text format.

name : string​

Name of the PostgreSQL cluster. The name is unique within the folder. 1-63 characters long.

description : string​

Description of the PostgreSQL cluster. 0-256 characters long.

labels : string​

Custom labels for the PostgreSQL cluster as key:value pairs. Maximum 64 per resource.

environment : Environment​

Deployment environment of the PostgreSQL cluster.

monitoring : Monitoring​

Description of monitoring systems relevant to the PostgreSQL cluster.

config : ClusterConfig​

Configuration of the PostgreSQL cluster.

networkId : string​

ID of the network that the cluster belongs to.

health : Health​

Aggregated cluster health.

status : Status​

Current state of the cluster.

maintenanceWindow : MaintenanceWindow​

Maintenance window for the cluster.

plannedOperation : MaintenanceOperation​

Planned maintenance operation to be started for the cluster within the nearest maintenance_window.

securityGroupIds : string​

User security groups

deletionProtection : bool​

Deletion Protection inhibits deletion of the cluster

hostGroupIds : string​

Host groups hosting VMs of the cluster.

Monitoring​

Monitoring system.

name : string​

Name of the monitoring system.

description : string​

Description of the monitoring system.

Link to the monitoring system charts for the PostgreSQL cluster.

ClusterConfig​

version : string​

Version of PostgreSQL server software.

One of postgresqlConfig​

Configuration for PostgreSQL servers in the cluster.

  • postgresqlConfig_9_6 : config.PostgresqlConfigSet9_6​

    Configuration of a PostgreSQL 9.6 server.

  • postgresqlConfig_10_1c : config.PostgresqlConfigSet10_1C​

    Configuration of a PostgreSQL 10 1C server.

  • postgresqlConfig_10 : config.PostgresqlConfigSet10​

    Configuration of a PostgreSQL 10 server.

  • postgresqlConfig_11 : config.PostgresqlConfigSet11​

    Configuration of a PostgreSQL 11 server.

  • postgresqlConfig_11_1c : config.PostgresqlConfigSet11_1C​

    Configuration of a PostgreSQL 11 1C server.

  • postgresqlConfig_12 : config.PostgresqlConfigSet12​

    Configuration of a PostgreSQL 12 server.

  • postgresqlConfig_12_1c : config.PostgresqlConfigSet12_1C​

    Configuration of a PostgreSQL 12 1C server.

  • postgresqlConfig_13 : config.PostgresqlConfigSet13​

    Configuration of a PostgreSQL 13 server.

  • postgresqlConfig_13_1c : config.PostgresqlConfigSet13_1C​

    Configuration of a PostgreSQL 13 1C server.

  • postgresqlConfig_14 : config.PostgresqlConfigSet14​

    Configuration of a PostgreSQL 14 server.

  • postgresqlConfig_14_1c : config.PostgresqlConfigSet14_1C​

    Configuration of a PostgreSQL 14 1C server.

  • postgresqlConfig_15 : config.PostgresqlConfigSet15​

    Configuration of a PostgreSQL 15 server.

  • postgresqlConfig_15_1c : config.PostgresqlConfigSet15_1C​

    Configuration of a PostgreSQL 15 1C server.

  • postgresqlConfig_16 : config.PostgresqlConfigSet16​

    Configuration of a PostgreSQL 16 server.

  • postgresqlConfig_16_1c : config.PostgresqlConfigSet16_1C​

    Configuration of a PostgreSQL 16 1C server.

poolerConfig : ConnectionPoolerConfig​

Configuration of the connection pooler.

resources : Resources​

Resources allocated to PostgreSQL hosts.

autofailover : google.protobuf.BoolValue​

Configuration setting which enables/disables autofailover in cluster.

backupWindowStart : google.type.TimeOfDay​

Time to start the daily backup, in the UTC timezone.

backupRetainPeriodDays : google.protobuf.Int64Value​

Retention policy of automated backups.

access : Access​

Access policy to DB

performanceDiagnostics : PerformanceDiagnostics​

Configuration of the performance diagnostics service.

diskSizeAutoscaling : DiskSizeAutoscaling​

Disk size autoscaling

MaintenanceWindow​

A maintenance window settings.

One of policy​

The maintenance policy in effect.

  • anytime : AnytimeMaintenanceWindow​

    Maintenance operation can be scheduled anytime.

  • weeklyMaintenanceWindow : WeeklyMaintenanceWindow​

    Maintenance operation can be scheduled on a weekly basis.

MaintenanceOperation​

A planned maintenance operation.

info : string​

Information about this maintenance operation.

delayedUntil : google.protobuf.Timestamp​

Time until which this maintenance operation is delayed.

PostgresqlConfigSet9_6​

effectiveConfig : PostgresqlConfig9_6​

Effective settings for a PostgreSQL 9.6 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig9_6​

User-defined settings for a PostgreSQL 9.6 cluster.

defaultConfig : PostgresqlConfig9_6​

Default configuration for a PostgreSQL 9.6 cluster.

PostgresqlConfigSet10_1C​

effectiveConfig : PostgresqlConfig10_1C​

Effective settings for a PostgreSQL 10 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig10_1C​

User-defined settings for a PostgreSQL 10 1C cluster.

defaultConfig : PostgresqlConfig10_1C​

Default configuration for a PostgreSQL 10 1C cluster.

PostgresqlConfigSet10​

effectiveConfig : PostgresqlConfig10​

Effective settings for a PostgreSQL 10 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig10​

User-defined settings for a PostgreSQL 10 cluster.

defaultConfig : PostgresqlConfig10​

Default configuration for a PostgreSQL 10 cluster.

PostgresqlConfigSet11​

effectiveConfig : PostgresqlConfig11​

Effective settings for a PostgreSQL 11 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig11​

User-defined settings for a PostgreSQL 11 cluster.

defaultConfig : PostgresqlConfig11​

Default configuration for a PostgreSQL 11 cluster.

PostgresqlConfigSet11_1C​

effectiveConfig : PostgresqlConfig11_1C​

Effective settings for a PostgreSQL 11 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig11_1C​

User-defined settings for a PostgreSQL 11 1C cluster.

defaultConfig : PostgresqlConfig11_1C​

Default configuration for a PostgreSQL 11 1C cluster.

PostgresqlConfigSet12​

effectiveConfig : PostgresqlConfig12​

Effective settings for a PostgreSQL 12 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig12​

User-defined settings for a PostgreSQL 12 cluster.

defaultConfig : PostgresqlConfig12​

Default configuration for a PostgreSQL 12 cluster.

PostgresqlConfigSet12_1C​

effectiveConfig : PostgresqlConfig12_1C​

Effective settings for a PostgreSQL 12 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig12_1C​

User-defined settings for a PostgreSQL 12 1C cluster.

defaultConfig : PostgresqlConfig12_1C​

Default configuration for a PostgreSQL 12 1C cluster.

PostgresqlConfigSet13​

effectiveConfig : PostgresqlConfig13​

Effective settings for a PostgreSQL 13 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig13​

User-defined settings for a PostgreSQL 13 cluster.

defaultConfig : PostgresqlConfig13​

Default configuration for a PostgreSQL 13 cluster.

PostgresqlConfigSet13_1C​

effectiveConfig : PostgresqlConfig13_1C​

Effective settings for a PostgreSQL 13 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig13_1C​

User-defined settings for a PostgreSQL 13 1C cluster.

defaultConfig : PostgresqlConfig13_1C​

Default configuration for a PostgreSQL 13 1C cluster.

PostgresqlConfigSet14​

effectiveConfig : PostgresqlConfig14​

Effective settings for a PostgreSQL 14 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig14​

User-defined settings for a PostgreSQL 14 cluster.

defaultConfig : PostgresqlConfig14​

Default configuration for a PostgreSQL 14 cluster.

PostgresqlConfigSet14_1C​

effectiveConfig : PostgresqlConfig14_1C​

Effective settings for a PostgreSQL 14 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig14_1C​

User-defined settings for a PostgreSQL 14 1C cluster.

defaultConfig : PostgresqlConfig14_1C​

Default configuration for a PostgreSQL 14 1C cluster.

PostgresqlConfigSet15​

effectiveConfig : PostgresqlConfig15​

Effective settings for a PostgreSQL 15 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig15​

User-defined settings for a PostgreSQL 15 cluster.

defaultConfig : PostgresqlConfig15​

Default configuration for a PostgreSQL 15 cluster.

PostgresqlConfigSet15_1C​

effectiveConfig : PostgresqlConfig15_1C​

Effective settings for a PostgreSQL 15 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig15_1C​

User-defined settings for a PostgreSQL 15 1C cluster.

defaultConfig : PostgresqlConfig15_1C​

Default configuration for a PostgreSQL 15 1C cluster.

PostgresqlConfigSet16​

effectiveConfig : PostgresqlConfig16​

Effective settings for a PostgreSQL 16 cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig16​

User-defined settings for a PostgreSQL 16 cluster.

defaultConfig : PostgresqlConfig16​

Default configuration for a PostgreSQL 16 cluster.

PostgresqlConfigSet16_1C​

effectiveConfig : PostgresqlConfig16_1C​

Effective settings for a PostgreSQL 16 1C cluster (a combination of settings defined in user_config and default_config).

userConfig : PostgresqlConfig16_1C​

User-defined settings for a PostgreSQL 16 1C cluster.

defaultConfig : PostgresqlConfig16_1C​

Default configuration for a PostgreSQL 16 1C cluster.

ConnectionPoolerConfig​

PoolingMode​
  • POOLING_MODE_UNSPECIFIED

  • SESSION

    Session pooling mode.

  • TRANSACTION

    Transaction pooling mode.

  • STATEMENT

    Statement pooling mode.

poolingMode : PoolingMode​

Mode that the connection pooler is working in. See descriptions of all modes in the documentation for PgBouncer.

poolDiscard : google.protobuf.BoolValue​

Setting server_reset_query_always parameter in PgBouncer.

Resources​

resourcePresetId : string​

ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation.

diskSize : int64​

Volume of the storage available to a host, in bytes.

diskTypeId : string​

Type of the storage environment for the host. Possible values:

  • network-hdd - network HDD drive,
  • network-ssd - network SSD drive,
  • local-ssd - local SSD storage.

Access​

dataLens : bool​

Allow access for DataLens

webSql : bool​

Allow SQL queries to the cluster databases from the management console.

See SQL queries in the management console for more details.

serverless : bool​

Allow access for Serverless

dataTransfer : bool​

Allow access for DataTransfer.

yandexQuery : bool​

Allow access for YandexQuery.

PerformanceDiagnostics​

enabled : bool​

Configuration setting which enables/disables performance diagnostics service in cluster.

sessionsSamplingInterval : int64​

Interval (in seconds) for pg_stat_activity sampling

statementsSamplingInterval : int64​

Interval (in seconds) for pg_stat_statements sampling

DiskSizeAutoscaling​

plannedUsageThreshold : int64​

Threshold of storage usage (in percent) that triggers automatic scaling of the storage during the maintenance window. Zero value means disabled threshold.

emergencyUsageThreshold : int64​

Threshold of storage usage (in percent) that triggers immediate automatic scaling of the storage. Zero value means disabled threshold.

diskSizeLimit : int64​

New storage size (in bytes) that is set when one of the thresholds is achieved.

AnytimeMaintenanceWindow​

WeeklyMaintenanceWindow​

Weelky maintenance window settings.

WeekDay​
  • WEEK_DAY_UNSPECIFIED

  • MON

  • TUE

  • WED

  • THU

  • FRI

  • SAT

  • SUN

day : WeekDay​

Day of the week (in DDD format).

hour : int64​

Hour of the day in UTC (in HH format).

PostgresqlConfig9_6​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters whose detailed description is available in PostgreSQL documentation.

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​
autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​

Acceptable values are 0.0 to 1.0, inclusive.

checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
sqlInheritance : google.protobuf.BoolValue​

This option has been removed in PostgreSQL 10.

autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlConfig10_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters whose detailed description is available in PostgreSQL documentation.

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​
autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
onlineAnalyzeEnable : google.protobuf.BoolValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig10​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters whose detailed description is available in PostgreSQL documentation.

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​
autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig11​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig11_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig12​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig12_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig13​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig13_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
operatorPrecedenceWarning : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
vacuumCleanupIndexScaleFactor : google.protobuf.DoubleValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig14​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig14_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig15​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

  • SHARED_PRELOAD_LIBRARIES_ANON

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

enableGroupByReordering : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig15_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

ForceParallelMode​
  • FORCE_PARALLEL_MODE_UNSPECIFIED

  • FORCE_PARALLEL_MODE_ON

  • FORCE_PARALLEL_MODE_OFF

  • FORCE_PARALLEL_MODE_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

  • SHARED_PRELOAD_LIBRARIES_ANON

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
forceParallelMode : ForceParallelMode​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

enableGroupByReordering : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig16​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

DebugParallelQuery​
  • DEBUG_PARALLEL_QUERY_UNSPECIFIED

  • DEBUG_PARALLEL_QUERY_ON

  • DEBUG_PARALLEL_QUERY_OFF

  • DEBUG_PARALLEL_QUERY_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_INFO

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

  • SHARED_PRELOAD_LIBRARIES_ANON

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
debugParallelQuery : DebugParallelQuery​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

enableGroupByReordering : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.

PostgresqlConfig16_1C​

Options and structure of PostgresqlConfig reflects PostgreSQL configuration file parameters which detailed description is available in PostgreSQL documentation.

BackslashQuote​
  • BACKSLASH_QUOTE_UNSPECIFIED

  • BACKSLASH_QUOTE

  • BACKSLASH_QUOTE_ON

  • BACKSLASH_QUOTE_OFF

  • BACKSLASH_QUOTE_SAFE_ENCODING

ByteaOutput​
  • BYTEA_OUTPUT_UNSPECIFIED

  • BYTEA_OUTPUT_HEX

  • BYTEA_OUTPUT_ESCAPED

ConstraintExclusion​
  • CONSTRAINT_EXCLUSION_UNSPECIFIED

  • CONSTRAINT_EXCLUSION_ON

  • CONSTRAINT_EXCLUSION_OFF

  • CONSTRAINT_EXCLUSION_PARTITION

DebugParallelQuery​
  • DEBUG_PARALLEL_QUERY_UNSPECIFIED

  • DEBUG_PARALLEL_QUERY_ON

  • DEBUG_PARALLEL_QUERY_OFF

  • DEBUG_PARALLEL_QUERY_REGRESS

LogErrorVerbosity​
  • LOG_ERROR_VERBOSITY_UNSPECIFIED

  • LOG_ERROR_VERBOSITY_TERSE

  • LOG_ERROR_VERBOSITY_DEFAULT

  • LOG_ERROR_VERBOSITY_VERBOSE

LogLevel​
  • LOG_LEVEL_UNSPECIFIED

  • LOG_LEVEL_DEBUG5

  • LOG_LEVEL_DEBUG4

  • LOG_LEVEL_DEBUG3

  • LOG_LEVEL_DEBUG2

  • LOG_LEVEL_DEBUG1

  • LOG_LEVEL_INFO

  • LOG_LEVEL_LOG

  • LOG_LEVEL_NOTICE

  • LOG_LEVEL_WARNING

  • LOG_LEVEL_ERROR

  • LOG_LEVEL_FATAL

  • LOG_LEVEL_PANIC

LogStatement​
  • LOG_STATEMENT_UNSPECIFIED

  • LOG_STATEMENT_NONE

  • LOG_STATEMENT_DDL

  • LOG_STATEMENT_MOD

  • LOG_STATEMENT_ALL

PasswordEncryption​
  • PASSWORD_ENCRYPTION_UNSPECIFIED

  • PASSWORD_ENCRYPTION_MD5

  • PASSWORD_ENCRYPTION_SCRAM_SHA_256

PgHintPlanDebugPrint​
  • PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIED

  • PG_HINT_PLAN_DEBUG_PRINT_OFF

  • PG_HINT_PLAN_DEBUG_PRINT_ON

  • PG_HINT_PLAN_DEBUG_PRINT_DETAILED

  • PG_HINT_PLAN_DEBUG_PRINT_VERBOSE

PlanCacheMode​
  • PLAN_CACHE_MODE_UNSPECIFIED

  • PLAN_CACHE_MODE_AUTO

  • PLAN_CACHE_MODE_FORCE_CUSTOM_PLAN

  • PLAN_CACHE_MODE_FORCE_GENERIC_PLAN

SharedPreloadLibraries​
  • SHARED_PRELOAD_LIBRARIES_UNSPECIFIED

  • SHARED_PRELOAD_LIBRARIES_AUTO_EXPLAIN

  • SHARED_PRELOAD_LIBRARIES_PG_HINT_PLAN

  • SHARED_PRELOAD_LIBRARIES_TIMESCALEDB

  • SHARED_PRELOAD_LIBRARIES_PG_QUALSTATS

  • SHARED_PRELOAD_LIBRARIES_PG_CRON

  • SHARED_PRELOAD_LIBRARIES_PGLOGICAL

  • SHARED_PRELOAD_LIBRARIES_PG_PREWARM

  • SHARED_PRELOAD_LIBRARIES_PGAUDIT

  • SHARED_PRELOAD_LIBRARIES_ANON

SynchronousCommit​
  • SYNCHRONOUS_COMMIT_UNSPECIFIED

  • SYNCHRONOUS_COMMIT_ON

  • SYNCHRONOUS_COMMIT_OFF

  • SYNCHRONOUS_COMMIT_LOCAL

  • SYNCHRONOUS_COMMIT_REMOTE_WRITE

  • SYNCHRONOUS_COMMIT_REMOTE_APPLY

TransactionIsolation​
  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

WalLevel​
  • WAL_LEVEL_UNSPECIFIED

  • WAL_LEVEL_REPLICA

  • WAL_LEVEL_LOGICAL

XmlBinary​
  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​
  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

maxConnections : google.protobuf.Int64Value​
sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

maxPreparedTransactions : google.protobuf.Int64Value​
workMem : google.protobuf.Int64Value​

in bytes.

maintenanceWorkMem : google.protobuf.Int64Value​

in bytes.

autovacuumWorkMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

vacuumCostDelay : google.protobuf.Int64Value​

in milliseconds.

vacuumCostPageHit : google.protobuf.Int64Value​
vacuumCostPageMiss : google.protobuf.Int64Value​
vacuumCostPageDirty : google.protobuf.Int64Value​
vacuumCostLimit : google.protobuf.Int64Value​
bgwriterDelay : google.protobuf.Int64Value​

in milliseconds.

bgwriterLruMaxpages : google.protobuf.Int64Value​
bgwriterLruMultiplier : google.protobuf.DoubleValue​
bgwriterFlushAfter : google.protobuf.Int64Value​

in bytes

backendFlushAfter : google.protobuf.Int64Value​

in bytes

oldSnapshotThreshold : google.protobuf.Int64Value​
walLevel : WalLevel​
synchronousCommit : SynchronousCommit​
checkpointTimeout : google.protobuf.Int64Value​

in milliseconds.

checkpointCompletionTarget : google.protobuf.DoubleValue​
checkpointFlushAfter : google.protobuf.Int64Value​

in bytes

maxWalSize : google.protobuf.Int64Value​

in bytes.

minWalSize : google.protobuf.Int64Value​

in bytes.

maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

defaultStatisticsTarget : google.protobuf.Int64Value​
constraintExclusion : ConstraintExclusion​
cursorTupleFraction : google.protobuf.DoubleValue​
fromCollapseLimit : google.protobuf.Int64Value​
joinCollapseLimit : google.protobuf.Int64Value​
debugParallelQuery : DebugParallelQuery​
clientMinMessages : LogLevel​
logMinMessages : LogLevel​
logMinErrorStatement : LogLevel​
logMinDurationStatement : google.protobuf.Int64Value​

in milliseconds.

logCheckpoints : google.protobuf.BoolValue​
logConnections : google.protobuf.BoolValue​
logDisconnections : google.protobuf.BoolValue​
logDuration : google.protobuf.BoolValue​
logErrorVerbosity : LogErrorVerbosity​
logLockWaits : google.protobuf.BoolValue​
logStatement : LogStatement​
logTempFiles : google.protobuf.Int64Value​
searchPath : string​
rowSecurity : google.protobuf.BoolValue​
defaultTransactionIsolation : TransactionIsolation​
statementTimeout : google.protobuf.Int64Value​

in milliseconds.

lockTimeout : google.protobuf.Int64Value​

in milliseconds.

idleInTransactionSessionTimeout : google.protobuf.Int64Value​

in milliseconds.

byteaOutput : ByteaOutput​
xmlbinary : XmlBinary​
xmloption : XmlOption​
ginPendingListLimit : google.protobuf.Int64Value​

in bytes.

deadlockTimeout : google.protobuf.Int64Value​

in milliseconds.

maxLocksPerTransaction : google.protobuf.Int64Value​
maxPredLocksPerTransaction : google.protobuf.Int64Value​
arrayNulls : google.protobuf.BoolValue​
backslashQuote : BackslashQuote​
defaultWithOids : google.protobuf.BoolValue​
escapeStringWarning : google.protobuf.BoolValue​
loCompatPrivileges : google.protobuf.BoolValue​
quoteAllIdentifiers : google.protobuf.BoolValue​
standardConformingStrings : google.protobuf.BoolValue​
synchronizeSeqscans : google.protobuf.BoolValue​
transformNullEquals : google.protobuf.BoolValue​
exitOnError : google.protobuf.BoolValue​
seqPageCost : google.protobuf.DoubleValue​
randomPageCost : google.protobuf.DoubleValue​
autovacuumMaxWorkers : google.protobuf.Int64Value​
autovacuumVacuumCostDelay : google.protobuf.Int64Value​
autovacuumVacuumCostLimit : google.protobuf.Int64Value​
autovacuumNaptime : google.protobuf.Int64Value​

in milliseconds.

archiveTimeout : google.protobuf.Int64Value​

in milliseconds.

trackActivityQuerySize : google.protobuf.Int64Value​
onlineAnalyzeEnable : google.protobuf.BoolValue​
enableBitmapscan : google.protobuf.BoolValue​
enableHashagg : google.protobuf.BoolValue​
enableHashjoin : google.protobuf.BoolValue​
enableIndexscan : google.protobuf.BoolValue​
enableIndexonlyscan : google.protobuf.BoolValue​
enableMaterial : google.protobuf.BoolValue​
enableMergejoin : google.protobuf.BoolValue​
enableNestloop : google.protobuf.BoolValue​
enableSeqscan : google.protobuf.BoolValue​
enableSort : google.protobuf.BoolValue​
enableTidscan : google.protobuf.BoolValue​
maxWorkerProcesses : google.protobuf.Int64Value​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
autovacuumVacuumScaleFactor : google.protobuf.DoubleValue​
autovacuumAnalyzeScaleFactor : google.protobuf.DoubleValue​
defaultTransactionReadOnly : google.protobuf.BoolValue​
timezone : string​
enableParallelAppend : google.protobuf.BoolValue​
enableParallelHash : google.protobuf.BoolValue​
enablePartitionPruning : google.protobuf.BoolValue​
enablePartitionwiseAggregate : google.protobuf.BoolValue​
enablePartitionwiseJoin : google.protobuf.BoolValue​
jit : google.protobuf.BoolValue​
maxParallelMaintenanceWorkers : google.protobuf.Int64Value​
parallelLeaderParticipation : google.protobuf.BoolValue​
logTransactionSampleRate : google.protobuf.DoubleValue​
planCacheMode : PlanCacheMode​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​
sharedPreloadLibraries : SharedPreloadLibraries​
autoExplainLogMinDuration : google.protobuf.Int64Value​

in milliseconds.

autoExplainLogAnalyze : google.protobuf.BoolValue​
autoExplainLogBuffers : google.protobuf.BoolValue​
autoExplainLogTiming : google.protobuf.BoolValue​
autoExplainLogTriggers : google.protobuf.BoolValue​
autoExplainLogVerbose : google.protobuf.BoolValue​
autoExplainLogNestedStatements : google.protobuf.BoolValue​
autoExplainSampleRate : google.protobuf.DoubleValue​
pgHintPlanEnableHint : google.protobuf.BoolValue​
pgHintPlanEnableHintTable : google.protobuf.BoolValue​
pgHintPlanDebugPrint : PgHintPlanDebugPrint​
pgHintPlanMessageLevel : LogLevel​
hashMemMultiplier : google.protobuf.DoubleValue​
logicalDecodingWorkMem : google.protobuf.Int64Value​

in bytes.

maintenanceIoConcurrency : google.protobuf.Int64Value​
maxSlotWalKeepSize : google.protobuf.Int64Value​

in bytes.

walKeepSize : google.protobuf.Int64Value​

in bytes.

enableIncrementalSort : google.protobuf.BoolValue​
autovacuumVacuumInsertThreshold : google.protobuf.Int64Value​
autovacuumVacuumInsertScaleFactor : google.protobuf.DoubleValue​
logMinDurationSample : google.protobuf.Int64Value​

in milliseconds.

logStatementSampleRate : google.protobuf.DoubleValue​
logParameterMaxLength : google.protobuf.Int64Value​

in bytes.

logParameterMaxLengthOnError : google.protobuf.Int64Value​

in bytes.

clientConnectionCheckInterval : google.protobuf.Int64Value​

in milliseconds.

enableAsyncAppend : google.protobuf.BoolValue​
enableGathermerge : google.protobuf.BoolValue​
enableMemoize : google.protobuf.BoolValue​
logRecoveryConflictWaits : google.protobuf.BoolValue​

in milliseconds.

vacuumFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

vacuumMultixactFailsafeAge : google.protobuf.Int64Value​

in milliseconds.

pgQualstatsEnabled : google.protobuf.BoolValue​
pgQualstatsTrackConstants : google.protobuf.BoolValue​
pgQualstatsMax : google.protobuf.Int64Value​
pgQualstatsResolveOids : google.protobuf.BoolValue​
pgQualstatsSampleRate : google.protobuf.DoubleValue​
plantunerFixEmptyTable : google.protobuf.BoolValue​
maxStackDepth : google.protobuf.Int64Value​

in bytes.

enableGroupByReordering : google.protobuf.BoolValue​
geqo : google.protobuf.BoolValue​

enable Genetic Query Optimizer, by default is on

geqoThreshold : google.protobuf.Int64Value​

The number of tables to use geqo, default is 12

geqoEffort : google.protobuf.Int64Value​

tradeoff between planning time and query plan quality, default is 5

geqoPoolSize : google.protobuf.Int64Value​

number of individuals in the genetic population, useful values are typically 100 to 1000; default - 0 - choose based on based on geqo_effort

geqoGenerations : google.protobuf.Int64Value​

the number of generations used by GEQO, useful values are in the same range as the pool size

geqoSelectionBias : google.protobuf.DoubleValue​

selective pressure within the population

geqoSeed : google.protobuf.DoubleValue​

initial value of the random number generator used by GEQO

pgTrgmSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmWordSimilarityThreshold : google.protobuf.DoubleValue​
pgTrgmStrictWordSimilarityThreshold : google.protobuf.DoubleValue​
maxStandbyArchiveDelay : google.protobuf.Int64Value​

in milliseconds.

sessionDurationTimeout : google.protobuf.Int64Value​

Terminate any session that exceeds the designated timeout, specified in milliseconds. If a timeout is not specified, the default session timeout is set to 12 hours. To disable it, specify a value of 0.

logReplicationCommands : google.protobuf.BoolValue​
logAutovacuumMinDuration : google.protobuf.Int64Value​

in milliseconds. The default is 1000 (1 sec).

passwordEncryption : PasswordEncryption​

A default value for user_password_encryption user-level setting, if it not specified for new users. Possible values are PASSWORD_ENCRYPTION_MD5 or PASSWORD_ENCRYPTION_SCRAM_SHA_256. The default is PASSWORD_ENCRYPTION_MD5.