Method restore
Creates a new PostgreSQL cluster using the specified backup.
HTTP request
POST https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters:restore
Body parameters
{
"backupId": "string",
"time": "string",
"timeInclusive": true,
"name": "string",
"description": "string",
"labels": "object",
"environment": "string",
"configSpec": {
"version": "string",
"poolerConfig": {
"poolingMode": "string",
"poolDiscard": true
},
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
},
"autofailover": true,
"backupWindowStart": {
"hours": "integer",
"minutes": "integer",
"seconds": "integer",
"nanos": "integer"
},
"backupRetainPeriodDays": "integer",
"access": {
"dataLens": true,
"webSql": true,
"serverless": true
},
"performanceDiagnostics": {
"enabled": true,
"sessionsSamplingInterval": "string",
"statementsSamplingInterval": "string"
},
// `configSpec` includes only one of the fields `postgresqlConfig_9_6`, `postgresqlConfig_10_1C`, `postgresqlConfig_10`, `postgresqlConfig_11`, `postgresqlConfig_11_1C`, `postgresqlConfig_12`, `postgresqlConfig_12_1C`, `postgresqlConfig_13`
"postgresqlConfig_9_6": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"sqlInheritance": true,
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_10_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"onlineAnalyzeEnable": true,
"plantunerFixEmptyTable": true
},
"postgresqlConfig_10": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string"
},
"postgresqlConfig_11": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string"
},
"postgresqlConfig_11_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string"
},
"postgresqlConfig_12": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string"
},
"postgresqlConfig_12_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string"
},
"postgresqlConfig_13": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer"
},
// end of the list of possible fields`configSpec`
},
"hostSpecs": [
{
"zoneId": "string",
"subnetId": "string",
"assignPublicIp": true,
"replicationSource": "string",
"priority": "integer",
"configSpec": {
// `hostSpecs[].configSpec` includes only one of the fields `postgresqlConfig_9_6`, `postgresqlConfig_10_1C`, `postgresqlConfig_10`, `postgresqlConfig_11`, `postgresqlConfig_11_1C`, `postgresqlConfig_12`, `postgresqlConfig_12_1C`, `postgresqlConfig_13`
"postgresqlConfig_9_6": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"replacementSortTuples": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"sqlInheritance": true,
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_10_1C": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"replacementSortTuples": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_10": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"replacementSortTuples": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_11": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_11_1C": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_12": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_12_1C": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_13": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
// end of the list of possible fields`hostSpecs[].configSpec`
}
}
],
"networkId": "string",
"folderId": "string",
"securityGroupIds": [
"string"
]
}
| Field | Description |
|---|---|
| backupId | string Required. ID of the backup to create a cluster from. To get the backup ID, use a listBackups request. |
| time | string (date-time) Required. Timestamp of the moment to which the PostgreSQL cluster should be restored. String in RFC3339 text format. |
| timeInclusive | boolean (boolean) Flag that indicates whether a database should be restored to the first backup point available just after the timestamp specified in the time field instead of just before. Possible values: |
| name | string Required. Name of the new PostgreSQL cluster. The name must be unique within the folder. The maximum string length in characters is 63. Value must match the regular expression |
| description | string Description of the new PostgreSQL cluster. The maximum string length in characters is 256. |
| labels | object Custom labels for the PostgreSQL cluster as No more than 64 per resource. The maximum string length in characters for each key is 63. Each key must match the regular expression |
| environment | string Deployment environment of the new PostgreSQL cluster.
|
| configSpec | object Configuration for the PostgreSQL cluster to be created. |
| configSpec. version |
string Version of PostgreSQL used in the cluster. Possible values: |
| configSpec. poolerConfig |
object Configuration of the connection pooler. |
| configSpec. poolerConfig. poolingMode |
string Mode that the connection pooler is working in. See descriptions of all modes in the documentation for PgBouncer.
|
| configSpec. poolerConfig. poolDiscard |
boolean (boolean) Setting |
| configSpec. resources |
object Resources allocated to PostgreSQL hosts. |
| configSpec. resources. resourcePresetId |
string ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation. |
| configSpec. resources. diskSize |
string (int64) Volume of the storage available to a host, in bytes. |
| configSpec. resources. diskTypeId |
string Type of the storage environment for the host. Possible values:
|
| configSpec. autofailover |
boolean (boolean) Configuration setting which enables/disables autofailover in cluster. |
| configSpec. backupWindowStart |
object Time to start the daily backup, in the UTC timezone. Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are google.type.Date and google.protobuf.Timestamp. |
| configSpec. backupWindowStart. hours |
integer (int32) Hours of day in 24 hour format. Should be from 0 to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time. |
| configSpec. backupWindowStart. minutes |
integer (int32) Minutes of hour of day. Must be from 0 to 59. |
| configSpec. backupWindowStart. seconds |
integer (int32) Seconds of minutes of the time. Must normally be from 0 to 59. An API may allow the value 60 if it allows leap-seconds. |
| configSpec. backupWindowStart. nanos |
integer (int32) Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999. |
| configSpec. backupRetainPeriodDays |
integer (int64) Retention policy of automated backups. Acceptable values are 7 to 60, inclusive. |
| configSpec. access |
object Access policy to DB |
| configSpec. access. dataLens |
boolean (boolean) Allow access for DataLens |
| configSpec. access. webSql |
boolean (boolean) Allow SQL queries to the cluster databases from the Yandex.Cloud management console. See SQL queries in the management console for more details. |
| configSpec. access. serverless |
boolean (boolean) Allow access for Serverless |
| configSpec. performanceDiagnostics |
object Configuration of the performance diagnostics service. |
| configSpec. performanceDiagnostics. enabled |
boolean (boolean) Configuration setting which enables/disables performance diagnostics service in cluster. |
| configSpec. performanceDiagnostics. sessionsSamplingInterval |
string (int64) Interval (in seconds) for pg_stat_activity sampling Acceptable values are 1 to 86400, inclusive. |
| configSpec. performanceDiagnostics. statementsSamplingInterval |
string (int64) Interval (in seconds) for pg_stat_statements sampling Acceptable values are 1 to 86400, inclusive. |
| configSpec. postgresqlConfig_9_6 |
object Configuration for a PostgreSQL 9.6 cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_9_6. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_9_6. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_9_6. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_9_6. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_9_6. workMem |
integer (int64) |
| configSpec. postgresqlConfig_9_6. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_9_6. replacementSortTuples |
integer (int64) |
| configSpec. postgresqlConfig_9_6. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_9_6. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_9_6. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_9_6. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_9_6. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_9_6. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_9_6. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_9_6. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_9_6. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_9_6. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_9_6. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_9_6. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_9_6. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_9_6. walLevel |
string |
| configSpec. postgresqlConfig_9_6. synchronousCommit |
string |
| configSpec. postgresqlConfig_9_6. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_9_6. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_9_6. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_9_6. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_9_6. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_9_6. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_9_6. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_9_6. constraintExclusion |
string |
| configSpec. postgresqlConfig_9_6. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_9_6. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_9_6. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_9_6. forceParallelMode |
string |
| configSpec. postgresqlConfig_9_6. clientMinMessages |
string |
| configSpec. postgresqlConfig_9_6. logMinMessages |
string |
| configSpec. postgresqlConfig_9_6. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_9_6. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_9_6. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_9_6. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. logStatement |
string |
| configSpec. postgresqlConfig_9_6. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_9_6. searchPath |
string |
| configSpec. postgresqlConfig_9_6. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_9_6. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_9_6. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_9_6. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_9_6. byteaOutput |
string |
| configSpec. postgresqlConfig_9_6. xmlbinary |
string |
| configSpec. postgresqlConfig_9_6. xmloption |
string |
| configSpec. postgresqlConfig_9_6. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_9_6. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_9_6. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_9_6. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_9_6. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. backslashQuote |
string |
| configSpec. postgresqlConfig_9_6. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_9_6. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_9_6. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_9_6. sqlInheritance |
boolean (boolean) This option has been removed in PostgreSQL 10. |
| configSpec. postgresqlConfig_9_6. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_9_6. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_9_6. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_9_6. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_9_6. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_9_6. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_9_6. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_9_6. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_10_1C |
object Configuration for a PostgreSQL 10 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_10_1C. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. workMem |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. replacementSortTuples |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_10_1C. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_10_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10_1C. walLevel |
string |
| configSpec. postgresqlConfig_10_1C. synchronousCommit |
string |
| configSpec. postgresqlConfig_10_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10_1C. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_10_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10_1C. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. constraintExclusion |
string |
| configSpec. postgresqlConfig_10_1C. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_10_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10_1C. forceParallelMode |
string |
| configSpec. postgresqlConfig_10_1C. clientMinMessages |
string |
| configSpec. postgresqlConfig_10_1C. logMinMessages |
string |
| configSpec. postgresqlConfig_10_1C. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_10_1C. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_10_1C. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. logStatement |
string |
| configSpec. postgresqlConfig_10_1C. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. searchPath |
string |
| configSpec. postgresqlConfig_10_1C. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_10_1C. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. byteaOutput |
string |
| configSpec. postgresqlConfig_10_1C. xmlbinary |
string |
| configSpec. postgresqlConfig_10_1C. xmloption |
string |
| configSpec. postgresqlConfig_10_1C. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_10_1C. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. backslashQuote |
string |
| configSpec. postgresqlConfig_10_1C. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_10_1C. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_10_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_10_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_10_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_10_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_10_1C. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10_1C. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. timezone |
string |
| configSpec. postgresqlConfig_10_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_10_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_10_1C. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_10_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10_1C. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10_1C. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_10_1C. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_10_1C. onlineAnalyzeEnable |
boolean (boolean) |
| configSpec. postgresqlConfig_10_1C. plantunerFixEmptyTable |
boolean (boolean) |
| configSpec. postgresqlConfig_10 |
object Configuration for a PostgreSQL 10 cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_10. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_10. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_10. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_10. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_10. workMem |
integer (int64) |
| configSpec. postgresqlConfig_10. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_10. replacementSortTuples |
integer (int64) |
| configSpec. postgresqlConfig_10. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_10. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_10. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_10. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_10. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_10. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_10. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_10. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_10. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_10. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_10. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10. walLevel |
string |
| configSpec. postgresqlConfig_10. synchronousCommit |
string |
| configSpec. postgresqlConfig_10. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_10. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_10. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_10. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_10. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_10. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_10. constraintExclusion |
string |
| configSpec. postgresqlConfig_10. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_10. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10. forceParallelMode |
string |
| configSpec. postgresqlConfig_10. clientMinMessages |
string |
| configSpec. postgresqlConfig_10. logMinMessages |
string |
| configSpec. postgresqlConfig_10. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_10. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_10. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_10. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_10. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_10. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_10. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_10. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_10. logStatement |
string |
| configSpec. postgresqlConfig_10. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_10. searchPath |
string |
| configSpec. postgresqlConfig_10. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_10. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_10. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10. byteaOutput |
string |
| configSpec. postgresqlConfig_10. xmlbinary |
string |
| configSpec. postgresqlConfig_10. xmloption |
string |
| configSpec. postgresqlConfig_10. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_10. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_10. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_10. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_10. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_10. backslashQuote |
string |
| configSpec. postgresqlConfig_10. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_10. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_10. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_10. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_10. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_10. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_10. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_10. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_10. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_10. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_10. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_10. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_10. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_10. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_10. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_10. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_10. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_10. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_10. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_10. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_10. timezone |
string |
| configSpec. postgresqlConfig_10. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_10. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_10. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_10. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_10. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_10. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_10. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_10. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_10. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_10. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_11 |
object Configuration for a PostgreSQL 11 cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_11. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_11. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_11. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_11. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_11. workMem |
integer (int64) |
| configSpec. postgresqlConfig_11. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_11. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_11. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_11. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_11. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_11. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_11. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_11. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_11. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_11. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_11. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_11. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11. walLevel |
string |
| configSpec. postgresqlConfig_11. synchronousCommit |
string |
| configSpec. postgresqlConfig_11. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_11. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_11. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_11. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_11. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_11. constraintExclusion |
string |
| configSpec. postgresqlConfig_11. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_11. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11. forceParallelMode |
string |
| configSpec. postgresqlConfig_11. clientMinMessages |
string |
| configSpec. postgresqlConfig_11. logMinMessages |
string |
| configSpec. postgresqlConfig_11. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_11. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_11. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_11. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_11. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_11. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_11. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_11. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_11. logStatement |
string |
| configSpec. postgresqlConfig_11. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_11. searchPath |
string |
| configSpec. postgresqlConfig_11. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_11. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_11. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11. byteaOutput |
string |
| configSpec. postgresqlConfig_11. xmlbinary |
string |
| configSpec. postgresqlConfig_11. xmloption |
string |
| configSpec. postgresqlConfig_11. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_11. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_11. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_11. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_11. backslashQuote |
string |
| configSpec. postgresqlConfig_11. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_11. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_11. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_11. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_11. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_11. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_11. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_11. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_11. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_11. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_11. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_11. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_11. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_11. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_11. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_11. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_11. timezone |
string |
| configSpec. postgresqlConfig_11. enableParallelAppend |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enableParallelHash |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enablePartitionPruning |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enablePartitionwiseAggregate |
boolean (boolean) |
| configSpec. postgresqlConfig_11. enablePartitionwiseJoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11. jit |
boolean (boolean) |
| configSpec. postgresqlConfig_11. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
| configSpec. postgresqlConfig_11. parallelLeaderParticipation |
boolean (boolean) |
| configSpec. postgresqlConfig_11. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
| configSpec. postgresqlConfig_11. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_11. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_11. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_11. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_11. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_11. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_11. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_11. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_11_1C |
object Configuration for a PostgreSQL 11 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_11_1C. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. workMem |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_11_1C. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_11_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11_1C. walLevel |
string |
| configSpec. postgresqlConfig_11_1C. synchronousCommit |
string |
| configSpec. postgresqlConfig_11_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11_1C. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_11_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_11_1C. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. constraintExclusion |
string |
| configSpec. postgresqlConfig_11_1C. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_11_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11_1C. forceParallelMode |
string |
| configSpec. postgresqlConfig_11_1C. clientMinMessages |
string |
| configSpec. postgresqlConfig_11_1C. logMinMessages |
string |
| configSpec. postgresqlConfig_11_1C. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_11_1C. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_11_1C. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. logStatement |
string |
| configSpec. postgresqlConfig_11_1C. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. searchPath |
string |
| configSpec. postgresqlConfig_11_1C. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_11_1C. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. byteaOutput |
string |
| configSpec. postgresqlConfig_11_1C. xmlbinary |
string |
| configSpec. postgresqlConfig_11_1C. xmloption |
string |
| configSpec. postgresqlConfig_11_1C. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_11_1C. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. backslashQuote |
string |
| configSpec. postgresqlConfig_11_1C. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_11_1C. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_11_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_11_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_11_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_11_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_11_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_11_1C. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_11_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11_1C. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. timezone |
string |
| configSpec. postgresqlConfig_11_1C. enableParallelAppend |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enableParallelHash |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enablePartitionPruning |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enablePartitionwiseAggregate |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. enablePartitionwiseJoin |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. jit |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
| configSpec. postgresqlConfig_11_1C. parallelLeaderParticipation |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
| configSpec. postgresqlConfig_11_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_11_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_11_1C. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_11_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_11_1C. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_11_1C. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_11_1C. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_11_1C. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_12 |
object Configuration for a PostgreSQL 12 cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_12. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_12. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_12. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_12. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_12. workMem |
integer (int64) |
| configSpec. postgresqlConfig_12. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_12. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_12. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_12. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_12. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_12. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_12. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_12. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_12. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_12. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_12. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_12. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12. walLevel |
string |
| configSpec. postgresqlConfig_12. synchronousCommit |
string |
| configSpec. postgresqlConfig_12. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_12. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_12. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_12. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_12. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_12. constraintExclusion |
string |
| configSpec. postgresqlConfig_12. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_12. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12. forceParallelMode |
string |
| configSpec. postgresqlConfig_12. clientMinMessages |
string |
| configSpec. postgresqlConfig_12. logMinMessages |
string |
| configSpec. postgresqlConfig_12. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_12. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_12. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_12. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_12. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_12. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_12. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_12. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_12. logStatement |
string |
| configSpec. postgresqlConfig_12. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_12. searchPath |
string |
| configSpec. postgresqlConfig_12. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_12. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_12. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12. byteaOutput |
string |
| configSpec. postgresqlConfig_12. xmlbinary |
string |
| configSpec. postgresqlConfig_12. xmloption |
string |
| configSpec. postgresqlConfig_12. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_12. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_12. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_12. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_12. backslashQuote |
string |
| configSpec. postgresqlConfig_12. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_12. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_12. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_12. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_12. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_12. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_12. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_12. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_12. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_12. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_12. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_12. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_12. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_12. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_12. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_12. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_12. timezone |
string |
| configSpec. postgresqlConfig_12. enableParallelAppend |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enableParallelHash |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enablePartitionPruning |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enablePartitionwiseAggregate |
boolean (boolean) |
| configSpec. postgresqlConfig_12. enablePartitionwiseJoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12. jit |
boolean (boolean) |
| configSpec. postgresqlConfig_12. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
| configSpec. postgresqlConfig_12. parallelLeaderParticipation |
boolean (boolean) |
| configSpec. postgresqlConfig_12. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
| configSpec. postgresqlConfig_12. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12. planCacheMode |
string |
| configSpec. postgresqlConfig_12. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_12. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_12. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_12. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_12. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_12. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_12. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_12. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_12_1C |
object Configuration for a PostgreSQL 12 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_12_1C. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. workMem |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_12_1C. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_12_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12_1C. walLevel |
string |
| configSpec. postgresqlConfig_12_1C. synchronousCommit |
string |
| configSpec. postgresqlConfig_12_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12_1C. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_12_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_12_1C. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. constraintExclusion |
string |
| configSpec. postgresqlConfig_12_1C. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_12_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12_1C. forceParallelMode |
string |
| configSpec. postgresqlConfig_12_1C. clientMinMessages |
string |
| configSpec. postgresqlConfig_12_1C. logMinMessages |
string |
| configSpec. postgresqlConfig_12_1C. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_12_1C. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_12_1C. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. logStatement |
string |
| configSpec. postgresqlConfig_12_1C. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. searchPath |
string |
| configSpec. postgresqlConfig_12_1C. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_12_1C. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. byteaOutput |
string |
| configSpec. postgresqlConfig_12_1C. xmlbinary |
string |
| configSpec. postgresqlConfig_12_1C. xmloption |
string |
| configSpec. postgresqlConfig_12_1C. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_12_1C. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. backslashQuote |
string |
| configSpec. postgresqlConfig_12_1C. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_12_1C. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_12_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_12_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_12_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_12_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_12_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_12_1C. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_12_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12_1C. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. timezone |
string |
| configSpec. postgresqlConfig_12_1C. enableParallelAppend |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enableParallelHash |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enablePartitionPruning |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enablePartitionwiseAggregate |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. enablePartitionwiseJoin |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. jit |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
| configSpec. postgresqlConfig_12_1C. parallelLeaderParticipation |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
| configSpec. postgresqlConfig_12_1C. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12_1C. planCacheMode |
string |
| configSpec. postgresqlConfig_12_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_12_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_12_1C. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_12_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_12_1C. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_12_1C. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_12_1C. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_12_1C. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_13 |
object Configuration for a PostgreSQL 13 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| configSpec. postgresqlConfig_13. maxConnections |
integer (int64) |
| configSpec. postgresqlConfig_13. sharedBuffers |
integer (int64) |
| configSpec. postgresqlConfig_13. tempBuffers |
integer (int64) |
| configSpec. postgresqlConfig_13. maxPreparedTransactions |
integer (int64) |
| configSpec. postgresqlConfig_13. workMem |
integer (int64) |
| configSpec. postgresqlConfig_13. maintenanceWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_13. autovacuumWorkMem |
integer (int64) |
| configSpec. postgresqlConfig_13. tempFileLimit |
integer (int64) |
| configSpec. postgresqlConfig_13. vacuumCostDelay |
integer (int64) |
| configSpec. postgresqlConfig_13. vacuumCostPageHit |
integer (int64) |
| configSpec. postgresqlConfig_13. vacuumCostPageMiss |
integer (int64) |
| configSpec. postgresqlConfig_13. vacuumCostPageDirty |
integer (int64) |
| configSpec. postgresqlConfig_13. vacuumCostLimit |
integer (int64) |
| configSpec. postgresqlConfig_13. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
| configSpec. postgresqlConfig_13. bgwriterLruMaxpages |
integer (int64) |
| configSpec. postgresqlConfig_13. bgwriterLruMultiplier |
number (double) |
| configSpec. postgresqlConfig_13. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_13. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_13. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
| configSpec. postgresqlConfig_13. walLevel |
string |
| configSpec. postgresqlConfig_13. synchronousCommit |
string |
| configSpec. postgresqlConfig_13. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_13. checkpointCompletionTarget |
number (double) |
| configSpec. postgresqlConfig_13. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| configSpec. postgresqlConfig_13. maxWalSize |
integer (int64) |
| configSpec. postgresqlConfig_13. minWalSize |
integer (int64) |
| configSpec. postgresqlConfig_13. maxStandbyStreamingDelay |
integer (int64) |
| configSpec. postgresqlConfig_13. defaultStatisticsTarget |
integer (int64) |
| configSpec. postgresqlConfig_13. constraintExclusion |
string |
| configSpec. postgresqlConfig_13. cursorTupleFraction |
number (double) |
| configSpec. postgresqlConfig_13. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. forceParallelMode |
string |
| configSpec. postgresqlConfig_13. clientMinMessages |
string |
| configSpec. postgresqlConfig_13. logMinMessages |
string |
| configSpec. postgresqlConfig_13. logMinErrorStatement |
string |
| configSpec. postgresqlConfig_13. logMinDurationStatement |
integer (int64) |
| configSpec. postgresqlConfig_13. logCheckpoints |
boolean (boolean) |
| configSpec. postgresqlConfig_13. logConnections |
boolean (boolean) |
| configSpec. postgresqlConfig_13. logDisconnections |
boolean (boolean) |
| configSpec. postgresqlConfig_13. logDuration |
boolean (boolean) |
| configSpec. postgresqlConfig_13. logErrorVerbosity |
string |
| configSpec. postgresqlConfig_13. logLockWaits |
boolean (boolean) |
| configSpec. postgresqlConfig_13. logStatement |
string |
| configSpec. postgresqlConfig_13. logTempFiles |
integer (int64) |
| configSpec. postgresqlConfig_13. searchPath |
string |
| configSpec. postgresqlConfig_13. rowSecurity |
boolean (boolean) |
| configSpec. postgresqlConfig_13. defaultTransactionIsolation |
string |
| configSpec. postgresqlConfig_13. statementTimeout |
integer (int64) |
| configSpec. postgresqlConfig_13. lockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_13. idleInTransactionSessionTimeout |
integer (int64) |
| configSpec. postgresqlConfig_13. byteaOutput |
string |
| configSpec. postgresqlConfig_13. xmlbinary |
string |
| configSpec. postgresqlConfig_13. xmloption |
string |
| configSpec. postgresqlConfig_13. ginPendingListLimit |
integer (int64) |
| configSpec. postgresqlConfig_13. deadlockTimeout |
integer (int64) |
| configSpec. postgresqlConfig_13. maxLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_13. maxPredLocksPerTransaction |
integer (int64) |
| configSpec. postgresqlConfig_13. arrayNulls |
boolean (boolean) |
| configSpec. postgresqlConfig_13. backslashQuote |
string |
| configSpec. postgresqlConfig_13. defaultWithOids |
boolean (boolean) |
| configSpec. postgresqlConfig_13. escapeStringWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_13. loCompatPrivileges |
boolean (boolean) |
| configSpec. postgresqlConfig_13. operatorPrecedenceWarning |
boolean (boolean) |
| configSpec. postgresqlConfig_13. quoteAllIdentifiers |
boolean (boolean) |
| configSpec. postgresqlConfig_13. standardConformingStrings |
boolean (boolean) |
| configSpec. postgresqlConfig_13. synchronizeSeqscans |
boolean (boolean) |
| configSpec. postgresqlConfig_13. transformNullEquals |
boolean (boolean) |
| configSpec. postgresqlConfig_13. exitOnError |
boolean (boolean) |
| configSpec. postgresqlConfig_13. seqPageCost |
number (double) |
| configSpec. postgresqlConfig_13. randomPageCost |
number (double) |
| configSpec. postgresqlConfig_13. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_13. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
| configSpec. postgresqlConfig_13. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
| configSpec. postgresqlConfig_13. enableBitmapscan |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableHashagg |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableHashjoin |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableIndexscan |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableIndexonlyscan |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableMaterial |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableMergejoin |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableNestloop |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableSeqscan |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableSort |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableTidscan |
boolean (boolean) |
| configSpec. postgresqlConfig_13. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_13. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_13. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_13. defaultTransactionReadOnly |
boolean (boolean) |
| configSpec. postgresqlConfig_13. timezone |
string |
| configSpec. postgresqlConfig_13. enableParallelAppend |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enableParallelHash |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enablePartitionPruning |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enablePartitionwiseAggregate |
boolean (boolean) |
| configSpec. postgresqlConfig_13. enablePartitionwiseJoin |
boolean (boolean) |
| configSpec. postgresqlConfig_13. jit |
boolean (boolean) |
| configSpec. postgresqlConfig_13. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
| configSpec. postgresqlConfig_13. parallelLeaderParticipation |
boolean (boolean) |
| configSpec. postgresqlConfig_13. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
| configSpec. postgresqlConfig_13. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_13. planCacheMode |
string |
| configSpec. postgresqlConfig_13. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_13. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| configSpec. postgresqlConfig_13. sharedPreloadLibraries[] |
string |
| configSpec. postgresqlConfig_13. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. autoExplainLogAnalyze |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainLogBuffers |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainLogTiming |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainLogTriggers |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainLogVerbose |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainLogNestedStatements |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_13. pgHintPlanEnableHint |
boolean (boolean) |
| configSpec. postgresqlConfig_13. pgHintPlanEnableHintTable |
boolean (boolean) |
| configSpec. postgresqlConfig_13. pgHintPlanDebugPrint |
string |
| configSpec. postgresqlConfig_13. pgHintPlanMessageLevel |
string |
| configSpec. postgresqlConfig_13. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_13. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
| configSpec. postgresqlConfig_13. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| configSpec. postgresqlConfig_13. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
| configSpec. postgresqlConfig_13. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
| configSpec. postgresqlConfig_13. enableIncrementalSort |
boolean (boolean) |
| configSpec. postgresqlConfig_13. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
| configSpec. postgresqlConfig_13. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
| configSpec. postgresqlConfig_13. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| configSpec. postgresqlConfig_13. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
| hostSpecs[] | object Required. Configurations for PostgreSQL hosts that should be created for the cluster that is being created from the backup. Must contain at least one element. |
| hostSpecs[]. zoneId |
string ID of the availability zone where the host resides. To get a list of available zones, use the list request. The maximum string length in characters is 50. |
| hostSpecs[]. subnetId |
string ID of the subnet that the host should belong to. This subnet should be a part of the network that the cluster belongs to. The ID of the network is set in the field Cluster.networkId. The maximum string length in characters is 50. |
| hostSpecs[]. assignPublicIp |
boolean (boolean) Whether the host should get a public IP address on creation. After a host has been created, this setting cannot be changed. To remove an assigned public IP, or to assign a public IP to a host without one, recreate the host with Possible values:
|
| hostSpecs[]. replicationSource |
string
|
| hostSpecs[]. priority |
integer (int64) Priority of the host as a replica. A higher value corresponds to higher priority. The host with the highest priority is the synchronous replica. All others are asynchronous. The synchronous replica replaces the master when needed. When a replica becomes the master, its priority is ignored. |
| hostSpecs[]. configSpec |
object Configuration of a PostgreSQL server for the host. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6 |
object Configuration for a host with PostgreSQL 9.6 server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. replacementSortTuples |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. sqlInheritance |
boolean (boolean) This option has been removed in PostgreSQL 10. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_9_6. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C |
object Configuration for a host with PostgreSQL 10 1C server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. replacementSortTuples |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10 |
object Configuration for a host with PostgreSQL 10 server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_10. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. replacementSortTuples |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_10. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_10. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_10. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_10. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11 |
object Configuration for a host with PostgreSQL 11 server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_11. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C |
object Configuration for a host with PostgreSQL 11 1C server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_11_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12 |
object Configuration for a host with PostgreSQL 12 server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_12. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C |
object Configuration for a host with PostgreSQL 12 1C server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_12_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13 |
object Configuration for a host with PostgreSQL 13 server deployed. hostSpecs[].configSpec includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10_1C, postgresqlConfig_10, postgresqlConfig_11, postgresqlConfig_11_1C, postgresqlConfig_12, postgresqlConfig_12_1C, postgresqlConfig_13Options and structure of |
| hostSpecs[]. configSpec. postgresqlConfig_13. recoveryMinApplyDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. sharedBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. tempBuffers |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. workMem |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. tempFileLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. maxStandbyStreamingDelay |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. constraintExclusion |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. cursorTupleFraction |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_13. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. forceParallelMode |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. clientMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. logMinMessages |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. logMinErrorStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. logMinDurationStatement |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logCheckpoints |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logConnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logDisconnections |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logDuration |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logErrorVerbosity |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. logLockWaits |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. logStatement |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. logTempFiles |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. searchPath |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. rowSecurity |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. defaultTransactionIsolation |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. statementTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. lockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. idleInTransactionSessionTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. byteaOutput |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. xmlbinary |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. xmloption |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. ginPendingListLimit |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. deadlockTimeout |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. maxLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. maxPredLocksPerTransaction |
integer (int64) |
| hostSpecs[]. configSpec. postgresqlConfig_13. arrayNulls |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. backslashQuote |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. defaultWithOids |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. escapeStringWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. loCompatPrivileges |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. operatorPrecedenceWarning |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. quoteAllIdentifiers |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. standardConformingStrings |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. synchronizeSeqscans |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. transformNullEquals |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. exitOnError |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. seqPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_13. randomPageCost |
number (double) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableBitmapscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableHashagg |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableHashjoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableIndexscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableIndexonlyscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableMaterial |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableMergejoin |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableNestloop |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableSeqscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableSort |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. enableTidscan |
boolean (boolean) |
| hostSpecs[]. configSpec. postgresqlConfig_13. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. timezone |
string |
| hostSpecs[]. configSpec. postgresqlConfig_13. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
| hostSpecs[]. configSpec. postgresqlConfig_13. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
| networkId | string Required. ID of the network to create the PostgreSQL cluster in. The maximum string length in characters is 50. |
| folderId | string ID of the folder to create the PostgreSQL cluster in. The maximum string length in characters is 50. |
| securityGroupIds[] | string User security groups |
Response
HTTP Code: 200 - OK
{
"id": "string",
"description": "string",
"createdAt": "string",
"createdBy": "string",
"modifiedAt": "string",
"done": true,
"metadata": "object",
// includes only one of the fields `error`, `response`
"error": {
"code": "integer",
"message": "string",
"details": [
"object"
]
},
"response": "object",
// end of the list of possible fields
}
An Operation resource. For more information, see Operation.
| Field | Description |
|---|---|
| id | string ID of the operation. |
| description | string Description of the operation. 0-256 characters long. |
| createdAt | string (date-time) Creation timestamp. String in RFC3339 text format. |
| createdBy | string ID of the user or service account who initiated the operation. |
| modifiedAt | string (date-time) The time when the Operation resource was last modified. String in RFC3339 text format. |
| done | boolean (boolean) If the value is |
| metadata | object Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any. |
| error | object The error result of the operation in case of failure or cancellation. includes only one of the fields error, responseThe error result of the operation in case of failure or cancellation. |
| error. code |
integer (int32) Error code. An enum value of google.rpc.Code. |
| error. message |
string An error message. |
| error. details[] |
object A list of messages that carry the error details. |
| response | object includes only one of the fields error, responseThe normal response of the operation in case of success. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is the standard Create/Update, the response should be the target resource of the operation. Any method that returns a long-running operation should document the response type, if any. |