Get Database Configuration

GET

/dbaas/{managed_db_id}/configuration/

curl --request GET \
  --url 'https://api.e2enetworks.com/myaccount/api/v1/gpu/dbaas/{managed_db_id}/configuration/?project_id=<PROJECT_ID>&location=<LOCATION>&apikey=<API_KEY>' \
  --header 'Authorization: Bearer <API_TOKEN>'

import requests

response = requests.get(
    "https://api.e2enetworks.com/myaccount/api/v1/gpu/dbaas/{managed_db_id}/configuration/",
    params={"project_id": "<PROJECT_ID>", "location": "<LOCATION>", "apikey": "<API_KEY>"},
    headers={"Authorization": "Bearer <API_TOKEN>"},
)
print(response.json())

const url = new URL("https://api.e2enetworks.com/myaccount/api/v1/gpu/dbaas/{managed_db_id}/configuration/");
url.search = new URLSearchParams({ project_id: "<PROJECT_ID>", location: "<LOCATION>", apikey: "<API_KEY>" });

const response = await fetch(url, {
  method: "GET",
  headers: { "Authorization": "Bearer <API_TOKEN>" },
});
console.log(await response.json());

Returns the attached parameter group and the installed extensions. The database must be Running. Needs the Read permission on DBaaS.

Parameters

Path Parameters

managed_db_id

required

integer

Database ID

Query Parameters

project_id

required

integer

Project ID

active_iam

integer

Active IAM ID (To access contact person account) Find your Active IAM ID here

location

required

string

Allowed values: Delhi Chennai

Location

Responses

200

The configuration

application/json

object

code

integer

message

string

data

object

parameter_group

The attached parameter group; null when none is attached.

object

integer

name

string

status

string

extensions

Extensions installed on the database, read live. Until the database answers, the extensions set at creation.

object

status

integer

data

object

extensions

Array<string>

count

integer

errors

object

log

string

success

boolean

errors

object

Example

{
  "code": 200,
  "message": "Success",
  "data": {
    "parameter_group": {
      "id": 8,
      "name": "orders-tuning",
      "status": "synced"
    },
    "extensions": {
      "status": 200,
      "data": {
        "extensions": [
          "pg_stat_statements",
          "plpgsql",
          "vector"
        ],
        "count": 3
      },
      "errors": {},
      "log": "Success",
      "success": true
    }
  },
  "errors": {}
}

400

The project ID is missing or is not a number.

application/json

object

code

integer

message

string

data

object

errors

string

Example

{
  "code": 400,
  "message": "Bad Request",
  "data": {},
  "errors": "Project ID is missing or invalid"
}

403

The caller lacks the permission the call needs on the project, or the region is not allowed.

application/json

object

code

integer

message

string

data

object

errors

string

Example

{
  "code": 403,
  "message": "Forbidden",
  "data": {},
  "errors": "You don't have permission to access this service. Please verify your policy or project."
}

404

No database with that ID in the project and region.

application/json

object

code

integer

message

string

data

object

errors

string

Example

{
  "code": 404,
  "message": "Bad Request",
  "data": {},
  "errors": "Invalid request! Database Not Found"
}

412

The database is not Running (“Database NOT in RUNNING state. Please try again later.”).

application/json

object

code

integer

message

string

data

object

errors

string

Example

{
  "code": 412,
  "message": "Precondition Failed",
  "data": {},
  "errors": "Database NOT in RUNNING state. Please try again later."
}