Customisable PostgreSQL properties

The following PostgreSQL® database properties can be set by the user via the UpCloud API.

  • admin_password
  • admin_username
  • automatic_utility_network_ip_filter
  • autovacuum_analyze_scale_factor
  • autovacuum_analyze_threshold
  • autovacuum_freeze_max_age
  • autovacuum_max_workers
  • autovacuum_naptime
  • autovacuum_vacuum_cost_delay
  • autovacuum_vacuum_cost_limit
  • autovacuum_vacuum_scale_factor
  • autovacuum_vacuum_threshold
  • backup_hour
  • backup_interval_hours
  • backup_minute
  • backup_retention_days
  • bgwriter_delay
  • bgwriter_flush_after
  • bgwriter_lru_maxpages
  • bgwriter_lru_multiplier
  • deadlock_timeout
  • default_toast_compression
  • enable_ha_replica_dns
  • idle_in_transaction_session_timeout
  • io_combine_limit
  • io_max_combine_limit
  • io_max_concurrency
  • io_method
  • io_workers
  • ip_filter
  • jit
  • log_autovacuum_min_duration
  • log_error_verbosity
  • log_line_prefix
  • log_min_duration_statement
  • log_temp_files
  • max_connections
  • max_files_per_process
  • max_locks_per_transaction
  • max_logical_replication_workers
  • max_parallel_workers
  • max_parallel_workers_per_gather
  • max_pred_locks_per_transaction
  • max_prepared_transactions
  • max_replication_slots
  • max_slot_wal_keep_size
  • max_stack_depth
  • max_standby_archive_delay
  • max_standby_streaming_delay
  • max_sync_workers_per_subscription
  • max_wal_senders
  • max_worker_processes
  • migration
  • node_count
  • password_encryption
  • pg_partman_bgw_interval
  • pg_partman_bgw_role
  • pg_stat_monitor_enable
  • pg_stat_monitor_pgsm_enable_query_plan
  • pg_stat_monitor_pgsm_max_buckets
  • pg_stat_plans_enable
  • pg_stat_plans_track
  • pg_stat_statements_track
  • pgaudit
  • pgbouncer
  • pglookout
  • public_access
  • public_access_prometheus
  • service_log
  • shared_buffers_percentage
  • synchronous_commit
  • synchronous_replication
  • temp_file_limit
  • timescaledb
  • timezone
  • track_activity_query_size
  • track_commit_timestamp
  • track_functions
  • track_io_timing
  • variant
  • version
  • wal_sender_timeout
  • wal_writer_delay
  • work_mem

PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada, and used with their permission.

Can't find what you're looking for?

For more help you can contact our awesome 24/7 support team

Contact Support