Managed Service for PostgreSQL API, REST: Database.Update
Updates the specified PostgreSQL database.
HTTP request
PATCH https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters/{clusterId}/databases/{databaseName}
Path parameters
Field |
Description |
clusterId |
string Required field. ID of the PostgreSQL cluster to update a database in. |
databaseName |
string Required field. Name of the database to update. |
Body parameters
{
"newDatabaseName": "string",
"updateMask": "string",
"extensions": [
{
"name": "string",
"version": "string"
}
],
"deletionProtection": "boolean"
}
Field |
Description |
newDatabaseName |
string Optional. New name of the database. |
updateMask |
string (field-mask) A comma-separated names off ALL fields to be updated. If |
extensions[] |
PostgreSQL extensions that should be enabled for the database. If the field is sent, the list of enabled extensions is rewritten entirely. |
deletionProtection |
boolean Deletion Protection inhibits deletion of the database Default value: |
Extension
Field |
Description |
name |
string Name of the extension, e.g. |
version |
string Version of the extension. |
Response
HTTP Code: 200 - OK
{
"id": "string",
"description": "string",
"createdAt": "string",
"createdBy": "string",
"modifiedAt": "string",
"done": "boolean",
"metadata": {
"clusterId": "string",
"databaseName": "string"
},
// Includes only one of the fields `error`, `response`
"error": {
"code": "integer",
"message": "string",
"details": [
"object"
]
},
"response": {
"name": "string",
"clusterId": "string",
"owner": "string",
"lcCollate": "string",
"lcCtype": "string",
"extensions": [
{
"name": "string",
"version": "string"
}
],
"templateDb": "string",
"deletionProtection": "boolean"
}
// end of the list of possible fields
}
An Operation resource. For more information, see Operation.
Field |
Description |
id |
string ID of the operation. |
description |
string Description of the operation. 0-256 characters long. |
createdAt |
string (date-time) Creation timestamp. String in RFC3339 To work with values in this field, use the APIs described in the |
createdBy |
string ID of the user or service account who initiated the operation. |
modifiedAt |
string (date-time) The time when the Operation resource was last modified. String in RFC3339 To work with values in this field, use the APIs described in the |
done |
boolean If the value is |
metadata |
Service-specific metadata associated with the operation. |
error |
The error result of the operation in case of failure or cancellation. Includes only one of the fields The operation result. |
response |
The normal response of the operation in case of success. Includes only one of the fields The operation result. |
UpdateDatabaseMetadata
Field |
Description |
clusterId |
string ID of the PostgreSQL cluster where a database is being updated. |
databaseName |
string Name of the PostgreSQL database that is being updated. |
Status
The error result of the operation in case of failure or cancellation.
Field |
Description |
code |
integer (int32) Error code. An enum value of google.rpc.Code |
message |
string An error message. |
details[] |
object A list of messages that carry the error details. |
Database
A PostgreSQL Database resource. For more information, see
the Developer's Guide.
Field |
Description |
name |
string Name of the database. |
clusterId |
string ID of the PostgreSQL cluster that the database belongs to. |
owner |
string Name of the user assigned as the owner of the database. |
lcCollate |
string POSIX locale for string sorting order. |
lcCtype |
string POSIX locale for character classification. |
extensions[] |
PostgreSQL extensions enabled for the database. |
templateDb |
string Name of the database template. |
deletionProtection |
boolean Deletion Protection inhibits deletion of the database Default value: |
Extension
Field |
Description |
name |
string Name of the extension, e.g. |
version |
string Version of the extension. |