Shrink Attachments

User Guide > Resources > Shrink Attachments

This request shrinks attachments from the database.
When attachments are removed, the database needs to be cleaned, this call cleans up the disk space. This call may take several minutes.

NOTE: this call only works on Postres database systems

Resource

POST /attachments/shrink

Parameters

None

Payload

None

Response

Object Response < XCCAttachmentLog >

Context

Authorization

Administrator

Errors

Common Errors

HTTP code	Xelion code	Description
500	11000	A server error occurred. See error message for more information. when the error 'only supported in postgres databases' is trown you are on a non Postgres database and this funtion is not supported.

HTTP code

Xelion code

Description

500

11000

A server error occurred. See error message for more information.
when the error 'only supported in postgres databases' is trown you are on a non Postgres database and this funtion is not supported.

Example

Request

POST https://xelion.nl/api/v1/master/attachments/shrink

Response

{
    "object": {
        "timeStamp": "2019-03-05 15:10:02",
        "timeStampEnd": "2019-03-05 15:10:02",
        "file": "",
        "status": "SUCCESS",
        "action": "shrink",
        "log": {
            "content": "INFO:  vacuuming "pg_catalog.pg_largeobject"\nINFO:  "pg_largeobject": found 0 removable, 112763 nonremovable row versions in 33950 pages\nDETAIL:  0 dead row versions cannot be removed yet.\nCPU: user: 3.24 s, system: 0.59 s, elapsed: 9.33 s.\nVACUUM",
            "oid": "1813134",
            "objectType": "Comment"
        },
        "permissions": "ReadWriteRemove",
        "commonName": "2019-03-05 16:10:02",
        "oid": "1813127",
        "objectType": "XCCAttachmentLog"
    },
    "links": [
        {
            "rel": "self",
            "href": "http://xelion.nl/api/v1/master/attachments/shrink",
            "method": "GET"
        }
    ]
}