Cluster

A set of methods for managing PostgreSQL Cluster resources.

JSON Representation

{
  "id": "string",
  "folderId": "string",
  "createdAt": "string",
  "name": "string",
  "description": "string",
  "labels": "object",
  "environment": "string",
  "monitoring": [
    {
      "name": "string",
      "description": "string",
      "link": "string"
    }
  ],
  "config": {
    "version": "string",
    "poolerConfig": {
      "poolingMode": "string"
    },
    "resources": {
      "resourcePresetId": "string",
      "diskSize": "string",
      "diskTypeId": "string"
    },
    "autofailover": true,
    "backupWindowStart": {
      "hours": "integer",
      "minutes": "integer",
      "seconds": "integer",
      "nanos": "integer"
    },

    // `config` includes only one of the fields `postgresqlConfig_9_6`, `postgresqlConfig_10`, `postgresqlConfig_11`
    "postgresqlConfig_9_6": {
      "effectiveConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "sqlInheritance": true,
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "userConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "sqlInheritance": true,
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "defaultConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "sqlInheritance": true,
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      }
    },
    "postgresqlConfig_10": {
      "effectiveConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "userConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "defaultConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "replacementSortTuples": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      }
    },
    "postgresqlConfig_11": {
      "effectiveConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "userConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      },
      "defaultConfig": {
        "maxConnections": "integer",
        "sharedBuffers": "integer",
        "tempBuffers": "integer",
        "maxPreparedTransactions": "integer",
        "workMem": "integer",
        "maintenanceWorkMem": "integer",
        "autovacuumWorkMem": "integer",
        "tempFileLimit": "integer",
        "vacuumCostDelay": "integer",
        "vacuumCostPageHit": "integer",
        "vacuumCostPageMiss": "integer",
        "vacuumCostPageDirty": "integer",
        "vacuumCostLimit": "integer",
        "bgwriterDelay": "integer",
        "bgwriterLruMaxpages": "integer",
        "bgwriterLruMultiplier": "number",
        "bgwriterFlushAfter": "integer",
        "backendFlushAfter": "integer",
        "oldSnapshotThreshold": "integer",
        "walLevel": "string",
        "synchronousCommit": "string",
        "checkpointTimeout": "integer",
        "checkpointCompletionTarget": "number",
        "checkpointFlushAfter": "integer",
        "maxWalSize": "integer",
        "minWalSize": "integer",
        "maxStandbyStreamingDelay": "integer",
        "defaultStatisticsTarget": "integer",
        "constraintExclusion": "string",
        "cursorTupleFraction": "number",
        "fromCollapseLimit": "integer",
        "joinCollapseLimit": "integer",
        "forceParallelMode": "string",
        "clientMinMessages": "string",
        "logMinMessages": "string",
        "logMinErrorStatement": "string",
        "logMinDurationStatement": "integer",
        "logCheckpoints": true,
        "logConnections": true,
        "logDisconnections": true,
        "logDuration": true,
        "logErrorVerbosity": "string",
        "logLockWaits": true,
        "logStatement": "string",
        "logTempFiles": "integer",
        "searchPath": "string",
        "rowSecurity": true,
        "defaultTransactionIsolation": "string",
        "statementTimeout": "integer",
        "lockTimeout": "integer",
        "idleInTransactionSessionTimeout": "integer",
        "byteaOutput": "string",
        "xmlbinary": "string",
        "xmloption": "string",
        "ginPendingListLimit": "integer",
        "deadlockTimeout": "integer",
        "maxLocksPerTransaction": "integer",
        "maxPredLocksPerTransaction": "integer",
        "arrayNulls": true,
        "backslashQuote": "string",
        "defaultWithOids": true,
        "escapeStringWarning": true,
        "loCompatPrivileges": true,
        "operatorPrecedenceWarning": true,
        "quoteAllIdentifiers": true,
        "standardConformingStrings": true,
        "synchronizeSeqscans": true,
        "transformNullEquals": true,
        "exitOnError": true,
        "seqPageCost": "number",
        "randomPageCost": "number",
        "autovacuumMaxWorkers": "integer",
        "autovacuumVacuumCostDelay": "integer",
        "autovacuumVacuumCostLimit": "integer",
        "autovacuumNaptime": "integer",
        "archiveTimeout": "integer",
        "trackActivityQuerySize": "integer"
      }
    },
    // end of the list of possible fields`config`

  },
  "networkId": "string",
  "health": "string",
  "status": "string"
}
Field Description
id string

ID of the PostgreSQL cluster. This ID is assigned by MDB at creation time.

folderId string

ID of the folder that the PostgreSQL cluster belongs to.

createdAt string (date-time)

Creation timestamp in RFC3339 text format.

String in RFC3339 text format.

name string

Name of the PostgreSQL cluster. The name is unique within the folder. 1-63 characters long.

description string

Description of the PostgreSQL cluster. 0-256 characters long.

labels object

Custom labels for the PostgreSQL cluster as key:value pairs. Maximum 64 per resource.

environment string

Deployment environment of the PostgreSQL cluster.

  • PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance.
  • PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[] object

Monitoring system.

monitoring[].
name
string

Name of the monitoring system.

monitoring[].
description
string

Description of the monitoring system.

monitoring[].
link
string

Link to the monitoring system charts for the PostgreSQL cluster.

config object

Configuration of the PostgreSQL cluster.

config.
version
string

Version of PostgreSQL server software.

config.
poolerConfig
object
config.
poolerConfig.
poolingMode
string

Mode that the connection pooler is working in. See descriptions of all modes in the documentation for PgBouncer.

  • SESSION: Session pooling mode.
  • TRANSACTION: Transaction pooling mode.
  • STATEMENT: Statement pooling mode.
config.
resources
object
config.
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.

config.
resources.
diskSize
string (int64)

Volume of the storage available to a host, in bytes.

config.
resources.
diskTypeId
string

Type of the storage environment for the host. Possible values:

  • network-hdd — network HDD drive,
  • network-nvme — network SSD drive,
  • local-nvme — local SSD storage.
config.
autofailover
boolean (boolean)

Configuration setting which enables/disables autofailover in cluster.

config.
backupWindowStart
object

Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are [google.type.Date][google.type.Date] and google.protobuf.Timestamp.

config.
backupWindowStart.
hours
integer (int32)

Hours of day in 24 hour format. Should be from 0 to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time.

config.
backupWindowStart.
minutes
integer (int32)

Minutes of hour of day. Must be from 0 to 59.

config.
backupWindowStart.
seconds
integer (int32)

Seconds of minutes of the time. Must normally be from 0 to 59. An API may allow the value 60 if it allows leap-seconds.

config.
backupWindowStart.
nanos
integer (int32)

Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999.

config.
postgresqlConfig_9_6
object
config includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10, postgresqlConfig_11

config.
postgresqlConfig_9_6.
effectiveConfig
object

Required. Effective settings for a PostgreSQL 9.6 cluster (a combination of settings defined in userConfig and [default_config]).

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

config.
postgresqlConfig_9_6.
effectiveConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
workMem
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_9_6.
effectiveConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
walLevel
string
config.
postgresqlConfig_9_6.
effectiveConfig.
synchronousCommit
string
config.
postgresqlConfig_9_6.
effectiveConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_9_6.
effectiveConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
constraintExclusion
string
config.
postgresqlConfig_9_6.
effectiveConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_9_6.
effectiveConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
forceParallelMode
string
config.
postgresqlConfig_9_6.
effectiveConfig.
clientMinMessages
string
config.
postgresqlConfig_9_6.
effectiveConfig.
logMinMessages
string
config.
postgresqlConfig_9_6.
effectiveConfig.
logMinErrorStatement
string
config.
postgresqlConfig_9_6.
effectiveConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
logErrorVerbosity
string
config.
postgresqlConfig_9_6.
effectiveConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
logStatement
string
config.
postgresqlConfig_9_6.
effectiveConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
searchPath
string
config.
postgresqlConfig_9_6.
effectiveConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_9_6.
effectiveConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
byteaOutput
string
config.
postgresqlConfig_9_6.
effectiveConfig.
xmlbinary
string
config.
postgresqlConfig_9_6.
effectiveConfig.
xmloption
string
config.
postgresqlConfig_9_6.
effectiveConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
effectiveConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
backslashQuote
string
config.
postgresqlConfig_9_6.
effectiveConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_9_6.
effectiveConfig.
seqPageCost
number (double)
config.
postgresqlConfig_9_6.
effectiveConfig.
randomPageCost
number (double)
config.
postgresqlConfig_9_6.
effectiveConfig.
sqlInheritance
boolean (boolean)

This option has been removed in PostgreSQL 10.

config.
postgresqlConfig_9_6.
effectiveConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_9_6.
effectiveConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_9_6.
userConfig
object

User-defined settings for a PostgreSQL 9.6 cluster.

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

config.
postgresqlConfig_9_6.
userConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
workMem
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_9_6.
userConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
walLevel
string
config.
postgresqlConfig_9_6.
userConfig.
synchronousCommit
string
config.
postgresqlConfig_9_6.
userConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_9_6.
userConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
constraintExclusion
string
config.
postgresqlConfig_9_6.
userConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_9_6.
userConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
forceParallelMode
string
config.
postgresqlConfig_9_6.
userConfig.
clientMinMessages
string
config.
postgresqlConfig_9_6.
userConfig.
logMinMessages
string
config.
postgresqlConfig_9_6.
userConfig.
logMinErrorStatement
string
config.
postgresqlConfig_9_6.
userConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
logErrorVerbosity
string
config.
postgresqlConfig_9_6.
userConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
logStatement
string
config.
postgresqlConfig_9_6.
userConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
searchPath
string
config.
postgresqlConfig_9_6.
userConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_9_6.
userConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
byteaOutput
string
config.
postgresqlConfig_9_6.
userConfig.
xmlbinary
string
config.
postgresqlConfig_9_6.
userConfig.
xmloption
string
config.
postgresqlConfig_9_6.
userConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
userConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
backslashQuote
string
config.
postgresqlConfig_9_6.
userConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_9_6.
userConfig.
seqPageCost
number (double)
config.
postgresqlConfig_9_6.
userConfig.
randomPageCost
number (double)
config.
postgresqlConfig_9_6.
userConfig.
sqlInheritance
boolean (boolean)

This option has been removed in PostgreSQL 10.

config.
postgresqlConfig_9_6.
userConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_9_6.
userConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig
object

Default configuration for a PostgreSQL 9.6 cluster.

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

config.
postgresqlConfig_9_6.
defaultConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
workMem
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_9_6.
defaultConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
walLevel
string
config.
postgresqlConfig_9_6.
defaultConfig.
synchronousCommit
string
config.
postgresqlConfig_9_6.
defaultConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_9_6.
defaultConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
constraintExclusion
string
config.
postgresqlConfig_9_6.
defaultConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_9_6.
defaultConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
forceParallelMode
string
config.
postgresqlConfig_9_6.
defaultConfig.
clientMinMessages
string
config.
postgresqlConfig_9_6.
defaultConfig.
logMinMessages
string
config.
postgresqlConfig_9_6.
defaultConfig.
logMinErrorStatement
string
config.
postgresqlConfig_9_6.
defaultConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
logErrorVerbosity
string
config.
postgresqlConfig_9_6.
defaultConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
logStatement
string
config.
postgresqlConfig_9_6.
defaultConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
searchPath
string
config.
postgresqlConfig_9_6.
defaultConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_9_6.
defaultConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
byteaOutput
string
config.
postgresqlConfig_9_6.
defaultConfig.
xmlbinary
string
config.
postgresqlConfig_9_6.
defaultConfig.
xmloption
string
config.
postgresqlConfig_9_6.
defaultConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_9_6.
defaultConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
backslashQuote
string
config.
postgresqlConfig_9_6.
defaultConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_9_6.
defaultConfig.
seqPageCost
number (double)
config.
postgresqlConfig_9_6.
defaultConfig.
randomPageCost
number (double)
config.
postgresqlConfig_9_6.
defaultConfig.
sqlInheritance
boolean (boolean)

This option has been removed in PostgreSQL 10.

config.
postgresqlConfig_9_6.
defaultConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_9_6.
defaultConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_10
object
config includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10, postgresqlConfig_11

config.
postgresqlConfig_10.
effectiveConfig
object

Required. Effective settings for a PostgreSQL 10 cluster (a combination of settings defined in userConfig and [default_config]).

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

config.
postgresqlConfig_10.
effectiveConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
workMem
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_10.
effectiveConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
walLevel
string
config.
postgresqlConfig_10.
effectiveConfig.
synchronousCommit
string
config.
postgresqlConfig_10.
effectiveConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_10.
effectiveConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
constraintExclusion
string
config.
postgresqlConfig_10.
effectiveConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_10.
effectiveConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
forceParallelMode
string
config.
postgresqlConfig_10.
effectiveConfig.
clientMinMessages
string
config.
postgresqlConfig_10.
effectiveConfig.
logMinMessages
string
config.
postgresqlConfig_10.
effectiveConfig.
logMinErrorStatement
string
config.
postgresqlConfig_10.
effectiveConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
logErrorVerbosity
string
config.
postgresqlConfig_10.
effectiveConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
logStatement
string
config.
postgresqlConfig_10.
effectiveConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
searchPath
string
config.
postgresqlConfig_10.
effectiveConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_10.
effectiveConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
byteaOutput
string
config.
postgresqlConfig_10.
effectiveConfig.
xmlbinary
string
config.
postgresqlConfig_10.
effectiveConfig.
xmloption
string
config.
postgresqlConfig_10.
effectiveConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
effectiveConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
backslashQuote
string
config.
postgresqlConfig_10.
effectiveConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_10.
effectiveConfig.
seqPageCost
number (double)
config.
postgresqlConfig_10.
effectiveConfig.
randomPageCost
number (double)
config.
postgresqlConfig_10.
effectiveConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_10.
effectiveConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_10.
userConfig
object

User-defined settings for a PostgreSQL 10 cluster.

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

config.
postgresqlConfig_10.
userConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_10.
userConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_10.
userConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_10.
userConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_10.
userConfig.
workMem
integer (int64)
config.
postgresqlConfig_10.
userConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_10.
userConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_10.
userConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_10.
userConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_10.
userConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_10.
userConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_10.
userConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_10.
userConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_10.
userConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_10.
userConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_10.
userConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_10.
userConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_10.
userConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
userConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
userConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_10.
userConfig.
walLevel
string
config.
postgresqlConfig_10.
userConfig.
synchronousCommit
string
config.
postgresqlConfig_10.
userConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_10.
userConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_10.
userConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
userConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_10.
userConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_10.
userConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_10.
userConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_10.
userConfig.
constraintExclusion
string
config.
postgresqlConfig_10.
userConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_10.
userConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
userConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
userConfig.
forceParallelMode
string
config.
postgresqlConfig_10.
userConfig.
clientMinMessages
string
config.
postgresqlConfig_10.
userConfig.
logMinMessages
string
config.
postgresqlConfig_10.
userConfig.
logMinErrorStatement
string
config.
postgresqlConfig_10.
userConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_10.
userConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
logErrorVerbosity
string
config.
postgresqlConfig_10.
userConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
logStatement
string
config.
postgresqlConfig_10.
userConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_10.
userConfig.
searchPath
string
config.
postgresqlConfig_10.
userConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_10.
userConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_10.
userConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_10.
userConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_10.
userConfig.
byteaOutput
string
config.
postgresqlConfig_10.
userConfig.
xmlbinary
string
config.
postgresqlConfig_10.
userConfig.
xmloption
string
config.
postgresqlConfig_10.
userConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_10.
userConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_10.
userConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
userConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
userConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
backslashQuote
string
config.
postgresqlConfig_10.
userConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_10.
userConfig.
seqPageCost
number (double)
config.
postgresqlConfig_10.
userConfig.
randomPageCost
number (double)
config.
postgresqlConfig_10.
userConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_10.
userConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_10.
userConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_10.
userConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_10.
userConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_10.
userConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_10.
defaultConfig
object

Default configuration for a PostgreSQL 10 cluster.

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

config.
postgresqlConfig_10.
defaultConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
workMem
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
replacementSortTuples
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_10.
defaultConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
walLevel
string
config.
postgresqlConfig_10.
defaultConfig.
synchronousCommit
string
config.
postgresqlConfig_10.
defaultConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_10.
defaultConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
constraintExclusion
string
config.
postgresqlConfig_10.
defaultConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_10.
defaultConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
forceParallelMode
string
config.
postgresqlConfig_10.
defaultConfig.
clientMinMessages
string
config.
postgresqlConfig_10.
defaultConfig.
logMinMessages
string
config.
postgresqlConfig_10.
defaultConfig.
logMinErrorStatement
string
config.
postgresqlConfig_10.
defaultConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
logErrorVerbosity
string
config.
postgresqlConfig_10.
defaultConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
logStatement
string
config.
postgresqlConfig_10.
defaultConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
searchPath
string
config.
postgresqlConfig_10.
defaultConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_10.
defaultConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
byteaOutput
string
config.
postgresqlConfig_10.
defaultConfig.
xmlbinary
string
config.
postgresqlConfig_10.
defaultConfig.
xmloption
string
config.
postgresqlConfig_10.
defaultConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_10.
defaultConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
backslashQuote
string
config.
postgresqlConfig_10.
defaultConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_10.
defaultConfig.
seqPageCost
number (double)
config.
postgresqlConfig_10.
defaultConfig.
randomPageCost
number (double)
config.
postgresqlConfig_10.
defaultConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_10.
defaultConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_11
object
config includes only one of the fields postgresqlConfig_9_6, postgresqlConfig_10, postgresqlConfig_11

config.
postgresqlConfig_11.
effectiveConfig
object

Effective settings for a PostgreSQL 11 cluster (a combination of settings defined in userConfig and [default_config]).

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

config.
postgresqlConfig_11.
effectiveConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
workMem
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_11.
effectiveConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
walLevel
string
config.
postgresqlConfig_11.
effectiveConfig.
synchronousCommit
string
config.
postgresqlConfig_11.
effectiveConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_11.
effectiveConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
constraintExclusion
string
config.
postgresqlConfig_11.
effectiveConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_11.
effectiveConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
forceParallelMode
string
config.
postgresqlConfig_11.
effectiveConfig.
clientMinMessages
string
config.
postgresqlConfig_11.
effectiveConfig.
logMinMessages
string
config.
postgresqlConfig_11.
effectiveConfig.
logMinErrorStatement
string
config.
postgresqlConfig_11.
effectiveConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
logErrorVerbosity
string
config.
postgresqlConfig_11.
effectiveConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
logStatement
string
config.
postgresqlConfig_11.
effectiveConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
searchPath
string
config.
postgresqlConfig_11.
effectiveConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_11.
effectiveConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
byteaOutput
string
config.
postgresqlConfig_11.
effectiveConfig.
xmlbinary
string
config.
postgresqlConfig_11.
effectiveConfig.
xmloption
string
config.
postgresqlConfig_11.
effectiveConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
effectiveConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
backslashQuote
string
config.
postgresqlConfig_11.
effectiveConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_11.
effectiveConfig.
seqPageCost
number (double)
config.
postgresqlConfig_11.
effectiveConfig.
randomPageCost
number (double)
config.
postgresqlConfig_11.
effectiveConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_11.
effectiveConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_11.
userConfig
object

User-defined settings for a PostgreSQL 11 cluster.

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

config.
postgresqlConfig_11.
userConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_11.
userConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_11.
userConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_11.
userConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_11.
userConfig.
workMem
integer (int64)
config.
postgresqlConfig_11.
userConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_11.
userConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_11.
userConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_11.
userConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_11.
userConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_11.
userConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_11.
userConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_11.
userConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_11.
userConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_11.
userConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_11.
userConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_11.
userConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
userConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
userConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_11.
userConfig.
walLevel
string
config.
postgresqlConfig_11.
userConfig.
synchronousCommit
string
config.
postgresqlConfig_11.
userConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_11.
userConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_11.
userConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
userConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_11.
userConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_11.
userConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_11.
userConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_11.
userConfig.
constraintExclusion
string
config.
postgresqlConfig_11.
userConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_11.
userConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
userConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
userConfig.
forceParallelMode
string
config.
postgresqlConfig_11.
userConfig.
clientMinMessages
string
config.
postgresqlConfig_11.
userConfig.
logMinMessages
string
config.
postgresqlConfig_11.
userConfig.
logMinErrorStatement
string
config.
postgresqlConfig_11.
userConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_11.
userConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
logErrorVerbosity
string
config.
postgresqlConfig_11.
userConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
logStatement
string
config.
postgresqlConfig_11.
userConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_11.
userConfig.
searchPath
string
config.
postgresqlConfig_11.
userConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_11.
userConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_11.
userConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_11.
userConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_11.
userConfig.
byteaOutput
string
config.
postgresqlConfig_11.
userConfig.
xmlbinary
string
config.
postgresqlConfig_11.
userConfig.
xmloption
string
config.
postgresqlConfig_11.
userConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_11.
userConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_11.
userConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
userConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
userConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
backslashQuote
string
config.
postgresqlConfig_11.
userConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_11.
userConfig.
seqPageCost
number (double)
config.
postgresqlConfig_11.
userConfig.
randomPageCost
number (double)
config.
postgresqlConfig_11.
userConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_11.
userConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_11.
userConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_11.
userConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_11.
userConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_11.
userConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

config.
postgresqlConfig_11.
defaultConfig
object

Default configuration for a PostgreSQL 11 cluster.

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

config.
postgresqlConfig_11.
defaultConfig.
maxConnections
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
sharedBuffers
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
tempBuffers
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
maxPreparedTransactions
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
workMem
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
maintenanceWorkMem
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
autovacuumWorkMem
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
tempFileLimit
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
vacuumCostDelay
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
vacuumCostPageHit
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
vacuumCostPageMiss
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
vacuumCostPageDirty
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
vacuumCostLimit
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
bgwriterDelay
integer (int64)

Acceptable values are 10 to 10000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
bgwriterLruMaxpages
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
bgwriterLruMultiplier
number (double)
config.
postgresqlConfig_11.
defaultConfig.
bgwriterFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
backendFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
oldSnapshotThreshold
integer (int64)

Acceptable values are -1 to 86400000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
walLevel
string
config.
postgresqlConfig_11.
defaultConfig.
synchronousCommit
string
config.
postgresqlConfig_11.
defaultConfig.
checkpointTimeout
integer (int64)

Acceptable values are 30000 to 86400000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
checkpointCompletionTarget
number (double)
config.
postgresqlConfig_11.
defaultConfig.
checkpointFlushAfter
integer (int64)

Acceptable values are 0 to 2048, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
maxWalSize
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
minWalSize
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
maxStandbyStreamingDelay
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
defaultStatisticsTarget
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
constraintExclusion
string
config.
postgresqlConfig_11.
defaultConfig.
cursorTupleFraction
number (double)
config.
postgresqlConfig_11.
defaultConfig.
fromCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
joinCollapseLimit
integer (int64)

Acceptable values are 1 to 2147483647, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
forceParallelMode
string
config.
postgresqlConfig_11.
defaultConfig.
clientMinMessages
string
config.
postgresqlConfig_11.
defaultConfig.
logMinMessages
string
config.
postgresqlConfig_11.
defaultConfig.
logMinErrorStatement
string
config.
postgresqlConfig_11.
defaultConfig.
logMinDurationStatement
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
logCheckpoints
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
logConnections
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
logDisconnections
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
logDuration
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
logErrorVerbosity
string
config.
postgresqlConfig_11.
defaultConfig.
logLockWaits
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
logStatement
string
config.
postgresqlConfig_11.
defaultConfig.
logTempFiles
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
searchPath
string
config.
postgresqlConfig_11.
defaultConfig.
rowSecurity
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
defaultTransactionIsolation
string
config.
postgresqlConfig_11.
defaultConfig.
statementTimeout
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
lockTimeout
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
idleInTransactionSessionTimeout
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
byteaOutput
string
config.
postgresqlConfig_11.
defaultConfig.
xmlbinary
string
config.
postgresqlConfig_11.
defaultConfig.
xmloption
string
config.
postgresqlConfig_11.
defaultConfig.
ginPendingListLimit
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
deadlockTimeout
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
maxLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
maxPredLocksPerTransaction
integer (int64)
config.
postgresqlConfig_11.
defaultConfig.
arrayNulls
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
backslashQuote
string
config.
postgresqlConfig_11.
defaultConfig.
defaultWithOids
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
escapeStringWarning
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
loCompatPrivileges
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
operatorPrecedenceWarning
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
quoteAllIdentifiers
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
standardConformingStrings
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
synchronizeSeqscans
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
transformNullEquals
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
exitOnError
boolean (boolean)
config.
postgresqlConfig_11.
defaultConfig.
seqPageCost
number (double)
config.
postgresqlConfig_11.
defaultConfig.
randomPageCost
number (double)
config.
postgresqlConfig_11.
defaultConfig.
autovacuumMaxWorkers
integer (int64)

Acceptable values are 1 to 32, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
autovacuumVacuumCostDelay
integer (int64)

Acceptable values are -1 to 100, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
autovacuumVacuumCostLimit
integer (int64)

Acceptable values are -1 to 10000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
autovacuumNaptime
integer (int64)

Acceptable values are 1000 to 86400000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
archiveTimeout
integer (int64)

Acceptable values are 10000 to 600000, inclusive.

config.
postgresqlConfig_11.
defaultConfig.
trackActivityQuerySize
integer (int64)

Acceptable values are 100 to 102400, inclusive.

networkId string

ID of the network that the cluster belongs to.

health string

Aggregated cluster health.

  • HEALTH_UNKNOWN: State of the cluster is unknown ([Host.health] for every host in the cluster is UNKNOWN).
  • ALIVE: Cluster is alive and well ([Host.health] for every host in the cluster is ALIVE).
  • DEAD: Cluster is inoperable ([Host.health] for every host in the cluster is DEAD).
  • DEGRADED: Cluster is working below capacity ([Host.health] for at least one host in the cluster is not ALIVE).
status string

Current state of the cluster.

  • STATUS_UNKNOWN: Cluster state is unknown.
  • CREATING: Cluster is being created.
  • RUNNING: Cluster is running normally.
  • ERROR: Cluster encountered a problem and cannot operate.
  • UPDATING: Cluster is being updated.
  • STOPPING: Cluster is stopping.
  • STOPPED: Cluster stopped.
  • STARTING: Cluster is starting.

Methods

Method Description
addHosts Creates new hosts for a cluster.
backup Creates a backup for the specified PostgreSQL cluster.
create Creates a PostgreSQL cluster in the specified folder.
delete Deletes the specified PostgreSQL cluster.
deleteHosts Deletes the specified hosts for a cluster.
get Returns the specified PostgreSQL Cluster resource.
list Retrieves the list of PostgreSQL Cluster resources that belong to the specified folder.
listBackups Retrieves the list of available backups for the specified PostgreSQL cluster.
listHosts Retrieves a list of hosts for the specified cluster.
listLogs Retrieves logs for the specified PostgreSQL cluster. For more information about logs, see the Logs section in the documentation.
listOperations Retrieves the list of Operation resources for the specified cluster.
move Moves the specified PostgreSQL cluster to the specified folder.
restore Creates a new PostgreSQL cluster using the specified backup.
start Start the specified PostgreSQL cluster.
stop Stop the specified PostgreSQL cluster.
update Updates the specified PostgreSQL cluster.
updateHosts Updates the specified hosts.