Postgres Database

Update PostgreSQL database configuration

patch/project/{project_id}/location/{location}/postgres/{postgres_database_reference}/config

Request body

OR

Example request

{
  "pg_config": {
    "max_connections": "100"
  },
  "pgbouncer_config": {
    "max_client_conn": "100"
  }
}

Response

Successful response

pg_configobject required
pgbouncer_configobject required
default_pg_configobject nullable

System-computed configuration values based on instance size. User overrides in pg_config take precedence.

messagestring

Informational message about the configuration update, such as restart requirements.

Example response

{
  "pg_config": {
    "max_connections": "100"
  },
  "pgbouncer_config": {
    "max_client_conn": "100"
  }
}