Attach Parameter Group

PUT

/dbaas/{managed_db_id}/parameter-group/{pg_id}/attach/

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

Sets the parameter group’s values on the database and links the group to it in place of any group it had. Values set by an earlier group stay unless this group sets the same parameter. The values take effect without a restart; values PostgreSQL reads only at start-up take effect at the next restart. Works only with a group you created in the project; any other ID returns 404. If the database refuses the values, the group is not attached. The API does not check that the group was made for the database’s PostgreSQL version; attach a group whose family matches the database. Works only while the database is Running or Scaling. Needs the Update permission for DBaaS.

Parameters

Path Parameters

managed_db_id

required

integer

Database ID

pg_id

required

integer

Parameter group 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 group is attached

Media typeapplication/json

object

code

integer

message

string

data

object

message

string

errors

object

Example

{
  "code": 200,
  "message": "Success",
  "data": {
    "message": "Parameter group attached."
  },
  "errors": {}
}

400

The group is already attached to this database. A missing or invalid project ID gives errors “Project ID is missing or invalid”.

Media typeapplication/json

object

code

integer

message

string

data

object

errors

object

Example

{
  "code": 400,
  "message": "Bad Request",
  "data": {},
  "errors": {
    "pg_id": "Parameter group 'high-connections' is already attached."
  }
}

403

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

Media typeapplication/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 (“Invalid request! Database Not Found”), or no parameter group with that ID among yours in the project.

Media typeapplication/json

object

code

integer

message

string

data

object

errors

string

Example

{
  "code": 404,
  "message": "Bad Request",
  "data": {},
  "errors": "Parameter group not found."
}

412

The database is not Running or Scaling (as shown), or it refused the values (“Error occurred at backend! Please try after sometime.”).

Media typeapplication/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."
}