/v1/organizations/{organizationId}/postgresThis endpoint is in beta. API contract is stable, and no breaking changes are expected in the future.
Creates a new Postgres service in the organization and returns it. The service is started asynchronously.
Permission
The API key must have the control-plane:organization:create-service permission.
Path parameters
Request bodyJSON
- ipAccessListoptionalarray ofobject
IPv4 TCP access rules to apply when creating the service. Omit to allow all IPv4 and IPv6 addresses on Postgres (5432) and PgBouncer (6432). Provide an empty list to block public access. When provided, only these rules are allowed; include separate rules for each required port.
- pgConfigoptionalobject
Postgres runtime configuration configuration.
Example: {"max_connections":100} - pgBouncerConfigoptionalmap ofstring
PgBouncer runtime configuration configuration.
Example: {"default_pool_size":"16"}
Response
200
Successful response
400
The request cannot be processed due to a client error. Please verify your request parameters and try again.
500
An internal server error has occurred. If this issue persists, please contact ClickHouse Cloud support for assistance.