# Create a DBaaS PostgreSQL service

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




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



## Parameters

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



### Body: application/json (object)

- **pgbouncer-settings** (object)
  System-wide settings for pgbouncer.
- **backup-schedule** (object)

- **variant** (string)

- **integrations** (array[object])
  Service integrations to be enabled when creating the service.
- **timescaledb-settings** (object)
  System-wide settings for the timescaledb extension
- **ip-filter** (array[string])
  Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
- **termination-protection** (boolean)
  Service is protected against termination and powering off
- **fork-from-service** (string)

- **synchronous-replication** (string)

- **recovery-backup-time** (string)
  ISO time of a backup to recover from for services that support arbitrary times
- **pglookout-settings** (object)
  System-wide settings for pglookout.
- **maintenance** (object)
  Automatic maintenance settings
- **admin-username** (string)
  Custom username for admin user. This must be set only when a new service is being created.
- **version** (string)

- **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)

- **admin-password** (string)
  Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- **migration** (object)
  Migrate data from existing server


## Responses
### 200
200

#### Body: application/json (object)
- **id** (string(uuid))
  Operation ID
- **reason** (string)
  Operation failure reason
- **reference** (object)
  Related resource reference
- **message** (string)
  Operation message
- **state** (string)
  Operation status


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