Get a DBaaS PostgreSQL service

GET /dbaas-postgres/{name}

Get a DBaaS PostgreSQL service

Responses

  • 200 object

    200

    • PGBouncer connection pooling settings

    • updated-at string(date-time)

      Service last update timestamp (ISO 8601)

    • node-count integer(int64)

      Number of service nodes in the active plan

      Minimum value is 0.

    • PG connection information properties

    • Backup schedule

      • backup-hour integer(int64)

        The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.

        Minimum value is 0, maximum value is 23.

      • backup-minute integer(int64)

        The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.

        Minimum value is 0, maximum value is 59.

    • node-cpu-count integer(int64)

      Number of CPUs for each node

      Minimum value is 0.

    • integrations array[object]

      Service integrations

    • zone string

      The zone where the service is running

    • node-states array[object]

      Automatic maintenance settings

      • name string Required

        Name of the service node

      • progress-updates array[object]

        Extra information regarding the progress for current state

        • completed boolean Required

          Indicates whether this phase has been completed or not

        • current integer(int64)

          Current progress for this phase. May be missing or null.

          Minimum value is 0.

        • max integer(int64)

          Maximum progress value for this phase. May be missing or null. May change.

          Minimum value is 0.

        • min integer(int64)

          Minimum progress value for this phase. May be missing or null.

          Minimum value is 0.

        • phase string Required

          Key identifying this phase

          Values are stream, basebackup, prepare, or finalize.

        • unit string

          Unit for current/min/max values. New units may be added.
          If null should be treated as generic unit

      • role string

        Role of this node. Only returned for a subset of service types

        Values are standby, master, or read-replica.

      • state string Required

        Current state of the service node

        Values are leaving, running, syncing_data, setting_up_vm, or unknown.

    • name string Required

      Service name

      Minimum length is 0, maximum length is 63.

    • connection-pools array[object]

      PostgreSQL PGBouncer connection pools

      • connection-uri string Required

        Connection URI for the DB pool

      • database string Required

        Service database name

        Minimum length is 1, maximum length is 40.

      • mode string Required

        PGBouncer pool mode

        Values are transaction, statement, or session.

      • name string Required

        Connection pool name

        Minimum length is 1, maximum length is 63.

      • size integer(int64) Required

        Size of PGBouncer's PostgreSQL side connection pool

        Minimum value is 1, maximum value is 1000.

      • username string Required

        Pool username

        Minimum length is 1, maximum length is 64.

    • type string Required

      DbaaS service name

      Minimum length is 0, maximum length is 64.

    • state string

      State of the service

      Values are running, rebuilding, rebalancing, or poweroff.

    • TimescaleDB extension configuration values

    • databases array[string]

      Service database name

      Minimum length of each is 1, maximum length of each is 40.

    • ip-filter array[string]

      Allowed CIDR address blocks for incoming connections

    • backups array[object]

      List of backups for the service

      • backup-name string Required

        Internal name of this backup

      • backup-time string(date-time) Required

        Backup timestamp (ISO 8601)

      • data-size integer(int64) Required

        Backup's original size before compression

        Minimum value is 0.

    • Service is protected against termination and powering off

    • notifications array[object]

      Service notifications

      • level string Required

        Notification level

        Values are warning or notice.

      • message string Required

        Human notification message

        Minimum length is 1, maximum length is 1024.

      • type string Required

        Notification type

        Values are service_powered_off_removal or service_end_of_life.

      • metadata object Required

        Notification type

    • components array[object]

      Service component information objects

      • component string Required

        Service component name

      • host string Required

        DNS name for connecting to the service component

      • port integer(int64) Required

        Port number for connecting to the service component

        Minimum value is 0, maximum value is 65535.

      • route string Required

        Network access route

        Values are dynamic, private, public, or privatelink.

      • usage string Required

        DNS usage name

        Values are primary or replica.

    • Synchronous replication type. Note that the service plan also needs to support synchronous replication.

      Values are quorum or off.

    • PGLookout settings

    • Automatic maintenance settings

      • dow string Required

        Day of week for installing updates

        Values are saturday, tuesday, never, wednesday, sunday, friday, monday, or thursday.

      • time string Required

        Time for installing updates, UTC

        Minimum length is 8, maximum length is 8.

      • updates array[object] Required

        Update waiting to be installed

        • Description of the update

        • deadline string(date-time)

          Deadline for installing the update

        • start-after string(date-time)

          The earliest time the update will be automatically applied

        • start-at string(date-time)

          The time when the update will be automatically applied

    • disk-size integer(int64)

      TODO UNIT disk space for data storage

      Minimum value is 0.

    • node-memory integer(int64)

      TODO UNIT of memory for each node

      Minimum value is 0.

    • uri string

      URI for connecting to the service (may be absent)

    • service_uri parameterized into key-value pairs

    • version string

      PostgreSQL version

    • created-at string(date-time)

      Service creation timestamp (ISO 8601)

    • plan string Required

      Subscription plan

    • work-mem integer(int64)

      Sets the maximum amount of memory to be used by a query operation (such as a sort or hash table) before writing to temporary disk files, in MB. Default is 1MB + 0.075% of total RAM (up to 32MB).

      Minimum value is 1, maximum value is 1024.

    • Percentage of total RAM that the database server uses for shared memory buffers. Valid range is 20-60 (float), which corresponds to 20% - 60%. This setting adjusts the shared_buffers configuration value.

      Minimum value is 20, maximum value is 60.

    • PostgreSQL-specific settings

    • max-connections integer(int64)

      Maximum number of connections allowed to an instance

      Minimum value is 0.

    • users array[object]

      List of service users

GET /dbaas-postgres/{name}
curl \
 -X GET https://api-ch-gva-2.exoscale.com/v2/dbaas-postgres/{name}
Response example (200)
{
  "pgbouncer-settings": {},
  "updated-at": "2023-05-04T09:42:00+00:00",
  "node-count": 42,
  "connection-info": {
    "uri": [
      "string"
    ],
    "params": [
      {}
    ],
    "standby": [
      "string"
    ],
    "syncing": [
      "string"
    ]
  },
  "backup-schedule": {
    "backup-hour": 42,
    "backup-minute": 42
  },
  "node-cpu-count": 42,
  "integrations": [
    {
      "description": "string",
      "settings": {},
      "type": "string",
      "is-enabled": true,
      "source": "string",
      "is-active": true,
      "status": "string",
      "id": "string",
      "dest": "string"
    }
  ],
  "zone": "string",
  "node-states": [
    {
      "name": "string",
      "progress-updates": [
        {
          "completed": true,
          "current": 42,
          "max": 42,
          "min": 42,
          "phase": "stream",
          "unit": "string"
        }
      ],
      "role": "standby",
      "state": "leaving"
    }
  ],
  "name": "string",
  "connection-pools": [
    {
      "connection-uri": "string",
      "database": "string",
      "mode": "transaction",
      "name": "string",
      "size": 42,
      "username": "string"
    }
  ],
  "type": "string",
  "state": "running",
  "timescaledb-settings": {},
  "databases": [
    "string"
  ],
  "ip-filter": [
    "string"
  ],
  "backups": [
    {
      "backup-name": "string",
      "backup-time": "2023-05-04T09:42:00+00:00",
      "data-size": 42
    }
  ],
  "termination-protection": true,
  "notifications": [
    {
      "level": "warning",
      "message": "string",
      "type": "service_powered_off_removal",
      "metadata": {}
    }
  ],
  "components": [
    {
      "component": "string",
      "host": "string",
      "port": 42,
      "route": "dynamic",
      "usage": "primary"
    }
  ],
  "synchronous-replication": "quorum",
  "pglookout-settings": {},
  "maintenance": {
    "dow": "saturday",
    "time": "string",
    "updates": [
      {
        "description": "string",
        "deadline": "2023-05-04T09:42:00+00:00",
        "start-after": "2023-05-04T09:42:00+00:00",
        "start-at": "2023-05-04T09:42:00+00:00"
      }
    ]
  },
  "disk-size": 42,
  "node-memory": 42,
  "uri": "string",
  "uri-params": {},
  "version": "string",
  "created-at": "2023-05-04T09:42:00+00:00",
  "plan": "string",
  "work-mem": 42,
  "shared-buffers-percentage": 42,
  "pg-settings": {},
  "max-connections": 42,
  "users": [
    {
      "type": "string",
      "username": "string",
      "password": "string",
      "allow-replication": true
    }
  ]
}