# Update Postgres parameters on a database Source: https://docs.orchard.hackclub.com/api/operations/databases_settings_update/ `PATCH /apiv1/databases/{id}/settings` Operation ID: `databases_settings_update` Auth: authenticated (scope: deploy) ## Parameters | Name | In | Required | Description | | --- | --- | --- | --- | | `id` | path | Yes | | ## Request body ```json { "properties": { "backupCompression": { "description": "null restores automatic selection based on the memory limit.", "enum": [ "gzip", "none", null ], "type": [ "string", "null" ] }, "parameters": { "additionalProperties": { "type": "string" }, "description": "Values are applied as given and never clamped. Omit a key (or send it empty) to hand it back to automatic sizing.", "type": "object" } }, "required": [ "parameters" ], "type": "object" } ``` ## Responses ### 200: OK ```json { "additionalProperties": {}, "properties": { "advisories": { "description": "Warnings about the values that were just applied. Never a rejection.", "items": { "properties": { "key": { "type": "string" }, "message": { "type": "string" } }, "required": [ "key", "message" ], "type": "object" }, "type": "array" }, "backupCompression": { "type": [ "string", "null" ] }, "parameters": { "additionalProperties": { "type": "string" }, "type": "object" }, "success": { "type": "boolean" } }, "required": [ "success", "parameters" ], "type": "object" } ```