Managed Service for PostgreSQL API, REST: Cluster.listHosts
Retrieves a list of hosts for the specified cluster.
HTTP request
GET https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters/{clusterId}/hosts
Path parameters
Parameter | Description |
---|---|
clusterId | Required. ID of the PostgreSQL cluster. To get the PostgreSQL cluster ID use a list request. The maximum string length in characters is 50. |
Query parameters
Parameter | Description |
---|---|
pageSize | The maximum number of results per page to return. If the number of available results is larger than pageSize, the service returns a nextPageToken that can be used to get the next page of results in subsequent list requests. The maximum value is 1000. |
pageToken | Page token. To get the next page of results, set pageToken to the nextPageToken returned by the previous list request. The maximum string length in characters is 100. |
Response
HTTP Code: 200 - OK
{
"hosts": [
{
"name": "string",
"clusterId": "string",
"zoneId": "string",
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
},
"role": "string",
"health": "string",
"services": [
{
"type": "string",
"health": "string"
}
],
"subnetId": "string",
"replicationSource": "string",
"priority": "integer",
"config": {
// `hosts[].config` 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_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"
},
"postgresqlConfig_13_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_14": {
"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,
"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_14_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,
"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_15": {
"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,
"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_15_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,
"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_16": {
"recoveryMinApplyDelay": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"workMem": "integer",
"tempFileLimit": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"maxStandbyStreamingDelay": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"debugParallelQuery": "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,
"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_16_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",
"debugParallelQuery": "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,
"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`hosts[].config`
},
"assignPublicIp": true,
"replicaType": "string"
}
],
"nextPageToken": "string"
}
Field | Description |
---|---|
hosts[] | object List of Host resources. |
hosts[]. name |
string Name of the PostgreSQL host. The host name is assigned by MDB at creation time, and cannot be changed. 1-63 characters long. The name is unique across all MDB hosts that exist on the platform, as it defines the FQDN of the host. |
hosts[]. clusterId |
string ID of the PostgreSQL host. The ID is assigned by MDB at creation time. |
hosts[]. zoneId |
string ID of the availability zone where the PostgreSQL host resides. |
hosts[]. resources |
object Resources allocated to the PostgreSQL host. |
hosts[]. 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. |
hosts[]. resources. diskSize |
string (int64) Volume of the storage available to a host, in bytes. |
hosts[]. resources. diskTypeId |
string Type of the storage environment for the host. Possible values:
|
hosts[]. role |
string Role of the host in the cluster.
|
hosts[]. health |
string Status code of the aggregated health of the host.
|
hosts[]. services[] |
object Services provided by the host. |
hosts[]. services[]. type |
string Type of the service provided by the host.
|
hosts[]. services[]. health |
string Status code of server availability.
|
hosts[]. subnetId |
string ID of the subnet that the host belongs to. |
hosts[]. replicationSource |
string Name of the host to be used as the replication source for cascading replication. |
hosts[]. priority |
integer (int64) Priority of the host as a replica. Higher value means 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. |
hosts[]. config |
object Configuration of a PostgreSQL server for the host. |
hosts[]. config. postgresqlConfig_9_6 |
object Configuration for a host with PostgreSQL 9.6 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_9_6. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. replacementSortTuples |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_9_6. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_9_6. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_9_6. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_9_6. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_9_6. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_9_6. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_9_6. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_9_6. logMinMessages |
string |
hosts[]. config. postgresqlConfig_9_6. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_9_6. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_9_6. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. logStatement |
string |
hosts[]. config. postgresqlConfig_9_6. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. searchPath |
string |
hosts[]. config. postgresqlConfig_9_6. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_9_6. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. byteaOutput |
string |
hosts[]. config. postgresqlConfig_9_6. xmlbinary |
string |
hosts[]. config. postgresqlConfig_9_6. xmloption |
string |
hosts[]. config. postgresqlConfig_9_6. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_9_6. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. backslashQuote |
string |
hosts[]. config. postgresqlConfig_9_6. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_9_6. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_9_6. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_9_6. sqlInheritance |
boolean (boolean) This option has been removed in PostgreSQL 10. |
hosts[]. config. postgresqlConfig_9_6. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_9_6. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_10_1C |
object Configuration for a host with PostgreSQL 10 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_10_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. replacementSortTuples |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_10_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_10_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_10_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_10_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_10_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_10_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_10_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_10_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_10_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_10_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_10_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_10_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_10_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_10_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_10_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_10_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_10_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. timezone |
string |
hosts[]. config. postgresqlConfig_10_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_10_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_10 |
object Configuration for a host with PostgreSQL 10 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_10. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_10. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_10. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_10. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_10. replacementSortTuples |
integer (int64) |
hosts[]. config. postgresqlConfig_10. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_10. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_10. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_10. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_10. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_10. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_10. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_10. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_10. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_10. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_10. logMinMessages |
string |
hosts[]. config. postgresqlConfig_10. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_10. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_10. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_10. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. logStatement |
string |
hosts[]. config. postgresqlConfig_10. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_10. searchPath |
string |
hosts[]. config. postgresqlConfig_10. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_10. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10. byteaOutput |
string |
hosts[]. config. postgresqlConfig_10. xmlbinary |
string |
hosts[]. config. postgresqlConfig_10. xmloption |
string |
hosts[]. config. postgresqlConfig_10. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_10. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_10. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_10. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_10. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. backslashQuote |
string |
hosts[]. config. postgresqlConfig_10. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_10. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_10. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_10. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_10. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_10. timezone |
string |
hosts[]. config. postgresqlConfig_10. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_10. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_11 |
object Configuration for a host with PostgreSQL 11 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_11. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_11. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_11. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_11. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_11. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_11. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_11. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_11. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_11. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_11. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_11. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_11. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_11. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_11. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_11. logMinMessages |
string |
hosts[]. config. postgresqlConfig_11. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_11. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_11. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_11. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. logStatement |
string |
hosts[]. config. postgresqlConfig_11. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_11. searchPath |
string |
hosts[]. config. postgresqlConfig_11. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_11. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11. byteaOutput |
string |
hosts[]. config. postgresqlConfig_11. xmlbinary |
string |
hosts[]. config. postgresqlConfig_11. xmloption |
string |
hosts[]. config. postgresqlConfig_11. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_11. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_11. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_11. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. backslashQuote |
string |
hosts[]. config. postgresqlConfig_11. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_11. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_11. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_11. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_11. timezone |
string |
hosts[]. config. postgresqlConfig_11. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_11. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_11_1C |
object Configuration for a host with PostgreSQL 11 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_11_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_11_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_11_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_11_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_11_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_11_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_11_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_11_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_11_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_11_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_11_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_11_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_11_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_11_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_11_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_11_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_11_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_11_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_11_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. timezone |
string |
hosts[]. config. postgresqlConfig_11_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_11_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_12 |
object Configuration for a host with PostgreSQL 12 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_12. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_12. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_12. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_12. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_12. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_12. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_12. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_12. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_12. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_12. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_12. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_12. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_12. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_12. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_12. logMinMessages |
string |
hosts[]. config. postgresqlConfig_12. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_12. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_12. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_12. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. logStatement |
string |
hosts[]. config. postgresqlConfig_12. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_12. searchPath |
string |
hosts[]. config. postgresqlConfig_12. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_12. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12. byteaOutput |
string |
hosts[]. config. postgresqlConfig_12. xmlbinary |
string |
hosts[]. config. postgresqlConfig_12. xmloption |
string |
hosts[]. config. postgresqlConfig_12. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_12. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_12. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_12. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. backslashQuote |
string |
hosts[]. config. postgresqlConfig_12. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_12. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_12. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_12. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_12. timezone |
string |
hosts[]. config. postgresqlConfig_12. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_12. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_12_1C |
object Configuration for a host with PostgreSQL 12 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_12_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_12_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_12_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_12_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_12_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_12_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_12_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_12_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_12_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_12_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_12_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_12_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_12_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_12_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_12_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_12_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_12_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_12_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_12_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. timezone |
string |
hosts[]. config. postgresqlConfig_12_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_12_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_13 |
object Configuration for a host with PostgreSQL 13 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_13. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_13. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_13. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_13. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_13. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_13. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_13. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_13. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_13. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_13. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_13. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_13. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_13. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_13. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_13. logMinMessages |
string |
hosts[]. config. postgresqlConfig_13. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_13. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_13. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_13. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. logStatement |
string |
hosts[]. config. postgresqlConfig_13. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_13. searchPath |
string |
hosts[]. config. postgresqlConfig_13. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_13. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13. byteaOutput |
string |
hosts[]. config. postgresqlConfig_13. xmlbinary |
string |
hosts[]. config. postgresqlConfig_13. xmloption |
string |
hosts[]. config. postgresqlConfig_13. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_13. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_13. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_13. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. backslashQuote |
string |
hosts[]. config. postgresqlConfig_13. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_13. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_13. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_13. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_13. timezone |
string |
hosts[]. config. postgresqlConfig_13. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_13. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_13_1C |
object Configuration for a host with PostgreSQL 13 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_13_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_13_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_13_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_13_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_13_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_13_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_13_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_13_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_13_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_13_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_13_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_13_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_13_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_13_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_13_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_13_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. operatorPrecedenceWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_13_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_13_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_13_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. timezone |
string |
hosts[]. config. postgresqlConfig_13_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_13_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_14 |
object Configuration for a host with PostgreSQL 14 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_14. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_14. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_14. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_14. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_14. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_14. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_14. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_14. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_14. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_14. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_14. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_14. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_14. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_14. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_14. logMinMessages |
string |
hosts[]. config. postgresqlConfig_14. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_14. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_14. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_14. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. logStatement |
string |
hosts[]. config. postgresqlConfig_14. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_14. searchPath |
string |
hosts[]. config. postgresqlConfig_14. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_14. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14. byteaOutput |
string |
hosts[]. config. postgresqlConfig_14. xmlbinary |
string |
hosts[]. config. postgresqlConfig_14. xmloption |
string |
hosts[]. config. postgresqlConfig_14. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_14. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_14. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_14. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. backslashQuote |
string |
hosts[]. config. postgresqlConfig_14. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_14. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_14. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_14. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_14. timezone |
string |
hosts[]. config. postgresqlConfig_14. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_14. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_14_1C |
object Configuration for a host with PostgreSQL 14 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_14_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_14_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_14_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_14_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_14_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_14_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_14_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_14_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_14_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_14_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_14_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_14_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_14_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_14_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_14_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_14_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_14_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_14_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_14_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. timezone |
string |
hosts[]. config. postgresqlConfig_14_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_14_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_15 |
object Configuration for a host with PostgreSQL 15 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_15. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_15. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_15. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_15. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_15. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_15. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_15. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_15. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_15. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_15. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_15. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_15. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_15. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_15. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_15. logMinMessages |
string |
hosts[]. config. postgresqlConfig_15. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_15. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_15. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_15. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. logStatement |
string |
hosts[]. config. postgresqlConfig_15. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_15. searchPath |
string |
hosts[]. config. postgresqlConfig_15. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_15. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15. byteaOutput |
string |
hosts[]. config. postgresqlConfig_15. xmlbinary |
string |
hosts[]. config. postgresqlConfig_15. xmloption |
string |
hosts[]. config. postgresqlConfig_15. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_15. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_15. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_15. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. backslashQuote |
string |
hosts[]. config. postgresqlConfig_15. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_15. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_15. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_15. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_15. timezone |
string |
hosts[]. config. postgresqlConfig_15. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_15. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_15_1C |
object Configuration for a host with PostgreSQL 15 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_15_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_15_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_15_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. forceParallelMode |
string |
hosts[]. config. postgresqlConfig_15_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_15_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_15_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_15_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_15_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_15_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_15_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_15_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_15_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_15_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_15_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_15_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_15_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_15_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_15_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_15_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. timezone |
string |
hosts[]. config. postgresqlConfig_15_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_15_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_16 |
object Configuration for a host with PostgreSQL 16 server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_16. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_16. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_16. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_16. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_16. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_16. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_16. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_16. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_16. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_16. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_16. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_16. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_16. debugParallelQuery |
string |
hosts[]. config. postgresqlConfig_16. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_16. logMinMessages |
string |
hosts[]. config. postgresqlConfig_16. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_16. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_16. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_16. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. logStatement |
string |
hosts[]. config. postgresqlConfig_16. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_16. searchPath |
string |
hosts[]. config. postgresqlConfig_16. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_16. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16. byteaOutput |
string |
hosts[]. config. postgresqlConfig_16. xmlbinary |
string |
hosts[]. config. postgresqlConfig_16. xmloption |
string |
hosts[]. config. postgresqlConfig_16. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_16. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_16. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_16. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. backslashQuote |
string |
hosts[]. config. postgresqlConfig_16. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_16. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_16. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_16. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_16. timezone |
string |
hosts[]. config. postgresqlConfig_16. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_16. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. config. postgresqlConfig_16_1C |
object Configuration for a host with PostgreSQL 16 1C server deployed. hosts[].config 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 |
hosts[]. config. postgresqlConfig_16_1C. recoveryMinApplyDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. sharedBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. tempBuffers |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. workMem |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. tempFileLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. maxStandbyStreamingDelay |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. constraintExclusion |
string |
hosts[]. config. postgresqlConfig_16_1C. cursorTupleFraction |
number (double) |
hosts[]. config. postgresqlConfig_16_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. debugParallelQuery |
string |
hosts[]. config. postgresqlConfig_16_1C. clientMinMessages |
string |
hosts[]. config. postgresqlConfig_16_1C. logMinMessages |
string |
hosts[]. config. postgresqlConfig_16_1C. logMinErrorStatement |
string |
hosts[]. config. postgresqlConfig_16_1C. logMinDurationStatement |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. logCheckpoints |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. logConnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. logDisconnections |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. logDuration |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. logErrorVerbosity |
string |
hosts[]. config. postgresqlConfig_16_1C. logLockWaits |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. logStatement |
string |
hosts[]. config. postgresqlConfig_16_1C. logTempFiles |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. searchPath |
string |
hosts[]. config. postgresqlConfig_16_1C. rowSecurity |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. defaultTransactionIsolation |
string |
hosts[]. config. postgresqlConfig_16_1C. statementTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. lockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. idleInTransactionSessionTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. byteaOutput |
string |
hosts[]. config. postgresqlConfig_16_1C. xmlbinary |
string |
hosts[]. config. postgresqlConfig_16_1C. xmloption |
string |
hosts[]. config. postgresqlConfig_16_1C. ginPendingListLimit |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. deadlockTimeout |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. maxLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. maxPredLocksPerTransaction |
integer (int64) |
hosts[]. config. postgresqlConfig_16_1C. arrayNulls |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. backslashQuote |
string |
hosts[]. config. postgresqlConfig_16_1C. defaultWithOids |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. escapeStringWarning |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. loCompatPrivileges |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. quoteAllIdentifiers |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. standardConformingStrings |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. synchronizeSeqscans |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. transformNullEquals |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. exitOnError |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. seqPageCost |
number (double) |
hosts[]. config. postgresqlConfig_16_1C. randomPageCost |
number (double) |
hosts[]. config. postgresqlConfig_16_1C. enableBitmapscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableHashagg |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableHashjoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableIndexscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableIndexonlyscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableMaterial |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableMergejoin |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableNestloop |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableSeqscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableSort |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. enableTidscan |
boolean (boolean) |
hosts[]. config. postgresqlConfig_16_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. timezone |
string |
hosts[]. config. postgresqlConfig_16_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
hosts[]. config. postgresqlConfig_16_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
hosts[]. assignPublicIp |
boolean (boolean) Flag showing public IP assignment status to this host. |
hosts[]. replicaType |
string |
nextPageToken | string This token allows you to get the next page of results for list requests. If the number of results is larger than pageSize, use the nextPageToken as the value for the pageToken query parameter in the next list request. Each subsequent list request will have its own nextPageToken to continue paging through the results. |