Shulou(Shulou.com)06/01 Report--

# base

Data_directory ='/ dbdata/data'

Hba_file ='/ dbdata/data/pg_hba.conf'

Ident_file ='/ dbdata/data/pg_ident.conf'

External_pid_file ='/ var/run/postgres/9.5-main.pid'

Listen_addresses ='*'

Port = 5432

Max_connections = 1000

Max_prepared_transactions = 1000

Superuser_reserved_connections = 20

Unix_socket_directories ='/ var/run/postgres'

Unix_socket_permissions = 0700

# ssl

Ssl = false

Ssl_cert_file ='/ service/ssl/pgsql/server.crt'

Ssl_key_file ='/ service/ssl/pgsql/server.key'

Tcp_keepalives_idle = 30

Tcp_keepalives_interval = 10

Tcp_keepalives_count = 10

Shared_buffers = 6GB

Huge_pages = try

Maintenance_work_mem = 16MB

Autovacuum_work_mem = 16MB

Bgwriter_delay = 10ms

Bgwriter_lru_maxpages = 1000

Max_worker_processes = 20

Wal_level = hot_standby

Synchronous_commit = local

Archive_mode = on

Archive_command ='cp-I% p / dbdata/pgsql/archive/%f

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.