@akamai/openapi-ts
    Preparing search index...

    Type Alias GetDatabasesPostgresqlConfigResponses

    type GetDatabasesPostgresqlConfigResponses = {
        "200": {
            pg: {
                autovacuum_analyze_scale_factor: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_analyze_threshold: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_max_workers: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_naptime: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_vacuum_cost_delay: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_vacuum_cost_limit: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_vacuum_scale_factor: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                autovacuum_vacuum_threshold: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                bgwriter_delay: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                bgwriter_flush_after: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                bgwriter_lru_maxpages: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                bgwriter_lru_multiplier: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                deadlock_timeout: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                default_toast_compression: {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                idle_in_transaction_session_timeout: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                jit: {
                    description: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                max_files_per_process: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_locks_per_transaction: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_logical_replication_workers: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_parallel_workers: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_parallel_workers_per_gather: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_pred_locks_per_transaction: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_replication_slots: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_slot_wal_keep_size: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_stack_depth: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_standby_archive_delay: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_standby_streaming_delay: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_wal_senders: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                max_worker_processes: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                password_encryption: {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                "pg_partman_bgw.interval": {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                "pg_partman_bgw.role": {
                    description: string;
                    example: string;
                    maxLength: number;
                    pattern: string;
                    requires_restart: boolean;
                    type: string;
                };
                "pg_stat_monitor.pgsm_enable_query_plan": {
                    description: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                "pg_stat_monitor.pgsm_max_buckets": {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                "pg_stat_statements.track": {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: number[];
                };
                temp_file_limit: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                timezone: {
                    description: string;
                    example: string;
                    maxLength: number;
                    pattern: string;
                    requires_restart: boolean;
                    type: string;
                };
                track_activity_query_size: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
                track_commit_timestamp: {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                track_functions: {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                track_io_timing: {
                    description: string;
                    enum: string;
                    example: string;
                    requires_restart: boolean;
                    type: string;
                };
                wal_sender_timeout: {
                    description: string;
                    example: number;
                    requires_restart: boolean;
                    type: string;
                };
                wal_writer_delay: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
            };
            pg_stat_monitor_enable: {
                description: string;
                requires_restart: boolean;
                type: string;
            };
            pglookout: {
                max_failover_replication_time_lag: {
                    description: string;
                    example: number;
                    maximum: number;
                    minimum: number;
                    requires_restart: boolean;
                    type: string;
                };
            };
            shared_buffers_percentage: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            work_mem: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
        };
    }
    Index

    Properties

    200

    Properties

    "200": {
        pg: {
            autovacuum_analyze_scale_factor: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_analyze_threshold: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_max_workers: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_naptime: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_vacuum_cost_delay: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_vacuum_cost_limit: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_vacuum_scale_factor: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            autovacuum_vacuum_threshold: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            bgwriter_delay: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            bgwriter_flush_after: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            bgwriter_lru_maxpages: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            bgwriter_lru_multiplier: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            deadlock_timeout: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            default_toast_compression: {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            idle_in_transaction_session_timeout: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            jit: {
                description: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            max_files_per_process: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_locks_per_transaction: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_logical_replication_workers: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_parallel_workers: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_parallel_workers_per_gather: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_pred_locks_per_transaction: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_replication_slots: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_slot_wal_keep_size: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_stack_depth: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_standby_archive_delay: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_standby_streaming_delay: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_wal_senders: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            max_worker_processes: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            password_encryption: {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            "pg_partman_bgw.interval": {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            "pg_partman_bgw.role": {
                description: string;
                example: string;
                maxLength: number;
                pattern: string;
                requires_restart: boolean;
                type: string;
            };
            "pg_stat_monitor.pgsm_enable_query_plan": {
                description: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            "pg_stat_monitor.pgsm_max_buckets": {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            "pg_stat_statements.track": {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: number[];
            };
            temp_file_limit: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            timezone: {
                description: string;
                example: string;
                maxLength: number;
                pattern: string;
                requires_restart: boolean;
                type: string;
            };
            track_activity_query_size: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
            track_commit_timestamp: {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            track_functions: {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            track_io_timing: {
                description: string;
                enum: string;
                example: string;
                requires_restart: boolean;
                type: string;
            };
            wal_sender_timeout: {
                description: string;
                example: number;
                requires_restart: boolean;
                type: string;
            };
            wal_writer_delay: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
        };
        pg_stat_monitor_enable: {
            description: string;
            requires_restart: boolean;
            type: string;
        };
        pglookout: {
            max_failover_replication_time_lag: {
                description: string;
                example: number;
                maximum: number;
                minimum: number;
                requires_restart: boolean;
                type: string;
            };
        };
        shared_buffers_percentage: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        };
        work_mem: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        };
    }

    Available advanced parameters for a PostgreSQL Managed Database.

    Type Declaration

    • pg: {
          autovacuum_analyze_scale_factor: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_analyze_threshold: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_max_workers: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_naptime: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_vacuum_cost_delay: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_vacuum_cost_limit: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_vacuum_scale_factor: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          autovacuum_vacuum_threshold: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          bgwriter_delay: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          bgwriter_flush_after: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          bgwriter_lru_maxpages: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          bgwriter_lru_multiplier: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          deadlock_timeout: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          default_toast_compression: {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          idle_in_transaction_session_timeout: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          jit: {
              description: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          max_files_per_process: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_locks_per_transaction: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_logical_replication_workers: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_parallel_workers: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_parallel_workers_per_gather: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_pred_locks_per_transaction: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_replication_slots: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_slot_wal_keep_size: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_stack_depth: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_standby_archive_delay: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_standby_streaming_delay: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_wal_senders: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          max_worker_processes: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          password_encryption: {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          "pg_partman_bgw.interval": {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          "pg_partman_bgw.role": {
              description: string;
              example: string;
              maxLength: number;
              pattern: string;
              requires_restart: boolean;
              type: string;
          };
          "pg_stat_monitor.pgsm_enable_query_plan": {
              description: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          "pg_stat_monitor.pgsm_max_buckets": {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          "pg_stat_statements.track": {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: number[];
          };
          temp_file_limit: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          timezone: {
              description: string;
              example: string;
              maxLength: number;
              pattern: string;
              requires_restart: boolean;
              type: string;
          };
          track_activity_query_size: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
          track_commit_timestamp: {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          track_functions: {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          track_io_timing: {
              description: string;
              enum: string;
              example: string;
              requires_restart: boolean;
              type: string;
          };
          wal_sender_timeout: {
              description: string;
              example: number;
              requires_restart: boolean;
              type: string;
          };
          wal_writer_delay: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
      }

      Configuration values available for a postgresql.conf.

      • autovacuum_analyze_scale_factor: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_analyze_threshold: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_max_workers: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_naptime: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_vacuum_cost_delay: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_vacuum_cost_limit: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_vacuum_scale_factor: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • autovacuum_vacuum_threshold: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • bgwriter_delay: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • bgwriter_flush_after: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • bgwriter_lru_maxpages: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • bgwriter_lru_multiplier: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • deadlock_timeout: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • default_toast_compression: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: string

          The format of this object.

      • idle_in_transaction_session_timeout: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • jit: {
            description: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: string

          An example boolean value 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.

      • max_files_per_process: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_locks_per_transaction: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_logical_replication_workers: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_parallel_workers: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_parallel_workers_per_gather: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_pred_locks_per_transaction: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_replication_slots: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_slot_wal_keep_size: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_stack_depth: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_standby_archive_delay: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_standby_streaming_delay: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_wal_senders: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • max_worker_processes: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • password_encryption: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: string

          The format of this object.

      • pg_partman_bgw.interval: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • pg_partman_bgw.role: {
            description: string;
            example: string;
            maxLength: number;
            pattern: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: string

          An example value for this parameter, using the required pattern.

        • maxLength: number

          The maximum character length for this parameter.

        • pattern: string

          The pattern to follow when defining 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.

      • pg_stat_monitor.pgsm_enable_query_plan: {
            description: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: string

          An example boolean value 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.

      • pg_stat_monitor.pgsm_max_buckets: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • pg_stat_statements.track: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: number[];
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: number[]

          The format of this object.

      • temp_file_limit: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • timezone: {
            description: string;
            example: string;
            maxLength: number;
            pattern: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: string

          An example value for this parameter, using the required pattern.

        • maxLength: number

          The maximum character length for this parameter.

        • pattern: string

          The pattern to follow when defining 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.

      • track_activity_query_size: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

      • track_commit_timestamp: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: string

          The format of this object.

      • track_functions: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: string

          The format of this object.

      • track_io_timing: {
            description: string;
            enum: string;
            example: string;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • enum: string

          Specific values available for use as this parameter.

        • example: string

          One of the enum values available for use.

        • requires_restart: boolean

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

        • type: string

          The format of this object.

      • wal_sender_timeout: {
            description: string;
            example: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value 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.

      • wal_writer_delay: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

    • pg_stat_monitor_enable: { description: string; requires_restart: boolean; type: string }

      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: {
          max_failover_replication_time_lag: {
              description: string;
              example: number;
              maximum: number;
              minimum: number;
              requires_restart: boolean;
              type: string;
          };
      }

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

      • max_failover_replication_time_lag: {
            description: string;
            example: number;
            maximum: number;
            minimum: number;
            requires_restart: boolean;
            type: string;
        }

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

        • description: string

          The description for this parameter.

        • example: number

          An example value for this parameter.

        • maximum: number

          The maximum value allowed for this parameter.

        • minimum: number

          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.

    • shared_buffers_percentage: {
          description: string;
          example: number;
          maximum: number;
          minimum: number;
          requires_restart: boolean;
          type: string;
      }

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

      • description: string

        The description for this parameter.

      • example: number

        An example value for this parameter.

      • maximum: number

        The maximum value allowed for this parameter.

      • minimum: number

        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: {
          description: string;
          example: number;
          maximum: number;
          minimum: number;
          requires_restart: boolean;
          type: string;
      }

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

      • description: string

        The description for this parameter.

      • example: number

        An example value for this parameter.

      • maximum: number

        The maximum value allowed for this parameter.

      • minimum: number

        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.

    Settings

    Member Visibility

    On This Page

    Properties