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_databases_postgresql_config

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_databases_postgresql_config	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_databases_postgresql_config

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;