1. Packages
  2. Linode Provider
  3. API Docs
  4. getDatabasePostgresqlConfig
Linode v5.0.0 published on Monday, Jun 23, 2025 by Pulumi

linode.getDatabasePostgresqlConfig

Explore with Pulumi AI

linode logo
Linode v5.0.0 published on Monday, Jun 23, 2025 by Pulumi

    Provides information about a Linode PostgreSQL Database’s Configuration Options. For more information, see the Linode APIv4 docs.

    Example Usage

    Get information about a PostgreSQL database’s configuration options:

    import * as pulumi from "@pulumi/pulumi";
    import * as linode from "@pulumi/linode";
    
    const my_db_config = linode.getDatabasePostgresqlConfig({});
    
    import pulumi
    import pulumi_linode as linode
    
    my_db_config = linode.get_database_postgresql_config()
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := linode.GetDatabasePostgresqlConfig(ctx, map[string]interface{}{}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Linode = Pulumi.Linode;
    
    return await Deployment.RunAsync(() => 
    {
        var my_db_config = Linode.GetDatabasePostgresqlConfig.Invoke();
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.linode.LinodeFunctions;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var my-db-config = LinodeFunctions.getDatabasePostgresqlConfig(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference);
    
        }
    }
    
    variables:
      my-db-config:
        fn::invoke:
          function: linode:getDatabasePostgresqlConfig
          arguments: {}
    

    pg_stat_monitor_enable

    The following arguments are supported in the pg_stat_monitor_enable specification block:

    • description - The description of pg_stat_monitor_enable.

    • requires_restart - Whether changing the value pg_stat_monitor_enable requires the DB to restart.

    • type - The type of the value of pg_stat_monitor_enable.

    pglookout

    The following arguments are supported in the pglookout specification block:

    • max_failover_replication_time_lag - The maximum failover replication time lag for pglookout.

    max_failover_replication_time_lag

    The following arguments are supported in the max_failover_replication_time_lag specification block:

    • description - The description of max_failover_replication_time_lag.

    • maximum - The maximum valid value for max_failover_replication_time_lag.

    • minimum - The minimum valid value for max_failover_replication_time_lag.

    • requires_restart - Whether changing the value of max_failover_replication_time_lag requires the DB to restart.

    • type - The type of the value of max_failover_replication_time_lag.

    shared_buffers_percentage

    The following arguments are supported in the shared_buffers_percentage specification block:

    • description - The description of shared_buffers_percentage.

    • example - An example of a valid value for shared_buffers_percentage.

    • maximum - The maximum valid value for shared_buffers_percentage.

    • minimum - The minimum valid value for shared_buffers_percentage.

    • requires_restart - Whether changing the value of shared_buffers_percentage requires the DB to restart.

    • type - The type of the value of shared_buffers_percentage.

    work_mem

    The following arguments are supported in the work_mem specification block:

    • description - The description of work_mem.

    • example - An example of a valid value for work_mem.

    • maximum - The maximum valid value for work_mem.

    • minimum - The minimum valid value for work_mem.

    • requires_restart - Whether changing the value of work_mem requires the DB to restart.

    • type - The type of the value of work_mem.

    pg

    The following arguments are supported in the pg specification block:

    • autovacuum_analyze_scale_factor - (Optional) 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)

    • autovacuum_analyze_threshold - (Optional) Specifies the minimum number of inserted, updated or deleted tuples needed to trigger an ANALYZE in any one table. The default is 50 tuples.

    • autovacuum_max_workers - (Optional) 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.

    • autovacuum_naptime - (Optional) Specifies the minimum delay between autovacuum runs on any given database. The delay is measured in seconds, and the default is one minute

    • autovacuum_vacuum_cost_delay - (Optional) 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

    • autovacuum_vacuum_cost_limit - (Optional) 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.

    • autovacuum_vacuum_scale_factor - (Optional) 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)

    • autovacuum_vacuum_threshold - (Optional) Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples.

    • bgwriter_delay - (Optional) Specifies the delay between activity rounds for the background writer in milliseconds. Default is 200.

    • bgwriter_flush_after - (Optional) Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlying storage. Specified in kilobytes, default is 512. Setting of 0 disables forced writeback.

    • bgwriter_lru_maxpages - (Optional) In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. Default is 100.

    • bgwriter_lru_multiplier - (Optional) The average recent need for new buffers is multiplied by bgwriter_lru_multiplier to arrive at an estimate of the number that will be needed during the next round, (up to bgwriter_lru_maxpages). 1.0 represents a “just in time” policy of writing exactly the number of buffers predicted to be needed. Larger values provide some cushion against spikes in demand, while smaller values intentionally leave writes to be done by server processes. The default is 2.0.

    • deadlock_timeout - (Optional) This is the amount of time, in milliseconds, to wait on a lock before checking to see if there is a deadlock condition.

    • default_toast_compression - (Optional) Specifies the default TOAST compression method for values of compressible columns (the default is lz4).

    • idle_in_transaction_session_timeout - (Optional) Time out sessions with open transactions after this number of milliseconds.

    • jit - (Optional) Controls system-wide use of Just-in-Time Compilation (JIT).

    • max_files_per_process - (Optional) PostgreSQL maximum number of files that can be open per process.

    • max_locks_per_transaction - (Optional) PostgreSQL maximum locks per transaction.

    • max_logical_replication_workers - (Optional) PostgreSQL maximum logical replication workers (taken from the pool of max_parallel_workers).

    • max_parallel_workers - (Optional) Sets the maximum number of workers that the system can support for parallel queries.

    • max_parallel_workers_per_gather - (Optional) Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.

    • max_pred_locks_per_transaction - (Optional) PostgreSQL maximum predicate locks per transaction.

    • max_replication_slots - (Optional) PostgreSQL maximum replication slots.

    • max_slot_wal_keep_size - (Optional) PostgreSQL maximum WAL size (MB) reserved for replication slots. Default is -1 (unlimited). wal_keep_size minimum WAL size setting takes precedence over this.

    • max_stack_depth - (Optional) Maximum depth of the stack in bytes.

    • max_standby_archive_delay - (Optional) Max standby archive delay in milliseconds.

    • max_standby_streaming_delay - (Optional) Max standby streaming delay in milliseconds.

    • max_wal_senders - (Optional) PostgreSQL maximum WAL senders.

    • max_worker_processes - (Optional) Sets the maximum number of background processes that the system can support.

    • password_encryption - (Optional) Chooses the algorithm for encrypting passwords.

    • pg_partman_bgw.interval - (Optional) Sets the time interval to run pg_partman’s scheduled tasks.

    • pg_partman_bgw.role - (Optional) Controls which role to use for pg_partman’s scheduled background tasks.

    • pg_stat_monitor.pgsm_enable_query_plan - (Optional) Enables or disables query plan monitoring.

    • pg_stat_monitor.pgsm_max_buckets - (Optional) Sets the maximum number of buckets.

    • pg_stat_statements.track - (Optional) Controls which statements are counted. Specify top to track top-level statements (those issued directly by clients), all to also track nested statements (such as statements invoked within functions), or none to disable statement statistics collection. The default value is top.

    • temp_file_limit - (Optional) PostgreSQL temporary file limit in KiB, -1 for unlimited.

    • timezone - (Optional) PostgreSQL service timezone.

    • track_activity_query_size - (Optional) Specifies the number of bytes reserved to track the currently executing command for each active session.

    • track_commit_timestamp - (Optional) Record commit time of transactions.

    • track_functions - (Optional) Enables tracking of function call counts and time used.

    • track_io_timing - (Optional) Enables timing of database I/O calls. This parameter is off by default, because it will repeatedly query the operating system for the current time, which may cause significant overhead on some platforms.

    • wal_sender_timeout - (Optional) Terminate replication connections that are inactive for longer than this amount of time, in milliseconds. Setting this value to zero disables the timeout.

    • wal_writer_delay - (Optional) WAL flush interval in milliseconds. Note that setting this value to lower than the default 200ms may negatively impact performance.

    autovacuum_analyze_scale_factor

    The following arguments are supported in the autovacuum_analyze_scale_factor specification block:

    • description - The description of autovacuum_analyze_scale_factor.

    • maximum - The maximum valid value for autovacuum_analyze_scale_factor.

    • minimum - The minimum valid value for autovacuum_analyze_scale_factor.

    • requires_restart - Whether changing the value of autovacuum_analyze_scale_factor requires the DB to restart.

    • type - The type of the value of autovacuum_analyze_scale_factor.

    autovacuum_analyze_threshold

    The following arguments are supported in the autovacuum_analyze_threshold specification block:

    • description - The description of autovacuum_analyze_threshold.

    • maximum - The maximum valid value for autovacuum_analyze_threshold.

    • minimum - The minimum valid value for autovacuum_analyze_threshold.

    • requires_restart - Whether changing the value of autovacuum_analyze_threshold requires the DB to restart.

    • type - The type of the value of autovacuum_analyze_threshold.

    autovacuum_max_workers

    The following arguments are supported in the autovacuum_max_workers specification block:

    • description - The description of autovacuum_max_workers.

    • maximum - The maximum valid value for autovacuum_max_workers.

    • minimum - The minimum valid value for autovacuum_max_workers.

    • requires_restart - Whether changing the value of autovacuum_max_workers requires the DB to restart.

    • type - The type of the value of autovacuum_max_workers.

    autovacuum_naptime

    The following arguments are supported in the autovacuum_naptime specification block:

    • description - The description of autovacuum_naptime.

    • maximum - The maximum valid value for autovacuum_naptime.

    • minimum - The minimum valid value for autovacuum_naptime.

    • requires_restart - Whether changing the value of autovacuum_naptime requires the DB to restart.

    • type - The type of the value of autovacuum_naptime.

    autovacuum_vacuum_cost_delay

    The following arguments are supported in the autovacuum_vacuum_cost_delay specification block:

    • description - The description of autovacuum_vacuum_cost_delay.

    • maximum - The maximum valid value for autovacuum_vacuum_cost_delay.

    • minimum - The minimum valid value for autovacuum_vacuum_cost_delay.

    • requires_restart - Whether changing the value of autovacuum_vacuum_cost_delay requires the DB to restart.

    • type - The type of the value of autovacuum_vacuum_cost_delay.

    autovacuum_vacuum_cost_limit

    The following arguments are supported in the autovacuum_vacuum_cost_limit specification block:

    • description - The description of autovacuum_vacuum_cost_limit.

    • maximum - The maximum valid value for autovacuum_vacuum_cost_limit.

    • minimum - The minimum valid value for autovacuum_vacuum_cost_limit.

    • requires_restart - Whether changing the value of autovacuum_vacuum_cost_limit requires the DB to restart.

    • type - The type of the value of autovacuum_vacuum_cost_limit.

    autovacuum_vacuum_scale_factor

    The following arguments are supported in the autovacuum_vacuum_scale_factor specification block:

    • description - The description of autovacuum_vacuum_scale_factor.

    • maximum - The maximum valid value for autovacuum_vacuum_scale_factor.

    • minimum - The minimum valid value for autovacuum_vacuum_scale_factor.

    • requires_restart - Whether changing the value of autovacuum_vacuum_scale_factor requires the DB to restart.

    • type - The type of the value of autovacuum_vacuum_scale_factor.

    autovacuum_vacuum_threshold

    The following arguments are supported in the autovacuum_vacuum_threshold specification block:

    • description - The description of autovacuum_vacuum_threshold.

    • maximum - The maximum valid value for autovacuum_vacuum_threshold.

    • minimum - The minimum valid value for autovacuum_vacuum_threshold.

    • requires_restart - Whether changing the value of autovacuum_vacuum_threshold requires the DB to restart.

    • type - The type of the value of autovacuum_vacuum_threshold.

    bgwriter_delay

    The following arguments are supported in the bgwriter_delay specification block:

    • description - The description of bgwriter_delay.

    • example - An example of a valid value for bgwriter_delay.

    • maximum - The maximum valid value for bgwriter_delay.

    • minimum - The minimum valid value for bgwriter_delay.

    • requires_restart - Whether changing the value of bgwriter_delay requires the DB to restart.

    • type - The type of the value of bgwriter_delay.

    bgwriter_flush_after

    The following arguments are supported in the bgwriter_flush_after specification block:

    • description - The description of bgwriter_flush_after.

    • example - An example of a valid value for bgwriter_flush_after.

    • maximum - The maximum valid value for bgwriter_flush_after.

    • minimum - The minimum valid value for bgwriter_flush_after.

    • requires_restart - Whether changing the value of bgwriter_flush_after requires the DB to restart.

    • type - The type of the value of bgwriter_flush_after.

    bgwriter_lru_maxpages

    The following arguments are supported in the bgwriter_lru_maxpages specification block:

    • description - The description of bgwriter_lru_maxpages.

    • example - An example of a valid value for bgwriter_lru_maxpages.

    • maximum - The maximum valid value for bgwriter_lru_maxpages.

    • minimum - The minimum valid value for bgwriter_lru_maxpages.

    • requires_restart - Whether changing the value of bgwriter_lru_maxpages requires the DB to restart.

    • type - The type of the value of bgwriter_lru_maxpages.

    bgwriter_lru_multiplier

    The following arguments are supported in the bgwriter_lru_multiplier specification block:

    • description - The description of bgwriter_lru_multiplier.

    • example - An example of a valid value for bgwriter_lru_multiplier.

    • maximum - The maximum valid value for bgwriter_lru_multiplier.

    • minimum - The minimum valid value for bgwriter_lru_multiplier.

    • requires_restart - Whether changing the value of bgwriter_lru_multiplier requires the DB to restart.

    • type - The type of the value of bgwriter_lru_multiplier.

    deadlock_timeout

    The following arguments are supported in the deadlock_timeout specification block:

    • description - The description of deadlock_timeout.

    • example - An example of a valid value for deadlock_timeout.

    • maximum - The maximum valid value for deadlock_timeout.

    • minimum - The minimum valid value for deadlock_timeout.

    • requires_restart - Whether changing the value of deadlock_timeout requires the DB to restart.

    • type - The type of the value of deadlock_timeout.

    default_toast_compression

    The following arguments are supported in the default_toast_compression specification block:

    • description - The description of default_toast_compression.

    • enum - A list of valid compression methods for default_toast_compression.

    • example - An example of a valid value for default_toast_compression.

    • requires_restart - Whether changing the value of default_toast_compression requires the DB to restart.

    • type - The type of the value of default_toast_compression.

    idle_in_transaction_session_timeout

    The following arguments are supported in the idle_in_transaction_session_timeout specification block:

    • description - The description of idle_in_transaction_session_timeout.

    • maximum - The maximum valid value for idle_in_transaction_session_timeout.

    • minimum - The minimum valid value for idle_in_transaction_session_timeout.

    • requires_restart - Whether changing the value of idle_in_transaction_session_timeout requires the DB to restart.

    • type - The type of the value of idle_in_transaction_session_timeout.

    jit

    The following arguments are supported in the jit specification block:

    • description - The description of jit.

    • example - An example of a valid value for jit.

    • requires_restart - Whether changing the value of jit requires the DB to restart.

    • type - The type of the value of jit.

    max_files_per_process

    The following arguments are supported in the max_files_per_process specification block:

    • description - The description of max_files_per_process.

    • maximum - The maximum valid value for max_files_per_process.

    • minimum - The minimum valid value for max_files_per_process.

    • requires_restart - Whether changing the value of max_files_per_process requires the DB to restart.

    • type - The type of the value of max_files_per_process.

    max_locks_per_transaction

    The following arguments are supported in the max_locks_per_transaction specification block:

    • description - The description of max_locks_per_transaction.

    • maximum - The maximum valid value for max_locks_per_transaction.

    • minimum - The minimum valid value for max_locks_per_transaction.

    • requires_restart - Whether changing the value of max_locks_per_transaction requires the DB to restart.

    • type - The type of the value of max_locks_per_transaction.

    max_logical_replication_workers

    The following arguments are supported in the max_logical_replication_workers specification block:

    • description - The description of max_logical_replication_workers.

    • maximum - The maximum valid value for max_logical_replication_workers.

    • minimum - The minimum valid value for max_logical_replication_workers.

    • requires_restart - Whether changing the value of max_logical_replication_workers requires the DB to restart.

    • type - The type of the value of max_logical_replication_workers.

    max_parallel_workers

    The following arguments are supported in the max_parallel_workers specification block:

    • description - The description of max_parallel_workers.

    • maximum - The maximum valid value for max_parallel_workers.

    • minimum - The minimum valid value for max_parallel_workers.

    • requires_restart - Whether changing the value of max_parallel_workers requires the DB to restart.

    • type - The type of the value of max_parallel_workers.

    max_parallel_workers_per_gather

    The following arguments are supported in the max_parallel_workers_per_gather specification block:

    • description - The description of max_parallel_workers_per_gather.

    • maximum - The maximum valid value for max_parallel_workers_per_gather.

    • minimum - The minimum valid value for max_parallel_workers_per_gather.

    • requires_restart - Whether changing the value of max_parallel_workers_per_gather requires the DB to restart.

    • type - The type of the value of max_parallel_workers_per_gather.

    max_pred_locks_per_transaction

    The following arguments are supported in the max_pred_locks_per_transaction specification block:

    • description - The description of max_pred_locks_per_transaction.

    • maximum - The maximum valid value for max_pred_locks_per_transaction.

    • minimum - The minimum valid value for max_pred_locks_per_transaction.

    • requires_restart - Whether changing the value of max_pred_locks_per_transaction requires the DB to restart.

    • type - The type of the value of max_pred_locks_per_transaction.

    max_replication_slots

    The following arguments are supported in the max_replication_slots specification block:

    • description - The description of max_replication_slots.

    • maximum - The maximum valid value for max_replication_slots.

    • minimum - The minimum valid value for max_replication_slots.

    • requires_restart - Whether changing the value of max_replication_slots requires the DB to restart.

    • type - The type of the value of max_replication_slots.

    max_slot_wal_keep_size

    The following arguments are supported in the max_slot_wal_keep_size specification block:

    • description - The description of max_slot_wal_keep_size.

    • maximum - The maximum valid value for max_slot_wal_keep_size.

    • minimum - The minimum valid value for max_slot_wal_keep_size.

    • requires_restart - Whether changing the value of max_slot_wal_keep_size requires the DB to restart.

    • type - The type of the value of max_slot_wal_keep_size.

    max_stack_depth

    The following arguments are supported in the max_stack_depth specification block:

    • description - The description of max_stack_depth.

    • maximum - The maximum valid value for max_stack_depth.

    • minimum - The minimum valid value for max_stack_depth.

    • requires_restart - Whether changing the value of max_stack_depth requires the DB to restart.

    • type - The type of the value of max_stack_depth.

    max_standby_archive_delay

    The following arguments are supported in the max_standby_archive_delay specification block:

    • description - The description of max_standby_archive_delay.

    • maximum - The maximum valid value for max_standby_archive_delay.

    • minimum - The minimum valid value for max_standby_archive_delay.

    • requires_restart - Whether changing the value of max_standby_archive_delay requires the DB to restart.

    • type - The type of the value of max_standby_archive_delay.

    max_standby_streaming_delay

    The following arguments are supported in the max_standby_streaming_delay specification block:

    • description - The description of max_standby_streaming_delay.

    • maximum - The maximum valid value for max_standby_streaming_delay.

    • minimum - The minimum valid value for max_standby_streaming_delay.

    • requires_restart - Whether changing the value of max_standby_streaming_delay requires the DB to restart.

    • type - The type of the value of max_standby_streaming_delay.

    max_wal_senders

    The following arguments are supported in the max_wal_senders specification block:

    • description - The description of max_wal_senders.

    • maximum - The maximum valid value for max_wal_senders.

    • minimum - The minimum valid value for max_wal_senders.

    • requires_restart - Whether changing the value of max_wal_senders requires the DB to restart.

    • type - The type of the value of max_wal_senders.

    max_worker_processes

    The following arguments are supported in the max_worker_processes specification block:

    • description - The description of max_worker_processes.

    • maximum - The maximum valid value for max_worker_processes.

    • minimum - The minimum valid value for max_worker_processes.

    • requires_restart - Whether changing the value of max_worker_processes requires the DB to restart.

    • type - The type of the value of max_worker_processes.

    password_encryption

    The following arguments are supported in the password_encryption specification block:

    • description - The description of the password_encryption setting.

    • enum - A list of valid values for the password_encryption setting.

    • example - An example value for the password_encryption setting.

    • requires_restart - Whether changing the value of password_encryption requires the DB to restart.

    • type - A list of types for the password_encryption setting.

    pg_partman_bgw_interval

    The following arguments are supported in the pg_partman_bgw_interval specification block:

    • description - The description of the pg_partman_bgw_interval setting.

    • example - An example value for the pg_partman_bgw_interval setting.

    • maximum - The maximum allowed value for the pg_partman_bgw_interval setting.

    • minimum - The minimum allowed value for the pg_partman_bgw_interval setting.

    • requires_restart - Whether changing the value of pg_partman_bgw_interval requires the DB to restart.

    • type - The type of the pg_partman_bgw_interval setting.

    pg_partman_bgw_role

    The following arguments are supported in the pg_partman_bgw_role specification block:

    • description - The description of the pg_partman_bgw_role setting.

    • example - An example value for the pg_partman_bgw_role setting.

    • maxLength - The maximum length for the pg_partman_bgw_role setting.

    • pattern - The regular expression pattern for validating the pg_partman_bgw_role setting.

    • requires_restart - Whether changing the value of pg_partman_bgw_role requires the DB to restart.

    • type - The type of the pg_partman_bgw_role setting.

    pg_stat_monitor_pgsm_enable_query_plan

    The following arguments are supported in the pg_stat_monitor_pgsm_enable_query_plan specification block:

    • description - The description of the pg_stat_monitor_pgsm_enable_query_plan setting.

    • example - An example value for the pg_stat_monitor_pgsm_enable_query_plan setting.

    • requires_restart - Whether changing the value of pg_stat_monitor_pgsm_enable_query_plan requires the DB to restart.

    • type - The type of the pg_stat_monitor_pgsm_enable_query_plan setting.

    pg_stat_monitor_pgsm_max_buckets

    The following arguments are supported in the pg_stat_monitor_pgsm_max_buckets specification block:

    • description - The description of the pg_stat_monitor_pgsm_max_buckets setting.

    • example - An example value for the pg_stat_monitor_pgsm_max_buckets setting.

    • maximum - The maximum allowed value for the pg_stat_monitor_pgsm_max_buckets setting.

    • minimum - The minimum allowed value for the pg_stat_monitor_pgsm_max_buckets setting.

    • requires_restart - Whether changing the value of pg_stat_monitor_pgsm_max_buckets requires the DB to restart.

    • type - The type of the pg_stat_monitor_pgsm_max_buckets setting.

    pg_stat_statements_track

    The following arguments are supported in the pg_stat_statements_track specification block:

    • description - The description of the pg_stat_statements_track setting.

    • enum - A list of valid values for the pg_stat_statements_track setting.

    • requires_restart - Whether changing the value of pg_stat_statements_track requires the DB to restart.

    • type - The type of the pg_stat_statements_track setting.

    temp_file_limit

    The following arguments are supported in the temp_file_limit specification block:

    • description - The description of the temp_file_limit setting.

    • example - An example value for the temp_file_limit setting.

    • maximum - The maximum allowed value for the temp_file_limit setting.

    • minimum - The minimum allowed value for the temp_file_limit setting.

    • requires_restart - Whether changing the value of temp_file_limit requires the DB to restart.

    • type - The type of the temp_file_limit setting.

    timezone

    The following arguments are supported in the timezone specification block:

    • description - The description of the timezone setting.

    • example - An example value for the timezone setting.

    • maxLength - The maximum length for the timezone setting.

    • pattern - The regular expression pattern for validating the timezone setting.

    • requires_restart - Whether changing the value of timezone requires the DB to restart.

    • type - The type of the timezone setting.

    track_activity_query_size

    The following arguments are supported in the track_activity_query_size specification block:

    • description - The description of the track_activity_query_size setting.

    • example - An example value for the track_activity_query_size setting.

    • maximum - The maximum allowed value for the track_activity_query_size setting.

    • minimum - The minimum allowed value for the track_activity_query_size setting.

    • requires_restart - Whether changing the value of track_activity_query_size requires the DB to restart.

    • type - The type of the track_activity_query_size setting.

    track_commit_timestamp

    The following arguments are supported in the track_commit_timestamp specification block:

    • description - The description of the track_commit_timestamp setting.

    • enum - A list of valid values for the track_commit_timestamp setting.

    • example - An example value for the track_commit_timestamp setting.

    • requires_restart - Whether changing the value of track_commit_timestamp requires the DB to restart.

    • type - The type of the track_commit_timestamp setting.

    track_functions

    The following arguments are supported in the track_functions specification block:

    • description - The description of the track_functions setting.

    • enum - A list of valid values for the track_functions setting.

    • requires_restart - Whether changing the value of track_functions requires the DB to restart.

    • type - The type of the track_functions setting.

    track_io_timing

    The following arguments are supported in the track_io_timing specification block:

    • description - The description of the track_io_timing setting.

    • enum - A list of valid values for the track_io_timing setting.

    • example - An example value for the track_io_timing setting.

    • requires_restart - Whether changing the value of track_io_timing requires the DB to restart.

    • type - The type of the track_io_timing setting.

    wal_sender_timeout

    The following arguments are supported in the wal_sender_timeout specification block:

    • description - The description of the wal_sender_timeout setting.

    • example - An example value for the wal_sender_timeout setting.

    • requires_restart - Whether changing the value of wal_sender_timeout requires the DB to restart.

    • type - The type of the wal_sender_timeout setting.

    wal_writer_delay

    The following arguments are supported in the wal_writer_delay specification block:

    • description - The description of the wal_writer_delay setting.

    • example - An example value for the wal_writer_delay setting.

    • maximum - The maximum allowed value for the wal_writer_delay setting.

    • minimum - The minimum allowed value for the wal_writer_delay setting.

    • requires_restart - Whether changing the value of wal_writer_delay requires the DB to restart.

    • type - The type of the wal_writer_delay setting.

    Using getDatabasePostgresqlConfig

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getDatabasePostgresqlConfig(opts?: InvokeOptions): Promise<GetDatabasePostgresqlConfigResult>
    function getDatabasePostgresqlConfigOutput(opts?: InvokeOptions): Output<GetDatabasePostgresqlConfigResult>
    def get_database_postgresql_config(opts: Optional[InvokeOptions] = None) -> GetDatabasePostgresqlConfigResult
    def get_database_postgresql_config_output(opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePostgresqlConfigResult]
    func GetDatabasePostgresqlConfig(ctx *Context, opts ...InvokeOption) (*GetDatabasePostgresqlConfigResult, error)
    func GetDatabasePostgresqlConfigOutput(ctx *Context, opts ...InvokeOption) GetDatabasePostgresqlConfigResultOutput

    > Note: This function is named GetDatabasePostgresqlConfig in the Go SDK.

    public static class GetDatabasePostgresqlConfig 
    {
        public static Task<GetDatabasePostgresqlConfigResult> InvokeAsync(InvokeOptions? opts = null)
        public static Output<GetDatabasePostgresqlConfigResult> Invoke(InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetDatabasePostgresqlConfigResult> getDatabasePostgresqlConfig(InvokeOptions options)
    public static Output<GetDatabasePostgresqlConfigResult> getDatabasePostgresqlConfig(InvokeOptions options)
    
    fn::invoke:
      function: linode:index/getDatabasePostgresqlConfig:getDatabasePostgresqlConfig
      arguments:
        # arguments dictionary

    getDatabasePostgresqlConfig Result

    The following output properties are available:

    Supporting Types

    GetDatabasePostgresqlConfigPgStatMonitorEnable

    description String
    requiresRestart Boolean
    type String
    description string
    requiresRestart boolean
    type string
    description String
    requiresRestart Boolean
    type String

    GetDatabasePostgresqlConfigPglookout

    GetDatabasePostgresqlConfigPglookoutMaxFailoverReplicationTimeLag

    description String
    maximum Integer
    minimum Integer
    requiresRestart Boolean
    type String
    description string
    maximum number
    minimum number
    requiresRestart boolean
    type string
    description String
    maximum Number
    minimum Number
    requiresRestart Boolean
    type String

    GetDatabasePostgresqlConfigSharedBuffersPercentage

    Description string
    Example double
    Maximum double
    Minimum double
    RequiresRestart bool
    Type string
    Description string
    Example float64
    Maximum float64
    Minimum float64
    RequiresRestart bool
    Type string
    description String
    example Double
    maximum Double
    minimum Double
    requiresRestart Boolean
    type String
    description string
    example number
    maximum number
    minimum number
    requiresRestart boolean
    type string
    description String
    example Number
    maximum Number
    minimum Number
    requiresRestart Boolean
    type String

    GetDatabasePostgresqlConfigWorkMem

    description String
    example Integer
    maximum Integer
    minimum Integer
    requiresRestart Boolean
    type String
    description string
    example number
    maximum number
    minimum number
    requiresRestart boolean
    type string
    description String
    example Number
    maximum Number
    minimum Number
    requiresRestart Boolean
    type String

    Package Details

    Repository
    Linode pulumi/pulumi-linode
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the linode Terraform Provider.
    linode logo
    Linode v5.0.0 published on Monday, Jun 23, 2025 by Pulumi