Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- data_directory = '/var/lib/postgresql/8.4/main' # USE data in another directory
- # (change requires restart)
- hba_file = '/etc/postgresql/8.4/main/pg_hba.conf' # host-based authentication file
- # (change requires restart)
- ident_file = '/etc/postgresql/8.4/main/pg_ident.conf' # ident configuration file
- # (change requires restart)
- external_pid_file = '/var/run/postgresql/8.4-main.pid' # WRITE an extra PID file
- # (change requires restart)
- port = 5432 # (change requires restart)
- max_connections = 384 # Higher VALUE crashes (change requires restart)
- unix_socket_directory = '/var/run/postgresql'
- ssl = TRUE
- shared_buffers = 24MB
- log_line_prefix = '%t '
- track_counts = ON
- autovacuum = ON
- autovacuum_naptime = 60min # TIME between autovacuum runs
- autovacuum_vacuum_threshold = 5000 # min number OF ROW updates before
- # vacuum
- autovacuum_analyze_threshold = 5000 # min number OF ROW updates before
- # analyze
- lc_messages = 'en_GB' # locale FOR system ERROR MESSAGE
- # strings
- lc_monetary = 'en_GB' # locale FOR monetary formatting
- lc_numeric = 'en_GB' # locale FOR number formatting
- lc_time = 'en_GB' # locale FOR TIME formatting
- default_text_search_config = 'pg_catalog.english'
Add Comment
Please, Sign In to add comment