List PostgreSQL Managed Database advanced parameters

get

https://api.linode.com/{apiVersion}/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.

Permissions and scopes

To call this operation, you need permissions, based on the model you're using:

Identity and access permissions. Your user needs a role with these permissions. Learn more.
- Roles: database_viewer
OAuth scopes. Your user needs these scopes assigned. Learn more.
- Scopes: databases:read_only

CLI

linode-cli databases postgres-config

Learn more

Responses

Response body

object

Configuration values available for a postgresql.conf.

autovacuum_analyze_scale_factor

object

Settings available to configure the autovacuum_analyze_scale_factor, per Aiven's specifications.

autovacuum_analyze_threshold

object

Settings available to configure the autovacuum_analyze_threshold, per Aiven's specifications.

autovacuum_max_workers

object

Settings available to configure the autovacuum_max_workers, per Aiven's specifications.

autovacuum_naptime

object

Settings available to configure the autovacuum_naptime, per Aiven's specifications.

autovacuum_vacuum_cost_delay

object

Settings available to configure the autovacuum_vacuum_cost_delay, per Aiven's specifications.

autovacuum_vacuum_cost_limit

object

Settings available to configure the autovacuum_vacuum_cost_limit, per Aiven's specifications.

autovacuum_vacuum_scale_factor

object

Settings available to configure the autovacuum_vacuum_scale_factor, per Aiven's specifications.

autovacuum_vacuum_threshold

object

Settings available to configure the autovacuum_vacuum_threshold, per Aiven's specifications.

bgwriter_delay

object

Settings available to configure the bgwriter_delay, per Aiven's specifications.

bgwriter_flush_after

object

Settings available to configure the bgwriter_flush_after, per Aiven's specifications.

bgwriter_lru_maxpages

object

Settings available to configure bgwriter_lru_maxpages, per Aiven's specifications.

bgwriter_lru_multiplier

object

Settings available to configure the bgwriter_lru_multiplier, per Aiven's specifications.

deadlock_timeout

object

Settings available to configure the deadlock_timeout, per Aiven's specifications.

default_toast_compression

object

Settings available to configure the default_toast_compression, per Aiven's specifications.

idle_in_transaction_session_timeout

object

Settings available to configure the idle_in_transaction_session_timeout, per Aiven's specifications.

jit

object

Parameter used to enable the Just-In-Time (jit) compilation, per Aiven's specifications.

max_files_per_process

object

Settings available to configure the max_files_per_process, per Aiven's specifications.

max_locks_per_transaction

object

Settings available to configure the max_locks_per_transaction, per Aiven's specifications.

max_logical_replication_workers

object

Settings available to configure the max_logical_replication_workers, per Aiven's specifications.

max_parallel_workers

object

Settings available to configure the max_parallel_workers, per Aiven's specifications.

max_parallel_workers_per_gather

object

Settings available to configure the max_parallel_workers_per_gather, per Aiven's specifications.

max_pred_locks_per_transaction

object

Settings available to configure the max_pred_locks_per_transaction, per Aiven's specifications.

max_replication_slots

object

Settings available to configure the max_replication_slots, per Aiven's specifications.

max_slot_wal_keep_size

object

Settings available to configure the max_slot_wal_keep_size, per Aiven's specifications.

max_stack_depth

object

Settings available to configure the max_stack_depth, per Aiven's specifications.

max_standby_archive_delay

object

Settings available to configure the max_standby_archive_delay, per Aiven's specifications.

max_standby_streaming_delay

object

Settings available to configure the max_standby_streaming_delay, per Aiven's specifications.

max_wal_senders

object

Settings available to configure the max_wal_senders, per Aiven's specifications.

max_worker_processes

object

Settings available to configure the max_worker_processes, per Aiven's specifications.

password_encryption

object

Settings available to configure password_encryption, per Aiven's specifications.

pg_partman_bgw.interval

object

Settings available to configure the pg_partman_bgw.interval, per Aiven's specifications.

pg_partman_bgw.role

object

Settings available to configure the pg_partman_bgw.role, per Aiven's specifications.

pg_stat_monitor.pgsm_enable_query_plan

object

Parameter used to enable query plan monitoring, per Aiven's specifications.

pg_stat_monitor.pgsm_max_buckets

object

Settings available to configure pg_stat_monitor.pgsm_max_buckets, per Aiven's specifications.

pg_stat_statements.track

object

Settings available to configure password_encryption, per Aiven's specifications.

synchronous_replication

object

Settings available to configure synchronous_replication, per Aiven's specifications.

temp_file_limit

object

Settings available to configure the temp_file_limit, per Aiven's specifications.

timezone

object

Settings available to configure the PostgreSQL service time zone, per Aiven's specifications.

track_activity_query_size

object

Settings available to configure the track_activity_query_size, per Aiven's specifications.

track_commit_timestamp

object

Settings available to configure the track_commit_timestamp, per Aiven's specifications.

track_functions

object

Settings available to configure track_functions, per Aiven's specifications.

track_io_timing

object

Settings available to enable track_io_timing, per Aiven's specifications.

wal_sender_timeout

object

Settings available to configure the wal_sender_timeout, per Aiven's specifications.

wal_writer_delay

object

Settings available to configure the wal_writer_delay, per Aiven's specifications.

pg_stat_monitor_enable

object

Parameter used to enable the pg_stat_monitor extension for a PostgreSQL cluster, per Aiven's specifications.

description

string

The description for this parameter.

requires_restart

boolean

Whether a change to this parameter requires a restart of the PostgreSQL database.

type

string

The format of this object.

pglookout

object

Parameter used to apply PGLookout settings, per Aiven's specifications.

max_failover_replication_time_lag

object

Settings available to configure the max_failover_replication_time_lag, per Aiven's specifications.

shared_buffers_percentage

object

Parameters used to set up the shared_buffers_percentage, per Aiven's specifications.

description

string

The description for this parameter.

example

integer

An example value for this parameter.

maximum

integer

The maximum value allowed for this parameter.

minimum

integer

The minimum value allowed for this parameter.

requires_restart

boolean

Whether a change to this parameter requires a restart of the PostgreSQL database.

type

string

The format of this object.

work_mem

object

Parameters used to set up work_mem, per Aiven's specifications.

description

string

The description for this parameter.

example

integer

An example value for this parameter.

maximum

integer

The maximum value allowed for this parameter.

minimum

integer

The minimum value allowed for this parameter.

requires_restart

boolean

Whether a change to this parameter requires a restart of the PostgreSQL database.

type

string

The format of this object.

Language

Credentials


xxxxxxxxxx
1
curl --request GET \
2
     --url https://api.linode.com/v4/databases/postgresql/config \
3
     --header 'accept: application/json'


xxxxxxxxxx
372
}
1
{
2
  "pg": {
3
    "autovacuum_analyze_scale_factor": {
4
      "description": "Specifies a fraction of the table size to add to autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.2 (20% of table size)",
5
      "maximum": 1,
6
      "minimum": 0,
7
      "requires_restart": false,
8
      "type": "number"
9
    },
10
    "autovacuum_analyze_threshold": {
11
      "description": "Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.",
12
      "maximum": 2147483647,
13
      "minimum": 0,
14
      "requires_restart": false,
15
      "type": "integer"
16
    },
17
    "autovacuum_max_workers": {
18
      "description": "Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.",
19
      "maximum": 20,
20
      "minimum": 1,
21
      "requires_restart": false,
22
      "type": "integer"
23
    },
24
    "autovacuum_naptime": {
25
      "description": "Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute",
26
      "maximum": 86400,
27
      "minimum": 1,
28
      "requires_restart": false,
29
      "type": "integer"
30
    },
31
    "autovacuum_vacuum_cost_delay": {
32
      "description": "Specifies the cost delay value that will be used in automatic VACUUM operations. If -1 is specified, the regular vacuum_cost_delay value will be used. The default value is 20 milliseconds",
33
      "maximum": 100,
34
      "minimum": -1,
35
      "requires_restart": false,
36
      "type": "integer"
37
    },
38
    "autovacuum_vacuum_cost_limit": {
39
      "description": "Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used.",
40
      "maximum": 10000,
41
      "minimum": -1,
42
      "requires_restart": false,
43
      "type": "integer"
44
    },
45
    "autovacuum_vacuum_scale_factor": {
46
      "description": "Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size)",
47
      "maximum": 1,
48
      "minimum": 0,
49
      "requires_restart": false,

200PostgreSQL Managed Database advanced parameters.

defaultSee Errors for the range of possible error response codes.