--Configs requiring PostgreSQL restartselect name, setting, context from pg_settings where context = ' postmaster ';
postgres=# select name, setting, context
postgres-# from pg_settings where context = ' postmaster ';
name | setting | Context
-------------------------------------+-----------------------------------------------+------------
Allow_system_table_mods | Off | Postmaster
Archive_mode | Off | Postmaster
Autovacuum_freeze_max_age | 200000000 | Postmaster
Autovacuum_max_workers | 3 | Postmaster
Autovacuum_multixact_freeze_max_age | 400000000 | Postmaster
Bonjour | Off | Postmaster
Bonjour_name | | Postmaster
Cluster_Name | | Postmaster
Config_file | /usr/local/pgtest/bin/. /data/postgresql.conf | Postmaster
Data_directory | /usr/local/pgtest/bin/. /data | Postmaster
Dynamic_shared_memory_type | POSIX | Postmaster
event_source | PostgreSQL | Postmaster
External_pid_file | | Postmaster
Hba_file | /usr/local/pgtest/bin/. /data/pg_hba.conf | Postmaster
Hot_standby | Off | Postmaster
Huge_pages | Try | Postmaster
Ident_file | /usr/local/pgtest/bin/. /data/pg_ident.conf | Postmaster
listen_addresses | * | Postmaster
Logging_collector | Off | Postmaster
max_connections | 100 | Postmaster
max_files_per_process | 1000 | Postmaster
max_locks_per_transaction | 64 | Postmaster
max_pred_locks_per_transaction | 64 | Postmaster
max_prepared_transactions | 0 | Postmaster
Max_replication_slots | 0 | Postmaster
Max_wal_senders | 0 | Postmaster
max_worker_processes | 8 | Postmaster
Port | 5432 | Postmaster
Shared_buffers | 16384 | Postmaster
shared_preload_libraries | | Postmaster
SSL | Off | Postmaster
Ssl_ca_file | | Postmaster
Ssl_cert_file | SERVER.CRT | Postmaster
Ssl_ciphers | none | Postmaster
Ssl_crl_file | | Postmaster
Ssl_ecdh_curve | none | Postmaster
Ssl_key_file | Server.key | Postmaster
Ssl_prefer_server_ciphers | On | Postmaster
superuser_reserved_connections | 3 | Postmaster
Track_activity_query_size | 1024 | Postmaster
Track_commit_timestamp | Off | Postmaster
unix_socket_directories | /tmp | Postmaster
Unix_socket_group | | Postmaster
unix_socket_permissions | 0777 | Postmaster
Wal_buffers | 512 | Postmaster
Wal_level | Minimal | Postmaster
wal_log_hints | Off | Postmaster
--Configs requiring PostgreSQL reloadselect name, setting, context from pg_settings where context = ' sighup ';
postgres=# select name, setting, context
postgres-# from pg_settings where context = ' sighup ';
name | setting | Context
---------------------------------+--------------------------------+---------
Archive_command | (disabled) | Sighup
Archive_timeout | 0 | Sighup
Authentication_timeout | 60 | Sighup
autovacuum | On | Sighup
Autovacuum_analyze_scale_factor | 0.1 | Sighup
Autovacuum_analyze_threshold | 50 | Sighup
Autovacuum_naptime | 60 | Sighup
Autovacuum_vacuum_cost_delay | 20 | Sighup
Autovacuum_vacuum_cost_limit | -1 | Sighup
Autovacuum_vacuum_scale_factor | 0.2 | Sighup
Autovacuum_vacuum_threshold | 50 | Sighup
Autovacuum_work_mem | -1 | Sighup
Bgwriter_delay | 200 | Sighup
Bgwriter_lru_maxpages | 100 | Sighup
Bgwriter_lru_multiplier | 2 | Sighup
Checkpoint_completion_target | 0.5 | Sighup
Checkpoint_timeout | 300 | Sighup
checkpoint_warning | 30 | Sighup
Db_user_namespace | Off | Sighup
Fsync | On | Sighup
Full_page_writes | On | Sighup
Hot_standby_feedback | Off | Sighup
Krb_caseins_users | Off | Sighup
Krb_server_keyfile | | Sighup
log_autovacuum_min_duration | -1 | Sighup
log_checkpoints | Off | Sighup
log_destination | stderr | Sighup
Log_directory | Pg_log | Sighup
Log_file_mode | 0600 | Sighup
Log_filename | Postgresql-%y-%m-%d_%h%m%s.log | Sighup
Log_hostname | Off | Sighup
Log_line_prefix | | Sighup
Log_rotation_age | 1440 | Sighup
Log_rotation_size | 10240 | Sighup
Log_timezone | us/pacific | Sighup
log_truncate_on_rotation | Off | Sighup
Max_standby_archive_delay | 30000 | Sighup
Max_standby_streaming_delay | 30000 | Sighup
Max_wal_size | 64 | Sighup
Min_wal_size | 5 | Sighup
Pre_auth_delay | 0 | Sighup
Restart_after_crash | On | Sighup
Stats_temp_directory | pg_stat_tmp | Sighup
Synchronous_standby_names | | Sighup
syslog_facility | Local0 | Sighup
syslog_ident | Postgres | Sighup
Trace_recovery_messages | Log | Sighup
Vacuum_defer_cleanup_age | 0 | Sighup
wal_keep_segments | 0 | Sighup
Wal_receiver_status_interval | 10 | Sighup
Wal_receiver_timeout | 60000 | Sighup
Wal_retrieve_retry_interval | 5000 | Sighup
Wal_sender_timeout | 60000 | Sighup
Wal_sync_method | Fdatasync | Sighup
Wal_writer_delay | 200 | Sighup
Configs for PostgreSQL restart and PostgreSQL reload