# Get a DBaaS PostgreSQL service

**GET /dbaas-postgres/{name}**

Get a DBaaS PostgreSQL service


## Servers
- https://api-ch-gva-2.exoscale.com/v2: https://api-ch-gva-2.exoscale.com/v2 ()



## Parameters

### Path parameters
- **name** (string)




## Responses
### 200
200

#### Body: application/json (object)
- **pgbouncer-settings** (object)
  System-wide settings for pgbouncer.
- **updated-at** (string(date-time))
  Service last update timestamp (ISO 8601)
- **node-count** (integer(int64))
  Number of service nodes in the active plan
- **connection-info** (object)
  PG connection information properties
- **backup-schedule** (object)
  Backup schedule
- **node-cpu-count** (integer(int64))
  Number of CPUs for each node
- **prometheus-uri** (object)
  Prometheus integration URI
- **integrations** (array[object])
  Service integrations
- **zone** (string)
  The zone where the service is running
- **node-states** (array[object])
  State of individual service nodes
- **name** (string)

- **connection-pools** (array[object])
  PostgreSQL PGBouncer connection pools
- **type** (string)

- **state** (string)

- **timescaledb-settings** (object)
  System-wide settings for the timescaledb extension
- **databases** (array[string])
  List of PostgreSQL databases
- **ip-filter** (array[string])
  Allowed CIDR address blocks for incoming connections
- **backups** (array[object])
  List of backups for the service
- **termination-protection** (boolean)
  Service is protected against termination and powering off
- **notifications** (array[object])
  Service notifications
- **components** (array[object])
  Service component information objects
- **synchronous-replication** (string)

- **pglookout-settings** (object)
  System-wide settings for pglookout.
- **maintenance** (object)
  Automatic maintenance settings
- **disk-size** (integer(int64))
  TODO UNIT disk space for data storage
- **node-memory** (integer(int64))
  TODO UNIT of memory for each node
- **uri** (string)
  URI for connecting to the service (may be absent)
- **uri-params** (object)
  service_uri parameterized into key-value pairs
- **version** (string)
  PostgreSQL version
- **created-at** (string(date-time))
  Service creation timestamp (ISO 8601)
- **plan** (string)
  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).
- **shared-buffers-percentage** (integer(int64))
  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.
- **pg-settings** (object)

- **max-connections** (integer(int64))
  Maximum number of connections allowed to an instance
- **users** (array[object])
  List of service users


[Powered by Bump.sh](https://bump.sh)