Конфиг postgresql 9.2.4 сервер 1С Linux

Челябинская область

Автор:Dmitriy Altuhov

Конфиг postgresql 9.2.4 сервер 1С Linux

root@server1c:/etc/postgresql/9.2/main# cat postgresql.conf | egrep -v «^s*(#|$)»

data_directory = ‘/var/lib/postgresql/9.2/main’ # use data in another directory
hba_file = ‘/etc/postgresql/9.2/main/pg_hba.conf’ # host-based authentication file
ident_file = ‘/etc/postgresql/9.2/main/pg_ident.conf’ # ident configuration file
external_pid_file = ‘/var/run/postgresql/9.2-main.pid’ # write an extra PID file
listen_addresses = ‘*’ # what IP address(es) to listen on;
port = 5432 # (change requires restart)
unix_socket_directory = ‘/var/run/postgresql’ # (change requires restart)
ssl = true # (change requires restart)
ssl_cert_file = ‘/etc/ssl/certs/ssl-cert-snakeoil.pem’ # (change requires restart)
ssl_key_file = ‘/etc/ssl/private/ssl-cert-snakeoil.key’ # (change requires restart)
effective_io_concurrency = 2 # 1-1000; 0 disables prefetching
synchronous_commit = off # synchronization level;
wal_writer_delay = 2000ms # 1-10000 milliseconds
seq_page_cost = 3.0 # measured on an arbitrary scale
random_page_cost = 4.0 # same scale as above
log_line_prefix = ‘%t ‘ # special values:
log_timezone = ‘localtime’
autovacuum = on # Enable autovacuum subprocess? ‘on’
log_autovacuum_min_duration = 200 # -1 disables, 0 logs all actions and
autovacuum_naptime = 960 # time between autovacuum runs
autovacuum_vacuum_threshold = 1800 # min number of row updates before
autovacuum_analyze_threshold = 900 # min number of row updates before
datestyle = ‘iso, dmy’
timezone = ‘localtime’
lc_messages = ‘en_US’ # locale for system error message
lc_monetary = ‘ru_RU.UTF-8’ # locale for monetary formatting
lc_numeric = ‘ru_RU.UTF-8’ # locale for number formatting
lc_time = ‘ru_RU.UTF-8’ # locale for time formatting
default_text_search_config = ‘pg_catalog.russian’
deadlock_timeout = 2s
max_locks_per_transaction = 150 # min 10
backslash_quote = safe_encoding # on, off, or safe_encoding
escape_string_warning = off
standard_conforming_strings = off
online_analyze.threshold = 50
online_analyze.scale_factor = 0.1
online_analyze.enable = off
online_analyze.verbose = off
online_analyze.min_interval = 10000
online_analyze.table_type = ‘temporary’
plantuner.fix_empty_table = true
default_statistics_target = 50 # pgtune wizard 2013-12-15
maintenance_work_mem = 960MB # pgtune wizard 2013-12-15
constraint_exclusion = on # pgtune wizard 2013-12-15
checkpoint_completion_target = 0.9 # pgtune wizard 2013-12-15
effective_cache_size = 4GB # pgtune wizard 2013-12-15
work_mem = 96MB # pgtune wizard 2013-12-15
wal_buffers = 16MB # pgtune wizard 2013-12-15
checkpoint_segments = 32 # pgtune wizard 2013-12-15
shared_buffers = 7GB # pgtune wizard 2013-12-15
max_connections = 80 # pgtune wizard 2013-12-15

Comments Are Closed!!!