Skip to main content

types

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.

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.

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.

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​

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.

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.

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.

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.

PostgresqlHostConfig10​

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

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

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig10_1C​

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

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

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig11​

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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig11_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig12​

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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig12_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig13​

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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig13_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig14​

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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig14_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig15​

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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig15_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig16​

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

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_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig16_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

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_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

TransactionIsolation​

  • TRANSACTION_ISOLATION_UNSPECIFIED

  • TRANSACTION_ISOLATION_READ_UNCOMMITTED

  • TRANSACTION_ISOLATION_READ_COMMITTED

  • TRANSACTION_ISOLATION_REPEATABLE_READ

  • TRANSACTION_ISOLATION_SERIALIZABLE

XmlBinary​

  • XML_BINARY_UNSPECIFIED

  • XML_BINARY_BASE64

  • XML_BINARY_HEX

XmlOption​

  • XML_OPTION_UNSPECIFIED

  • XML_OPTION_DOCUMENT

  • XML_OPTION_CONTENT

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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​
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​
maxParallelWorkers : google.protobuf.Int64Value​
maxParallelWorkersPerGather : google.protobuf.Int64Value​
timezone : string​
effectiveIoConcurrency : google.protobuf.Int64Value​
effectiveCacheSize : google.protobuf.Int64Value​

PostgresqlHostConfig9_6​

Options and structure of PostgresqlHostConfig reflects parameters of a PostgreSQL configuration file. Detailed description is available in PostgreSQL documentation.

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

recoveryMinApplyDelay : google.protobuf.Int64Value​

in milliseconds.

sharedBuffers : google.protobuf.Int64Value​

in bytes.

tempBuffers : google.protobuf.Int64Value​

in bytes.

workMem : google.protobuf.Int64Value​

in bytes.

replacementSortTuples : google.protobuf.Int64Value​

in bytes.

tempFileLimit : google.protobuf.Int64Value​

in bytes.

backendFlushAfter : google.protobuf.Int64Value​
oldSnapshotThreshold : google.protobuf.Int64Value​
maxStandbyStreamingDelay : google.protobuf.Int64Value​

in milliseconds.

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.

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