Configs for PostgreSQL restart and PostgreSQL reload

Source: Internet
Author: User
Tags postgresql

--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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.