Managed Databases

Update a managed database

patch/managed_databases/{id}

Path parameters

idstring required

Managed database ID

Request body

Example request

{
  "data": {
    "attributes": {
      "trusted_sources": [
        "203.0.113.0/24",
        "198.51.100.0/24"
      ],
      "parameters": {
        "shared_buffers": "256MB",
        "work_mem": "16MB",
        "effective_cache_size": "1GB"
      },
      "pooler": {
        "enabled": true,
        "default_pool_size": 30,
        "max_client_conn": 200
      },
      "backup": {
        "enabled": true,
        "schedule": "0 0 0 * * *",
        "s3Endpoint": "https://s3.amazonaws.com",
        "bucketName": "my-db-backups",
        "path": "prod/postgres",
        "retentionPolicy": "7"
      },
      "access_credentials": {
        "accessKeyId": "AKIAIOSFODNN7EXAMPLE",
        "secretAccessKey": "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY"
      },
      "supabase": true
    }
  }
}

Response

OK

Changes

Changed in 2 of the 41 revisions of this API.91

    • ▲

      the response property // became nullable for the status

      response-property-became-nullable

    • ▲

      the response property // became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ▲

      the response property /// became nullable for the status

      response-property-became-nullable

    • ○

      endpoint added

      endpoint-added