Managed Service for PostgreSQL API, REST: Cluster.UpdateHosts
- HTTP request
- Path parameters
- Body parameters
- UpdateHostSpec
- ConfigHostSpec
- PostgresqlHostConfig9_6
- PostgresqlHostConfig10_1C
- PostgresqlHostConfig10
- PostgresqlHostConfig11
- PostgresqlHostConfig11_1C
- PostgresqlHostConfig12
- PostgresqlHostConfig12_1C
- PostgresqlHostConfig13
- PostgresqlHostConfig13_1C
- PostgresqlHostConfig14
- PostgresqlHostConfig14_1C
- PostgresqlHostConfig15
- PostgresqlHostConfig15_1C
- PostgresqlHostConfig16
- PostgresqlHostConfig16_1C
- PostgresqlHostConfig17
- PostgresqlHostConfig17_1C
- Response
- UpdateClusterHostsMetadata
- Status
Updates the specified hosts.
HTTP request
POST https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters/{clusterId}/hosts:batchUpdate
Path parameters
Field |
Description |
clusterId |
string Required field. ID of the PostgreSQL cluster to update hosts in. |
Body parameters
{
"updateHostSpecs": [
{
"hostName": "string",
"replicationSource": "string",
"priority": "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_13_1c`, `postgresqlConfig_14`, `postgresqlConfig_14_1c`, `postgresqlConfig_15`, `postgresqlConfig_15_1c`, `postgresqlConfig_16`, `postgresqlConfig_16_1c`, `postgresqlConfig_17`, `postgresqlConfig_17_1c`
"postgresqlConfig_9_6": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"sqlInheritance": "boolean",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_10_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_10": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"replacementSortTuples": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_11": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_11_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_12": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_12_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_13": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_13_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"operatorPrecedenceWarning": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_14": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_14_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_15": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_15_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_16": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_16_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"oldSnapshotThreshold": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_17": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
},
"postgresqlConfig_17_1c": {
"recoveryMinApplyDelay": "string",
"sharedBuffers": "string",
"tempBuffers": "string",
"workMem": "string",
"tempFileLimit": "string",
"backendFlushAfter": "string",
"maxStandbyStreamingDelay": "string",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "string",
"joinCollapseLimit": "string",
"debugParallelQuery": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "string",
"logCheckpoints": "boolean",
"logConnections": "boolean",
"logDisconnections": "boolean",
"logDuration": "boolean",
"logErrorVerbosity": "string",
"logLockWaits": "boolean",
"logStatement": "string",
"logTempFiles": "string",
"searchPath": "string",
"rowSecurity": "boolean",
"defaultTransactionIsolation": "string",
"statementTimeout": "string",
"lockTimeout": "string",
"idleInTransactionSessionTimeout": "string",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "string",
"deadlockTimeout": "string",
"maxLocksPerTransaction": "string",
"maxPredLocksPerTransaction": "string",
"arrayNulls": "boolean",
"backslashQuote": "string",
"defaultWithOids": "boolean",
"escapeStringWarning": "boolean",
"loCompatPrivileges": "boolean",
"quoteAllIdentifiers": "boolean",
"standardConformingStrings": "boolean",
"synchronizeSeqscans": "boolean",
"transformNullEquals": "boolean",
"exitOnError": "boolean",
"seqPageCost": "number",
"randomPageCost": "number",
"enableBitmapscan": "boolean",
"enableHashagg": "boolean",
"enableHashjoin": "boolean",
"enableIndexscan": "boolean",
"enableIndexonlyscan": "boolean",
"enableMaterial": "boolean",
"enableMergejoin": "boolean",
"enableNestloop": "boolean",
"enableSeqscan": "boolean",
"enableSort": "boolean",
"enableTidscan": "boolean",
"maxParallelWorkers": "string",
"maxParallelWorkersPerGather": "string",
"timezone": "string",
"effectiveIoConcurrency": "string",
"effectiveCacheSize": "string"
}
// end of the list of possible fields
},
"updateMask": "object",
"assignPublicIp": "boolean"
}
]
}
Field |
Description |
updateHostSpecs[] |
New configurations to apply to hosts. |
UpdateHostSpec
Field |
Description |
hostName |
string Required field. Name of the host to update. |
replicationSource |
string Host.name of the host to be used as the replication source (for cascading replication). |
priority |
string (int64) The host with the highest priority is the synchronous replica. All others are asynchronous. When a replica becomes the master, its priority is ignored. |
configSpec |
Configuration of a PostgreSQL server for the host. |
updateMask |
object (field-mask) A comma-separated names off ALL fields to be updated. If |
assignPublicIp |
boolean Whether the host should get a public IP address on creation. |
ConfigHostSpec
Field |
Description |
postgresqlConfig_9_6 |
Configuration for a host with PostgreSQL 9.6 server deployed. Includes only one of the fields |
postgresqlConfig_10_1c |
Configuration for a host with PostgreSQL 10 1C server deployed. Includes only one of the fields |
postgresqlConfig_10 |
Configuration for a host with PostgreSQL 10 server deployed. Includes only one of the fields |
postgresqlConfig_11 |
Configuration for a host with PostgreSQL 11 server deployed. Includes only one of the fields |
postgresqlConfig_11_1c |
Configuration for a host with PostgreSQL 11 1C server deployed. Includes only one of the fields |
postgresqlConfig_12 |
Configuration for a host with PostgreSQL 12 server deployed. Includes only one of the fields |
postgresqlConfig_12_1c |
Configuration for a host with PostgreSQL 12 1C server deployed. Includes only one of the fields |
postgresqlConfig_13 |
Configuration for a host with PostgreSQL 13 server deployed. Includes only one of the fields |
postgresqlConfig_13_1c |
Configuration for a host with PostgreSQL 13 1C server deployed. Includes only one of the fields |
postgresqlConfig_14 |
Configuration for a host with PostgreSQL 14 server deployed. Includes only one of the fields |
postgresqlConfig_14_1c |
Configuration for a host with PostgreSQL 14 1C server deployed. Includes only one of the fields |
postgresqlConfig_15 |
Configuration for a host with PostgreSQL 15 server deployed. Includes only one of the fields |
postgresqlConfig_15_1c |
Configuration for a host with PostgreSQL 15 1C server deployed. Includes only one of the fields |
postgresqlConfig_16 |
Configuration for a host with PostgreSQL 16 server deployed. Includes only one of the fields |
postgresqlConfig_16_1c |
Configuration for a host with PostgreSQL 16 1C server deployed. Includes only one of the fields |
postgresqlConfig_17 |
Configuration for a host with PostgreSQL 17 1C server deployed. Includes only one of the fields |
postgresqlConfig_17_1c |
Configuration for a host with PostgreSQL 17 1C server deployed. Includes only one of the fields |
PostgresqlHostConfig9_6
Options and structure of PostgresqlHostConfig
reflects parameters of a PostgreSQL
configuration file. Detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
replacementSortTuples |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
sqlInheritance |
boolean This option has been removed in PostgreSQL 10. |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig10_1C
Options and structure of PostgresqlHostConfig
reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
replacementSortTuples |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig10
Options and structure of PostgresqlHostConfig
reflects PostgreSQL configuration file
parameters whose detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
replacementSortTuples |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig11
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig11_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig12
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig12_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig13
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig13_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
operatorPrecedenceWarning |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig14
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig14_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig15
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig15_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
forceParallelMode |
enum (ForceParallelMode)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig16
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
debugParallelQuery |
enum (DebugParallelQuery)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig16_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
oldSnapshotThreshold |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
debugParallelQuery |
enum (DebugParallelQuery)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig17
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
debugParallelQuery |
enum (DebugParallelQuery)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
PostgresqlHostConfig17_1C
Options and structure of PostgresqlConfig
reflects PostgreSQL configuration file
parameters which detailed description is available in
PostgreSQL documentation
Field |
Description |
recoveryMinApplyDelay |
string (int64) in milliseconds. |
sharedBuffers |
string (int64) in bytes. |
tempBuffers |
string (int64) in bytes. |
workMem |
string (int64) in bytes. |
tempFileLimit |
string (int64) in bytes. |
backendFlushAfter |
string (int64) |
maxStandbyStreamingDelay |
string (int64) in milliseconds. |
constraintExclusion |
enum (ConstraintExclusion)
|
cursorTupleFraction |
number (double) |
fromCollapseLimit |
string (int64) |
joinCollapseLimit |
string (int64) |
debugParallelQuery |
enum (DebugParallelQuery)
|
clientMinMessages |
enum (LogLevel)
|
logMinMessages |
enum (LogLevel)
|
logMinErrorStatement |
enum (LogLevel)
|
logMinDurationStatement |
string (int64) in milliseconds. |
logCheckpoints |
boolean |
logConnections |
boolean |
logDisconnections |
boolean |
logDuration |
boolean |
logErrorVerbosity |
enum (LogErrorVerbosity)
|
logLockWaits |
boolean |
logStatement |
enum (LogStatement)
|
logTempFiles |
string (int64) |
searchPath |
string |
rowSecurity |
boolean |
defaultTransactionIsolation |
enum (TransactionIsolation)
|
statementTimeout |
string (int64) in milliseconds. |
lockTimeout |
string (int64) in milliseconds. |
idleInTransactionSessionTimeout |
string (int64) in milliseconds. |
byteaOutput |
enum (ByteaOutput)
|
xmlbinary |
enum (XmlBinary)
|
xmloption |
enum (XmlOption)
|
ginPendingListLimit |
string (int64) in bytes. |
deadlockTimeout |
string (int64) in milliseconds. |
maxLocksPerTransaction |
string (int64) |
maxPredLocksPerTransaction |
string (int64) |
arrayNulls |
boolean |
backslashQuote |
enum (BackslashQuote)
|
defaultWithOids |
boolean |
escapeStringWarning |
boolean |
loCompatPrivileges |
boolean |
quoteAllIdentifiers |
boolean |
standardConformingStrings |
boolean |
synchronizeSeqscans |
boolean |
transformNullEquals |
boolean |
exitOnError |
boolean |
seqPageCost |
number (double) |
randomPageCost |
number (double) |
enableBitmapscan |
boolean |
enableHashagg |
boolean |
enableHashjoin |
boolean |
enableIndexscan |
boolean |
enableIndexonlyscan |
boolean |
enableMaterial |
boolean |
enableMergejoin |
boolean |
enableNestloop |
boolean |
enableSeqscan |
boolean |
enableSort |
boolean |
enableTidscan |
boolean |
maxParallelWorkers |
string (int64) |
maxParallelWorkersPerGather |
string (int64) |
timezone |
string |
effectiveIoConcurrency |
string (int64) |
effectiveCacheSize |
string (int64) |
Response
HTTP Code: 200 - OK
{
"id": "string",
"description": "string",
"createdAt": "string",
"createdBy": "string",
"modifiedAt": "string",
"done": "boolean",
"metadata": {
"clusterId": "string",
"hostNames": [
"string"
]
},
// Includes only one of the fields `error`
"error": {
"code": "integer",
"message": "string",
"details": [
"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 To work with values in this field, use the APIs described in the |
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 To work with values in this field, use the APIs described in the |
done |
boolean If the value is |
metadata |
Service-specific metadata associated with the operation. |
error |
The error result of the operation in case of failure or cancellation. Includes only one of the fields The operation result. |
UpdateClusterHostsMetadata
Field |
Description |
clusterId |
string ID of the PostgreSQL cluster to update hosts in. |
hostNames[] |
string Names of hosts that are being updated. |
Status
The error result of the operation in case of failure or cancellation.
Field |
Description |
code |
integer (int32) Error code. An enum value of google.rpc.Code |
message |
string An error message. |
details[] |
object A list of messages that carry the error details. |