types
PostgresqlConfig10
Options and structure of PostgresqlConfig reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation.
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_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_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDIT
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
PasswordEncryption
PASSWORD_ENCRYPTION_UNSPECIFIEDPASSWORD_ENCRYPTION_MD5PASSWORD_ENCRYPTION_SCRAM_SHA_256
PgHintPlanDebugPrint
PG_HINT_PLAN_DEBUG_PRINT_UNSPECIFIEDPG_HINT_PLAN_DEBUG_PRINT_OFFPG_HINT_PLAN_DEBUG_PRINT_ONPG_HINT_PLAN_DEBUG_PRINT_DETAILEDPG_HINT_PLAN_DEBUG_PRINT_VERBOSE
PlanCacheMode
PLAN_CACHE_MODE_UNSPECIFIEDPLAN_CACHE_MODE_AUTOPLAN_CACHE_MODE_FORCE_CUSTOM_PLANPLAN_CACHE_MODE_FORCE_GENERIC_PLAN
SharedPreloadLibraries
SHARED_PRELOAD_LIBRARIES_UNSPECIFIEDSHARED_PRELOAD_LIBRARIES_AUTO_EXPLAINSHARED_PRELOAD_LIBRARIES_PG_HINT_PLANSHARED_PRELOAD_LIBRARIES_TIMESCALEDBSHARED_PRELOAD_LIBRARIES_PG_QUALSTATSSHARED_PRELOAD_LIBRARIES_PG_CRONSHARED_PRELOAD_LIBRARIES_PGLOGICALSHARED_PRELOAD_LIBRARIES_PG_PREWARMSHARED_PRELOAD_LIBRARIES_PGAUDITSHARED_PRELOAD_LIBRARIES_ANON
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
WalLevel
WAL_LEVEL_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDWAL_LEVEL_REPLICAWAL_LEVEL_LOGICAL
SynchronousCommit
SYNCHRONOUS_COMMIT_UNSPECIFIEDSYNCHRONOUS_COMMIT_ONSYNCHRONOUS_COMMIT_OFFSYNCHRONOUS_COMMIT_LOCALSYNCHRONOUS_COMMIT_REMOTE_WRITESYNCHRONOUS_COMMIT_REMOTE_APPLY
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_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_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_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_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_QUOTE_SAFE_ENCODING
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
ConstraintExclusion
CONSTRAINT_EXCLUSION_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
DebugParallelQuery
DEBUG_PARALLEL_QUERY_UNSPECIFIEDDEBUG_PARALLEL_QUERY_ONDEBUG_PARALLEL_QUERY_OFFDEBUG_PARALLEL_QUERY_REGRESS
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_INFOLOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_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_UNSPECIFIEDCONSTRAINT_EXCLUSION_ONCONSTRAINT_EXCLUSION_OFFCONSTRAINT_EXCLUSION_PARTITION
ForceParallelMode
FORCE_PARALLEL_MODE_UNSPECIFIEDFORCE_PARALLEL_MODE_ONFORCE_PARALLEL_MODE_OFFFORCE_PARALLEL_MODE_REGRESS
LogLevel
LOG_LEVEL_UNSPECIFIEDLOG_LEVEL_DEBUG5LOG_LEVEL_DEBUG4LOG_LEVEL_DEBUG3LOG_LEVEL_DEBUG2LOG_LEVEL_DEBUG1LOG_LEVEL_LOGLOG_LEVEL_NOTICELOG_LEVEL_WARNINGLOG_LEVEL_ERRORLOG_LEVEL_FATALLOG_LEVEL_PANIC
LogErrorVerbosity
LOG_ERROR_VERBOSITY_UNSPECIFIEDLOG_ERROR_VERBOSITY_TERSELOG_ERROR_VERBOSITY_DEFAULTLOG_ERROR_VERBOSITY_VERBOSE
LogStatement
LOG_STATEMENT_UNSPECIFIEDLOG_STATEMENT_NONELOG_STATEMENT_DDLLOG_STATEMENT_MODLOG_STATEMENT_ALL
TransactionIsolation
TRANSACTION_ISOLATION_UNSPECIFIEDTRANSACTION_ISOLATION_READ_UNCOMMITTEDTRANSACTION_ISOLATION_READ_COMMITTEDTRANSACTION_ISOLATION_REPEATABLE_READTRANSACTION_ISOLATION_SERIALIZABLE
ByteaOutput
BYTEA_OUTPUT_UNSPECIFIEDBYTEA_OUTPUT_HEXBYTEA_OUTPUT_ESCAPED
XmlBinary
XML_BINARY_UNSPECIFIEDXML_BINARY_BASE64XML_BINARY_HEX
XmlOption
XML_OPTION_UNSPECIFIEDXML_OPTION_DOCUMENTXML_OPTION_CONTENT
BackslashQuote
BACKSLASH_QUOTE_UNSPECIFIEDBACKSLASH_QUOTEBACKSLASH_QUOTE_ONBACKSLASH_QUOTE_OFFBACKSLASH_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.