Create a DBaaS PostgreSQL connection pool

POST /dbaas-postgres/{service-name}/connection-pool

Path parameters

  • service-name string Required

    Service name

    Minimum length is 0, maximum length is 63.

application/json

Body Required

  • name string Required

    Connection pool name

    Minimum length is 1, maximum length is 63.

  • database-name string Required

    Service database name

    Minimum length is 1, maximum length is 40.

  • mode string

    PGBouncer pool mode

    Values are transaction, statement, or session.

  • size integer(int64)

    Size of PGBouncer's PostgreSQL side connection pool

    Minimum value is 1, maximum value is 10000.

  • username string

    Pool username

    Minimum length is 1, maximum length is 64.

Responses

  • 200 application/json

    200

    Hide response attributes Show response attributes object
    • id string(uuid)

      Operation ID

    • reason string

      Operation failure reason

      Values are incorrect, unknown, unavailable, forbidden, busy, fault, partial, not-found, interrupted, unsupported, or conflict.

    • reference object

      Related resource reference

      Additional properties are allowed.

      Hide reference attributes Show reference attributes object
      • id string(uuid)

        Reference ID

      • link string

        Link to the referenced resource

      • command string

        Command name

    • message string

      Operation message

    • state string

      Operation status

      Values are failure, pending, success, or timeout.
POST /dbaas-postgres/{service-name}/connection-pool 
curl \
 -X POST https://api-ch-gva-2.exoscale.com/v2/dbaas-postgres/{service-name}/connection-pool \
 -H "Content-Type: application/json" \
 -d '{"name":"string","database-name":"string","mode":"transaction","size":42,"username":"string"}'
Request examples 
{
  "name": "string",
  "database-name": "string",
  "mode": "transaction",
  "size": 42,
  "username": "string"
}
Response examples (200) 
{
  "id": "string",
  "reason": "incorrect",
  "reference": {
    "id": "string",
    "link": "string",
    "command": "string"
  },
  "message": "string",
  "state": "failure"
}