-
-
Save mnowotka/9062c7434c8f350e8d2a6756889ed2fd to your computer and use it in GitHub Desktop.
current Ubuntu 9.4 postgres conf (non-default settings only)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
data_directory = '/var/lib/postgresql/9.4/main' # use data in another directory | |
hba_file = '/etc/postgresql/9.4/main/pg_hba.conf' # host-based authentication file | |
ident_file = '/etc/postgresql/9.4/main/pg_ident.conf' # ident configuration file | |
external_pid_file = '/var/run/postgresql/9.4-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_directories = '/var/run/postgresql' # comma-separated list of directories | |
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) | |
shared_buffers = 128MB # min 128kB | |
dynamic_shared_memory_type = posix # the default is the first option | |
log_line_prefix = '%t [%p-%l] %q%u@%d ' # special values: | |
log_timezone = 'UTC' | |
stats_temp_directory = '/var/run/postgresql/9.4-main.pg_stat_tmp' | |
datestyle = 'iso, mdy' | |
timezone = 'UTC' | |
lc_messages = 'en_US.utf8' # locale for system error message | |
lc_monetary = 'en_US.utf8' # locale for monetary formatting | |
lc_numeric = 'en_US.utf8' # locale for number formatting | |
lc_time = 'en_US.utf8' # locale for time formatting | |
default_text_search_config = 'pg_catalog.english' | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment