openapi: 3.1.0 info: title: Managed Database for PostgreSQL and MySQL Access Control List Snapshots API description: "Managed Database for PostgreSQL and MySQL provides fully-managed relational Database Instances, with MySQL or PostgreSQL as database engines. The resource allows you to focus on development rather than administration or configuration. It comes with a high-availability mode, data replication, and automatic backups.\n\nCompared to traditional database management, which requires customers to provide their infrastructure and resources to manage their databases, Managed Database for PostgreSQL and MySQL Instance offers the user access to Database Instances without setting up the hardware or configuring the software. Scaleway handles the provisioning, manages the configuration, and provides useful features as high availability, automated backup, user management, and more.\n\n\n\n\n## Concepts\n\nRefer to our [dedicated concepts page](https://www.scaleway.com/en/docs/managed-databases-for-postgresql-and-mysql/concepts/) to find definitions of the different terms referring to Managed Database for PostgreSQL and MySQL.\n\n\n\n\n## Quickstart\n\n1. Configure your environment variables.\n \n This is an optional step that seeks to simplify your usage of the APIs.\n \n\n ```bash\n export SCW_ACCESS_KEY=\"\"\n export SCW_SECRET_KEY=\"\"\n export SCW_REGION=\"\"\n ```\n2. Edit the POST request payload you will use to create your Database Instance. Replace the parameters in the following example:\n ```json\n '{\n \"project_id\": \"d8e65f2b-cce9-40b7-80fc-6a2902db6826\",\n \"name\": \"myDB\",\n \"engine\": \"PostgreSQL-15\",\n \"tags\": [\"donnerstag\"],\n \"is_ha_cluster\": true,\n \"node_type\": \"db-pro2-xxs\",\n \"disable_backup\": false,\n \"user_name\": \"my_initial_user\",\n \"password\": \"thiZ_is_v0ry_s3cret\",\n \"volume_type\": \"sbs_5k\",\n \"volume_size\": \"30000000000\"\n }'\n ```\n\n | Parameter | Description |\n | :--------------- |:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n | `project_id` | The ID of the Project you want to create your Database Instance in. To find your Project ID you can **[list the projects](/api/account/project-api/#path-projects-list-all-projects-of-an-organization)** or consult the **[Scaleway console](https://console.scaleway.com/project/settings)**. |\n | `engine` | **REQUIRED** Version ID of the database engine. To check the list of available engines you can use the following endpoint: `https://api.scaleway.com/rdb/v1/regions/$SCW_REGION/database-engines` |\n | `name` | Name of the Database Instance |\n | `node_type` | **REQUIRED** The node type. To check the list of available node types you can use the following endpoint: `https://api.scaleway.com/rdb/v1/regions/$SCW_REGION/node-types` |\n | `is_ha_cluster` | **BOOLEAN** Defines whether High Availability is enabled for the Database Instance |\n | `disable_backup` | **BOOLEAN** Defines whether automated backups are disabled for the Database Instance |\n | `tags` | The list of tags `[\"tag1\", \"tag2\", ...]` that will be associated with the Database Instance. Tags can be appended to the query of the [List Database Instances](#path-database-instances-list-database-instances) call to show results for only the Database Instances using a specific tag. You can also combine tags to list Database Instances that possess all the appended tags. |\n | `user_name` | **REQUIRED** Identifier of the default user, which is created concurrently with the Database Instance |\n | `password` | **REQUIRED** Password for the default user |\n | `volume_type` | Type of volume where data is stored. You can specify either local volume (`lssd`) or block volume (`bssd`, `sbs_5k` or `sbs_15k`). The default value is `lssd` |\n | `volume_size` | Volume size when volume_type is `bssd`, `sbs_5k` or `sbs_15k`. The value should be expressed in bytes. For example 30GB is expressed as 30000000000 |\n3. Create a Database Instance by running the following command. Make sure you include the payload you edited in the previous step.\n ```bash\n curl -X POST \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"Content-Type: application/json\" \\\n https://api.scaleway.com/rdb/v1/regions/$SCW_REGION/instances \\\n -d '{\n \"project_id\": \"d8e65f2b-cce9-40b7-80fc-6a2902db6826\",\n \"name\": \"myDB\",\n \"engine\": \"PostgreSQL-15\",\n \"tags\": [\"donnerstag\"],\n \"is_ha_cluster\": true,\n \"node_type\": \"db-pro2-xxs\",\n \"disable_backup\": false,\n \"user_name\": \"my_initial_user\",\n \"password\": \"thiZ_is_v0ry_s3cret\",\n \"volume_type\": \"sbs_5k\",\n \"volume_size\": \"30000000000\"\n }'\n ```\n4. List your Database Instances.\n ```bash\n curl -X GET \\\n -H \"Content-Type: application/json\" \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" https://api.scaleway.com/rdb/v1/regions/$SCW_REGION/instances\n ```\n\n You should get a response like the following:\n\n \n This is a response example, the UUIDs and IP address displayed are not real.\n \n\n ```json\n {\n \"id\": \"f5122f66-fb50-4cef-aa02-487ef4fc1af0\",\n \"name\": \"myDB\",\n \"organization_id\": \"895693aa-3915-4896-8761-c2923b008be7\",\n \"project_id\": \"d8e65f2b-cce9-40b7-80fc-6a2902db6826\",\n \"status\": \"ready\",\n \"engine\": \"PostgreSQL-15\",\n \"endpoint\": {\n \"ip\": \"198.51.100.0\",\n \"port\": 22245,\n \"name\": null\n },\n \"tags\": [\n \"donnerstag\"\n ],\n \"settings\": [],\n \"backup_schedule\": {\n \"frequency\": 24,\n \"retention\": 7,\n \"disabled\": true\n },\n \"is_ha_cluster\": true,\n \"read_replicas\": [],\n \"node_type\": \"db-pro2-xxs\",\n \"volume\": {\n \"type\": \"sbs_5k\",\n \"size\": 30000000000\n }\n \"created_at\": \"2019-04-19T16:24:52.591417Z\",\n \"region\": \"fr-par\"\n }\n ```\n5. Retrieve your Database Instance IP and port from the response.\n \n In the example above, the IP and port are `198.51.100.0` and `22245`, respectively.\n \n6. Connect to your Database Instance with the database client of the engine you selected.\n For MySQL, run the following command:\n ```bash\n mysql -h --port -p -u \n ```\n\n For PostgreSQL, run:\n ```bash\n psql -h -p -U -d rdb\n ```\n\n For the recurring example, the command would look like:\n\n ```bash\n psql -h 198.51.100.0 -p 22245 -U my_initial_user -d rdb\n ```\n7. Enter the database password that you defined upon creation.\n\nYou are now connected to your Managed Database.\n\n\n\nTo perform the following steps, you must first ensure that:\n - you have an account and are logged into the [Scaleway console](https://console.scaleway.com/organization)\n - you have created an [API key](https://www.scaleway.com/en/docs/iam/how-to/create-api-keys/) and that the API key has sufficient [IAM permissions](https://www.scaleway.com/en/docs/iam/reference-content/permission-sets/) to perform the actions described on this page.\n - you have [installed `curl`](https://curl.se/download.html)\n\n\n\n## Technical Information\n\n### Regions\n\nScaleway's infrastructure is spread across different [regions and Availability Zones](https://www.scaleway.com/en/docs/account/reference-content/products-availability/).\n\nManaged Database for PostgreSQL and MySQL is available in the Paris, Amsterdam and Warsaw regions, which are represented by the following path parameters:\n\n- `fr-par`\n- `nl-ams`\n- `pl-waw`\n\n### PostgreSQL specifications\n\n#### Versions\n\nScaleway Database for PostgreSQL supports PostgreSQL versions 11, 12, 13, 14 and 15.\n\n#### System\n\nDifferent modules are available for installation, including TimescaleDB and PostGIS. Refer to the [Managed Database for PostgreSQL and MySQL FAQ page](https://www.scaleway.com/en/docs/managed-databases-for-postgresql-and-mysql/faq/#which-postgresql-extensions-are-available) for an extensive list of PostgreSQL extensions.\n\n#### Database Management\n\nYou can create logical databases through the Scaleway console, the Scaleway APIs or SQL.\n\n- databases created using the Scaleway console or the API are owned by an internal system user. These are called \"managed databases\".\n- databases created using SQL will be owned by the creator. These are called \"unmanaged databases\".\n\n### MySQL specifications\n\n#### Versions\n\nScaleway Database for MySQL supports MySQL 8.\n\n#### System\n\n- only the [InnoDB engine](https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html) is supported\n- the [Global Transaction Identifier (GTID)](https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html) is enabled.\n- [`mysql_native_password`](https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html) (default) and [`caching_sha2_password`](https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html) authentication are supported.\n\n#### User Management\n\n- users with an `admin` role have access to all logical databases and can create new ones.\n- users created via the API are authenticated using the default authentication plugin, which can be changed in the settings.\n\n## Technical Limitations\n\n### PostgreSQL\n\n#### User Management\n\n- users with an `admin` role have `CREATEROLE` and `CREATEDB` privileges.\n- users do NOT have `SUPERUSER` nor `REPLICATION` privileges.\n- permission management through the Scaleway console or API is only possible for the \"managed databases\".\n\n#### Backup and restoration\n\nDatabases that have been backed up and then restored retain the user permission settings in use at the time of backup. If you delete users after backup and then restore your backup in the same database, or if you restore a backup to a different database with different or no users, the permissions configured for them continue to exist, but with no associated owner. This error will put a stop to the restoration process.\n\nTo avoid this issue, we recommend you re-create the users you deleted. In the occasion you restore the backup to a new database, you must create new users with the same names.\n\n## Going Further\n\nFor more information about Managed Database for PostgreSQL and MySQL, you can check out the following pages:\n\n* [Managed Database for PostgreSQL and MySQL Documentation](https://www.scaleway.com/en/docs/managed-databases/postgresql-and-mysql/)\n* [Managed Database for PostgreSQL and MySQL FAQ](https://www.scaleway.com/en/docs/managed-databases-for-postgresql-and-mysql/faq/)\n* [Scaleway Slack Community](https://scaleway-community.slack.com/) join the #database channel\n* [Contact our support team](https://console.scaleway.com/support/tickets)\n\n### How to migrate a database\n\nIf you wish to migrate existing databases to a Managed Database for PostgreSQL or MySQL, you can refer to the [Migrating existing databases to a Database Instance](https://www.scaleway.com/en/docs/tutorials/migrate-databases-instance/) tutorial page.\n\n### Troubleshoooting\n\n#### Disk full status\n\nIf your Database Instance uses local storage, your local volume might eventually approach full capacity and shift to `disk_full` mode. This mode grants you enough space to either [upgrade your node type](https://www.scaleway.com/en/docs/managed-databases-for-postgresql-and-mysql/how-to/upgrade-version/#how-to-change-the-node-type) or [clear out space in your volume](https://www.scaleway.com/en/docs/managed-databases-for-postgresql-and-mysql/troubleshooting/disk-full/)." version: v1 servers: - url: https://api.scaleway.com tags: - name: Snapshots description: 'A snapshot is a consistent, instantaneous copy of the Block Storage volume of your Database Instance at a certain point in time. They are designed to recover your data in case of failure or accidental alterations of the data by a user. They allow you to quickly create a new Instance from a previous state of your database, regardless of the size of the volume. Their limitation is that, unlike backups, snapshots can only be stored in the same location as the original data. ' paths: /rdb/v1/regions/{region}/instances/{instance_id}/snapshots: post: tags: - Snapshots operationId: CreateSnapshot summary: Create a Database Instance snapshot description: Create a new snapshot of a Database Instance. You must define the `name` parameter in the request. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: path name: instance_id description: UUID of the Database Instance. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.Snapshot' requestBody: required: true content: application/json: schema: type: object properties: name: type: string description: Name of the snapshot. expires_at: type: string description: Expiration date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true required: - name x-properties-order: - name - expires_at security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X POST \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\":\"string\"}' \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/instances/{instance_id}/snapshots\"" - lang: HTTPie source: "http POST \"https://api.scaleway.com/rdb/v1/regions/{region}/instances/{instance_id}/snapshots\" \\\n X-Auth-Token:$SCW_SECRET_KEY \\\n name=\"string\"" /rdb/v1/regions/{region}/snapshots: get: tags: - Snapshots operationId: ListSnapshots summary: List snapshots description: List snapshots. You can include the `instance_id` or `project_id` in your query to get the list of snapshots for specific Database Instances and/or Projects. By default, the details returned in the list are ordered by creation date in ascending order, though this can be modified via the `order_by` field. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: query name: name description: Name of the snapshot. schema: type: string - in: query name: order_by description: Criteria to use when ordering snapshot listing. schema: type: string enum: - created_at_asc - created_at_desc - name_asc - name_desc - expires_at_asc - expires_at_desc default: created_at_asc - in: query name: instance_id description: UUID of the Database Instance. schema: type: string - in: query name: organization_id description: Organization ID the snapshots belongs to. schema: type: string - in: query name: project_id description: Project ID the snapshots belongs to. schema: type: string - in: query name: page schema: $ref: '#/components/schemas/google.protobuf.Int32Value' - in: query name: page_size schema: type: integer format: uint32 responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.ListSnapshotsResponse' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X GET \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots\"" - lang: HTTPie source: "http GET \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots\" \\\n X-Auth-Token:$SCW_SECRET_KEY" /rdb/v1/regions/{region}/snapshots/{snapshot_id}: get: tags: - Snapshots operationId: GetSnapshot summary: Get a Database Instance snapshot description: Retrieve information about a given snapshot, specified by its `snapshot_id` and `region`. Full details about the snapshot, like size and expiration date, are returned in the response. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: path name: snapshot_id description: UUID of the snapshot. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.Snapshot' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X GET \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http GET \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" patch: tags: - Snapshots operationId: UpdateSnapshot summary: Update a Database Instance snapshot description: Update the parameters of a snapshot of a Database Instance. You can update the `name` and `expires_at` parameters. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: path name: snapshot_id description: UUID of the snapshot to update. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.Snapshot' requestBody: required: true content: application/json: schema: type: object properties: name: type: string description: Name of the snapshot. nullable: true expires_at: type: string description: Expiration date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true x-properties-order: - name - expires_at security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X PATCH \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{}' \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http PATCH \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" delete: tags: - Snapshots operationId: DeleteSnapshot summary: Delete a Database Instance snapshot description: Delete a given snapshot of a Database Instance. You must specify, in the endpoint, the `region` and `snapshot_id` parameters of the snapshot you want to delete. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: path name: snapshot_id description: UUID of the snapshot to delete. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.Snapshot' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X DELETE \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http DELETE \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" /rdb/v1/regions/{region}/snapshots/{snapshot_id}/create-instance: post: tags: - Snapshots operationId: CreateInstanceFromSnapshot summary: Create a new Database Instance from a snapshot description: Restore a snapshot. When you restore a snapshot, a new Instance is created and billed to your account. Note that is possible to select a larger node type for your new Database Instance. However, the Block volume size will be the same as the size of the restored snapshot. All Instance settings will be restored if you chose a node type with the same or more memory size than the initial Instance. Settings will be reset to the default if your node type has less memory. parameters: - in: path name: region description: The region you want to target required: true schema: type: string enum: - fr-par - nl-ams - pl-waw - in: path name: snapshot_id description: Block snapshot of the Database Instance. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.rdb.v1.Instance' requestBody: required: true content: application/json: schema: type: object properties: instance_name: type: string description: Name of the Database Instance created with the snapshot. is_ha_cluster: type: boolean description: Defines whether or not High-Availability is enabled on the new Database Instance. nullable: true node_type: type: string description: The node type used to restore the snapshot. nullable: true x-properties-order: - instance_name - is_ha_cluster - node_type security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X POST \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"instance_name\":\"string\"}' \\\n \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}/create-instance\"" - lang: HTTPie source: "http POST \"https://api.scaleway.com/rdb/v1/regions/{region}/snapshots/{snapshot_id}/create-instance\" \\\n X-Auth-Token:$SCW_SECRET_KEY \\\n instance_name=\"string\"" /instance/v1/zones/{zone}/snapshots: get: tags: - Snapshots operationId: ListSnapshots summary: List snapshots description: List all snapshots of an Organization in a specified Availability Zone. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: query name: organization description: List snapshots only for this Organization ID. schema: type: string - in: query name: project description: List snapshots only for this Project ID. schema: type: string - in: query name: per_page description: Number of snapshots returned per page (positive integer lower or equal to 100). schema: type: integer format: uint32 - in: query name: page description: Page to be returned. schema: type: integer format: int32 - in: query name: name description: List snapshots of the requested name. schema: type: string - in: query name: tags description: List snapshots that have the requested tag. schema: type: string - in: query name: base_volume_id description: List snapshots originating only from this volume. schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.ListSnapshotsResponse' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X GET \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots\"" - lang: HTTPie source: "http GET \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots\" \\\n X-Auth-Token:$SCW_SECRET_KEY" post: tags: - Snapshots operationId: CreateSnapshot summary: Create a snapshot from a specified volume or from a QCOW2 file description: Create a snapshot from a specified volume or from a QCOW2 file in a specified Availability Zone. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 responses: '201': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.CreateSnapshotResponse' requestBody: required: true content: application/json: schema: type: object properties: name: type: string description: Name of the snapshot. volume_id: type: string description: UUID of the volume. nullable: true tags: type: array description: Tags of the snapshot. nullable: true items: type: string organization: type: string description: Organization ID of the snapshot. deprecated: true nullable: true x-one-of: ProjectIdentifier project: type: string description: Project ID of the snapshot. nullable: true x-one-of: ProjectIdentifier volume_type: type: string description: 'Volume type of the snapshot. Overrides the volume_type of the snapshot. If omitted, the volume type of the original volume will be used.' enum: - unknown_volume_type - l_ssd - b_ssd - unified x-enum-descriptions: values: b_ssd: Deprecated unified: Deprecated default: unknown_volume_type bucket: type: string description: Bucket name for snapshot imports. nullable: true key: type: string description: Object key for snapshot imports. nullable: true size: type: integer description: Imported snapshot size, must be a multiple of 512. (in bytes) format: uint64 nullable: true x-properties-order: - name - volume_id - tags - organization - project - volume_type - bucket - key - size security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X POST \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"name\":\"string\"}' \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots\"" - lang: HTTPie source: "http POST \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots\" \\\n X-Auth-Token:$SCW_SECRET_KEY \\\n name=\"string\"" /instance/v1/zones/{zone}/snapshots/{snapshot_id}: get: tags: - Snapshots operationId: GetSnapshot summary: Get a snapshot description: Get details of a snapshot with the specified ID. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: path name: snapshot_id description: UUID of the snapshot you want to get. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.GetSnapshotResponse' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X GET \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http GET \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" put: tags: - Snapshots operationId: SetSnapshot summary: Set snapshot description: Replace all the properties of a snapshot. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: path name: snapshot_id required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.SetSnapshotResponse' requestBody: required: true content: application/json: schema: type: object properties: id: type: string name: type: string organization: type: string volume_type: $ref: '#/components/schemas/scaleway.instance.v1.Volume.VolumeType' size: type: integer description: (in bytes) format: uint64 state: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot.State' base_volume: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot.BaseVolume' creation_date: type: string description: (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true modification_date: type: string description: (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true project: type: string tags: $ref: '#/components/schemas/scaleway.std.StringsValue' x-properties-order: - id - name - organization - volume_type - size - state - base_volume - creation_date - modification_date - project - tags security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X PUT \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"id\": \"string\",\n \"name\": \"string\",\n \"organization\": \"string\",\n \"project\": \"string\",\n \"size\": 42\n }' \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http PUT \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY \\\n id=\"string\" \\\n name=\"string\" \\\n organization=\"string\" \\\n project=\"string\" \\\n size:=42" patch: tags: - Snapshots operationId: UpdateSnapshot summary: Update a snapshot description: Update the properties of a snapshot. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: path name: snapshot_id description: UUID of the snapshot. (UUID format) required: true schema: type: string example: 6170692e-7363-616c-6577-61792e636f6d responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.UpdateSnapshotResponse' requestBody: required: true content: application/json: schema: type: object properties: name: type: string description: Name of the snapshot. nullable: true tags: type: array description: Tags of the snapshot. nullable: true items: type: string x-properties-order: - name - tags security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X PATCH \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{}' \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http PATCH \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" delete: tags: - Snapshots operationId: DeleteSnapshot summary: Delete a snapshot description: Delete the snapshot with the specified ID. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: path name: snapshot_id description: UUID of the snapshot you want to delete. required: true schema: type: string responses: '204': description: '' security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X DELETE \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\"" - lang: HTTPie source: "http DELETE \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}\" \\\n X-Auth-Token:$SCW_SECRET_KEY" /instance/v1/zones/{zone}/snapshots/{snapshot_id}/export: post: tags: - Snapshots operationId: ExportSnapshot summary: Export a snapshot description: Export a snapshot to a specified Object Storage bucket in the same region. parameters: - in: path name: zone description: The zone you want to target required: true schema: type: string enum: - fr-par-1 - fr-par-2 - fr-par-3 - nl-ams-1 - nl-ams-2 - nl-ams-3 - pl-waw-1 - pl-waw-2 - pl-waw-3 - it-mil-1 - in: path name: snapshot_id description: Snapshot ID. required: true schema: type: string responses: '200': description: '' content: application/json: schema: $ref: '#/components/schemas/scaleway.instance.v1.ExportSnapshotResponse' requestBody: required: true content: application/json: schema: type: object properties: bucket: type: string description: Object Storage bucket name. key: type: string description: Object key. x-properties-order: - bucket - key security: - scaleway: [] x-codeSamples: - lang: cURL source: "curl -X POST \\\n -H \"X-Auth-Token: $SCW_SECRET_KEY\" \\\n -H \"Content-Type: application/json\" \\\n -d '{\"bucket\":\"string\",\"key\":\"string\"}' \\\n \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}/export\"" - lang: HTTPie source: "http POST \"https://api.scaleway.com/instance/v1/zones/{zone}/snapshots/{snapshot_id}/export\" \\\n X-Auth-Token:$SCW_SECRET_KEY \\\n bucket=\"string\" \\\n key=\"string\"" components: schemas: scaleway.rdb.v1.Snapshot: type: object properties: id: type: string description: UUID of the snapshot. instance_id: type: string description: UUID of the Database Instance. name: type: string description: Name of the snapshot. status: type: string description: Status of the snapshot. enum: - unknown - creating - ready - restoring - deleting - error - locked default: unknown size: type: integer description: Size of the snapshot. (in bytes) format: uint64 nullable: true expires_at: type: string description: Expiration date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true created_at: type: string description: Creation date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true updated_at: type: string description: Updated date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true instance_name: type: string description: Name of the Database Instance of the snapshot. node_type: type: string description: Source node type. volume_type: type: object description: Type of volume where data is stored (lssd, bssd or sbs). properties: type: $ref: '#/components/schemas/scaleway.rdb.v1.Volume.Type' class: $ref: '#/components/schemas/scaleway.rdb.v1.StorageClass' x-properties-order: - type - class region: type: string description: Region of this snapshot. x-properties-order: - id - instance_id - name - status - size - expires_at - created_at - updated_at - instance_name - node_type - volume_type - region scaleway.instance.v1.CreateSnapshotResponse: type: object properties: snapshot: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot' task: $ref: '#/components/schemas/scaleway.instance.v1.Task' x-properties-order: - snapshot - task google.protobuf.Int32Value: type: integer format: int32 nullable: true scaleway.instance.v1.Snapshot.BaseVolume: type: object properties: id: type: string description: Volume ID on which the snapshot is based. name: type: string description: Volume name on which the snapshot is based on. x-properties-order: - id - name scaleway.rdb.v1.InstanceSetting: type: object properties: name: type: string value: type: string x-properties-order: - name - value scaleway.instance.v1.Volume.VolumeType: type: string enum: - l_ssd - b_ssd - unified - scratch - sbs_volume - sbs_snapshot x-enum-descriptions: values: b_ssd: Deprecated unified: Deprecated default: l_ssd scaleway.instance.v1.SetSnapshotResponse: type: object properties: snapshot: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot' x-properties-order: - snapshot scaleway.instance.v1.Task: type: object properties: id: type: string description: Unique ID of the task. description: type: string description: Description of the task. progress: type: integer description: Progress of the task in percent. format: int32 started_at: type: string description: Task start date. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true terminated_at: type: string description: Task end date. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true status: type: string description: Task status. enum: - pending - started - success - failure - retry default: pending href_from: type: string href_result: type: string zone: type: string description: Zone in which the task is executed. x-properties-order: - id - description - progress - started_at - terminated_at - status - href_from - href_result - zone scaleway.rdb.v1.StorageClass: type: string enum: - unknown_storage_class - lssd - bssd - sbs default: unknown_storage_class scaleway.instance.v1.ExportSnapshotResponse: type: object properties: task: $ref: '#/components/schemas/scaleway.instance.v1.Task' x-properties-order: - task scaleway.rdb.v1.Instance: type: object properties: created_at: type: string description: Creation date (must follow the ISO 8601 format). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true volume: type: object description: Volumes of the Database Instance. properties: type: $ref: '#/components/schemas/scaleway.rdb.v1.Volume.Type' size: type: integer description: (in bytes) format: uint64 class: $ref: '#/components/schemas/scaleway.rdb.v1.StorageClass' x-properties-order: - type - size - class region: type: string description: Region the Database Instance is in. id: type: string description: UUID of the Database Instance. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d name: type: string description: Name of the Database Instance. organization_id: type: string description: Organization ID the Database Instance belongs to. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d project_id: type: string description: Project ID the Database Instance belongs to. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d status: type: string description: Status of the Database Instance. enum: - unknown - ready - provisioning - configuring - deleting - error - autohealing - locked - initializing - disk_full - backuping - snapshotting - restarting default: unknown engine: type: string description: Database engine of the database (PostgreSQL, MySQL, ...). upgradable_version: type: array description: Available database engine versions for upgrade. items: $ref: '#/components/schemas/scaleway.rdb.v1.UpgradableVersion' endpoint: type: object description: Endpoint of the Database Instance. deprecated: true properties: id: type: string description: UUID of the endpoint. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d ip: type: string description: IPv4 address of the endpoint. (IP address) example: 1.2.3.4 nullable: true x-one-of: address port: type: integer description: TCP port of the endpoint. format: uint32 name: type: string description: Name of the endpoint. nullable: true private_network: type: object description: Private Network details. One maximum per Database Instance or Read Replica (a Database Instance and its Read Replica can have different Private Networks). Cannot be updated (has to be deleted and recreated). properties: private_network_id: type: string description: UUID of the private network. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d service_ip: type: string description: CIDR notation of the endpoint IPv4 address. (IP network) example: 1.2.3.4/32 zone: type: string description: Private network zone. provisioning_mode: type: string description: How endpoint ips are provisioned. enum: - static - ipam default: static nullable: true x-properties-order: - private_network_id - service_ip - zone - provisioning_mode x-one-of: details load_balancer: type: object description: Load balancer details. Public endpoint for Database Instance which is systematically present. One per Database Instance. nullable: true x-one-of: details direct_access: type: object description: Direct access details. Public endpoint reserved for Read Replicas. One per Read Replica. nullable: true x-one-of: details hostname: type: string description: Hostname of the endpoint. nullable: true x-one-of: address x-properties-order: - id - ip - port - name - private_network - load_balancer - direct_access - hostname tags: type: array description: List of tags applied to the Database Instance. items: type: string settings: type: array description: Advanced settings of the Database Instance. items: $ref: '#/components/schemas/scaleway.rdb.v1.InstanceSetting' backup_schedule: type: object description: Backup schedule of the Database Instance. properties: frequency: type: integer description: Frequency of the backup schedule (in hours). format: uint32 retention: type: integer description: Default retention period of backups (in days). format: uint32 disabled: type: boolean description: Defines whether the backup schedule feature is disabled. next_run_at: type: string description: Next run of the backup schedule (accurate to 10 minutes). (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true x-properties-order: - frequency - retention - disabled - next_run_at is_ha_cluster: type: boolean description: Defines whether or not High-Availability is enabled. read_replicas: type: array description: Read Replicas of the Database Instance. items: $ref: '#/components/schemas/scaleway.rdb.v1.ReadReplica' node_type: type: string description: Node type of the Database Instance. init_settings: type: array description: List of engine settings to be set at database initialization. items: $ref: '#/components/schemas/scaleway.rdb.v1.InstanceSetting' endpoints: type: array description: List of Database Instance endpoints. items: $ref: '#/components/schemas/scaleway.rdb.v1.Endpoint' logs_policy: type: object description: Logs policy of the Database Instance. properties: max_age_retention: type: integer description: Max age (in days) of remote logs to keep on the Database Instance. format: uint32 nullable: true total_disk_retention: type: integer description: Max disk size of remote logs to keep on the Database Instance. (in bytes) format: uint64 nullable: true x-properties-order: - max_age_retention - total_disk_retention backup_same_region: type: boolean description: Store logical backups in the same region as the Database Instance. maintenances: type: array description: List of Database Instance maintenance events. items: $ref: '#/components/schemas/scaleway.rdb.v1.Maintenance' encryption: type: object description: Encryption at rest settings for your Database Instance. properties: enabled: type: boolean x-properties-order: - enabled x-properties-order: - created_at - volume - region - id - name - organization_id - project_id - status - engine - upgradable_version - endpoint - tags - settings - backup_schedule - is_ha_cluster - read_replicas - node_type - init_settings - endpoints - logs_policy - backup_same_region - maintenances - encryption scaleway.std.StringsValue: type: array nullable: true items: type: string scaleway.rdb.v1.ListSnapshotsResponse: type: object properties: snapshots: type: array description: List of snapshots. items: $ref: '#/components/schemas/scaleway.rdb.v1.Snapshot' total_count: type: integer description: Total count of snapshots available. format: uint32 x-properties-order: - snapshots - total_count scaleway.rdb.v1.Maintenance: type: object properties: starts_at: type: string description: Start date of the maintenance window. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true stops_at: type: string description: End date of the maintenance window. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true closed_at: type: string description: Closed maintenance date. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true reason: type: string description: Maintenance information message. status: type: string description: Status of the maintenance. enum: - unknown - pending - done - canceled - ongoing default: unknown forced_at: type: string description: Time when Scaleway-side maintenance will be applied. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true is_applicable: type: boolean description: Indicate if the maintenance can be applied by the user. x-properties-order: - starts_at - stops_at - closed_at - reason - status - forced_at - is_applicable scaleway.rdb.v1.UpgradableVersion: type: object properties: id: type: string description: (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d name: type: string version: type: string minor_version: type: string x-properties-order: - id - name - version - minor_version scaleway.instance.v1.UpdateSnapshotResponse: type: object properties: snapshot: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot' x-properties-order: - snapshot scaleway.rdb.v1.Volume.Type: type: string enum: - lssd - bssd - sbs_5k - sbs_15k default: lssd scaleway.instance.v1.Snapshot: type: object properties: id: type: string description: Snapshot ID. name: type: string description: Snapshot name. organization: type: string description: Snapshot Organization ID. project: type: string description: Snapshot Project ID. tags: type: array description: Snapshot tags. items: type: string volume_type: type: string description: Snapshot volume type. enum: - l_ssd - b_ssd - unified - scratch - sbs_volume - sbs_snapshot x-enum-descriptions: values: b_ssd: Deprecated unified: Deprecated default: l_ssd size: type: integer description: Snapshot size. (in bytes) format: uint64 state: type: string description: Snapshot state. enum: - available - snapshotting - error - invalid_data - importing - exporting default: available base_volume: type: object description: Volume on which the snapshot is based on. properties: id: type: string description: Volume ID on which the snapshot is based. name: type: string description: Volume name on which the snapshot is based on. x-properties-order: - id - name creation_date: type: string description: Snapshot creation date. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true modification_date: type: string description: Snapshot modification date. (RFC 3339 format) format: date-time example: '2022-03-22T12:34:56.123456Z' nullable: true zone: type: string description: Snapshot zone. error_reason: type: string description: Reason for the failed snapshot import. nullable: true x-properties-order: - id - name - organization - project - tags - volume_type - size - state - base_volume - creation_date - modification_date - zone - error_reason scaleway.instance.v1.GetSnapshotResponse: type: object properties: snapshot: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot' x-properties-order: - snapshot scaleway.instance.v1.ListSnapshotsResponse: type: object properties: snapshots: type: array description: List of snapshots. items: $ref: '#/components/schemas/scaleway.instance.v1.Snapshot' x-properties-order: - snapshots scaleway.rdb.v1.Endpoint: type: object properties: id: type: string description: UUID of the endpoint. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d ip: type: string description: IPv4 address of the endpoint. (IP address) example: 1.2.3.4 nullable: true x-one-of: address port: type: integer description: TCP port of the endpoint. format: uint32 name: type: string description: Name of the endpoint. nullable: true private_network: type: object description: Private Network details. One maximum per Database Instance or Read Replica (a Database Instance and its Read Replica can have different Private Networks). Cannot be updated (has to be deleted and recreated). properties: private_network_id: type: string description: UUID of the private network. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d service_ip: type: string description: CIDR notation of the endpoint IPv4 address. (IP network) example: 1.2.3.4/32 zone: type: string description: Private network zone. provisioning_mode: type: string description: How endpoint ips are provisioned. enum: - static - ipam default: static nullable: true x-properties-order: - private_network_id - service_ip - zone - provisioning_mode x-one-of: details load_balancer: type: object description: Load balancer details. Public endpoint for Database Instance which is systematically present. One per Database Instance. nullable: true x-one-of: details direct_access: type: object description: Direct access details. Public endpoint reserved for Read Replicas. One per Read Replica. nullable: true x-one-of: details hostname: type: string description: Hostname of the endpoint. nullable: true x-one-of: address x-properties-order: - id - ip - port - name - private_network - load_balancer - direct_access - hostname scaleway.instance.v1.Snapshot.State: type: string enum: - available - snapshotting - error - invalid_data - importing - exporting default: available scaleway.rdb.v1.ReadReplica: type: object properties: id: type: string description: UUID of the Read Replica. (UUID format) example: 6170692e-7363-616c-6577-61792e636f6d endpoints: type: array description: Display Read Replica connection information. items: $ref: '#/components/schemas/scaleway.rdb.v1.Endpoint' status: type: string description: Read replica status. enum: - unknown - provisioning - initializing - ready - deleting - error - locked - configuring - promoting default: unknown region: type: string description: Region the Read Replica is in. same_zone: type: boolean description: Whether the replica is in the same availability zone as the main instance nodes or not. instance_id: type: string description: UUID of the Database Instance. x-properties-order: - id - endpoints - status - region - same_zone - instance_id securitySchemes: scaleway: in: header name: X-Auth-Token type: apiKey