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

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

Автор:Dmitriy Altuhov

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

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)
max_connections = 100                   # (change requires restart)
unix_socket_directory = ‘/var/run/postgresql’           # (change requires restart)
shared_buffers = 512MB                  # min 128kB
temp_buffers = 16MB                     # min 800kB
work_mem = 64MB                         # min 64kB
maintenance_work_mem = 256MB            # min 1MB
effective_io_concurrency = 2            # 1-1000; 0 disables prefetching
synchronous_commit = off                # synchronization level;
effective_cache_size = 2048MB
log_line_prefix = ‘%t ‘                 # special values:
log_timezone = ‘localtime’
autovacuum = on                 # Enable autovacuum subprocess?  ‘on’
autovacuum_naptime = 10min              # time between autovacuum runs
autovacuum_vacuum_threshold = 5000      # min number of row updates before
autovacuum_analyze_threshold = 5000     # min number of row updates before
datestyle = ‘iso, dmy’
timezone = ‘localtime’
lc_messages = ‘en_US.UTF-8’                     # 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 = 250 # min 10
escape_string_warning = off
standard_conforming_strings = off
online_analyze.threshold = 50
online_analyze.scale_factor = 0.1
online_analyze.enable = on
online_analyze.verbose = off
online_analyze.min_interval = 10000
online_analyze.table_type = ‘temporary’
plantuner.fix_empty_table = true

Comments Are Closed!!!