postgresql_config
Creates, updates, deletes, gets or lists a postgresql_config resource.
Overview​
| Name | postgresql_config |
| Type | Resource |
| Id | linode.databases.postgresql_config |
Fields​
The following fields are returned by SELECT queries:
- get
PostgreSQL Managed Database advanced parameters.
| Name | Datatype | Description |
|---|---|---|
pg | object | Configuration values available for a postgresql.conf. |
pg_stat_monitor_enable | object | Parameter used to enable the pg_stat_monitor extension for a PostgreSQL cluster, per Aiven's specifications. |
pglookout | object | Parameter used to apply PGLookout settings, per Aiven's specifications. |
shared_buffers_percentage | object | Parameters used to set up the shared_buffers_percentage, per Aiven's specifications. |
work_mem | object | Parameters used to set up work_mem, per Aiven's specifications. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | All advanced parameters you can apply to a PostgreSQL Managed Database, via our partner Aiven. > 📘 > > Aiven may offer other parameters, but Akamai Managed Databases only supports the ones listed in this operation. Learn more... Learn more... |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|
SELECT examples​
- get
All advanced parameters you can apply to a PostgreSQL Managed Database, via our partner Aiven.
> 📘
>
> Aiven may offer other parameters, but Akamai Managed Databases only supports the ones listed in this operation.
Learn more...
Learn more...
SELECT
pg,
pg_stat_monitor_enable,
pglookout,
shared_buffers_percentage,
work_mem
FROM linode.databases.postgresql_config
;