listen_addresses = '*'          # what IP address(es) to listen on;
                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
                                        # (change requires restart)
max_connections = 800                   # (change requires restart)
                                        # (change requires restart)
                                        # (change requires restart)
                                        # (change requires restart)


                                        # (change requires restart)



                                        # 0 selects the system default
                                        # 0 selects the system default
                                        # 0 selects the system default




shared_buffers = 32MB                   # min 128kB
                                        # (change requires restart)
                                        # (change requires restart)
work_mem = 16MB                         # min 64kB
maintenance_work_mem = 1024MB           # min 1MB


                                        # (change requires restart)










wal_level = hot_standby                 # minimal, archive, or hot_standby
                                        # (change requires restart)
fsync = on                              # turns forced synchronization on or off
synchronous_commit = on                 # immediate fsync at commit
                                        # supported by the operating system:
                                        #   open_datasync
                                        #   fdatasync (default on Linux)
                                        #   fsync
                                        #   fsync_writethrough
                                        #   open_sync
wal_buffers = 16MB                      # min 32kB
                                        # (change requires restart)



checkpoint_segments = 96                # in logfile segments, min 1, 16MB each


archive_mode = on               # allows archiving to be done
                                # (change requires restart)
archive_command = '/usr/local/postgres/WALLogs/copy_to_archive.sh %p %f'                # command to use to archive a logfile segment
                                # number of seconds; 0 disables


                                # (change requires restart)


                                        # (change requires restart)
max_standby_archive_delay = -1        # max delay before canceling queries
                                        # when reading WAL from archive;
                                        # -1 allows indefinite delay
                                        # when reading streaming WAL;
                                        # -1 allows indefinite delay










default_statistics_target = 100 # range 1-10000
                                        # JOIN clauses




log_destination = 'syslog'              # Valid values are combinations of
                                        # stderr, csvlog, syslog, and eventlog,
                                        # depending on platform.  csvlog
                                        # requires logging_collector to be on.

logging_collector = on                  # Enable capturing of stderr and csvlog
                                        # into log files. Required to be on for
                                        # csvlogs.
                                        # (change requires restart)

log_directory = '/trlogs/pg_log'                # directory where log files are written,
                                        # can be absolute or relative to PGDATA
log_filename = 'postgresql-%a.log'      # log file name pattern,
                                        # can include strftime() escapes
log_truncate_on_rotation = on           # If on, an existing log file of the
                                        # same name as the new log file will be
                                        # truncated rather than appended to.
                                        # But such truncation only occurs on
                                        # time-driven rotation, not on restarts
                                        # or size-driven rotation.  Default is
                                        # off, meaning append to existing files
                                        # in all cases.
log_rotation_age = 1d                   # Automatic rotation of logfiles will
                                        # happen after that time.  0 disables.
log_rotation_size = 0                   # Automatic rotation of logfiles will 
                                        # happen after that much log output.
                                        # 0 disables.

syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

                                        # DO NOT USE without syslog or
                                        # logging_collector
                                        # (change requires restart)



                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug2
                                        #   debug1
                                        #   log
                                        #   notice
                                        #   warning
                                        #   error

log_min_messages = notice               # values in order of decreasing detail:
                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug2
                                        #   debug1
                                        #   info
                                        #   notice
                                        #   warning
                                        #   error
                                        #   log
                                        #   fatal
                                        #   panic

                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug2
                                        #   debug1
                                        #   info
                                        #   notice
                                        #   warning
                                        #   error
                                        #   log
                                        #   fatal
                                        #   panic (effectively off)

log_min_duration_statement = 0          # -1 is disabled, 0 logs all statements
                                        # and their durations, > 0 logs only
                                        # statements running at least this number
                                        # of milliseconds



log_connections = on
log_disconnections = on
log_duration = on
log_line_prefix = '%u '                   # special values:
                                        #   %a = application name
                                        #   %u = user name
                                        #   %d = database name
                                        #   %r = remote host and port
                                        #   %h = remote host
                                        #   %p = process ID
                                        #   %t = timestamp without milliseconds
                                        #   %m = timestamp with milliseconds
                                        #   %i = command tag
                                        #   %e = SQL state
                                        #   %c = session ID
                                        #   %l = session line number
                                        #   %s = session start timestamp
                                        #   %v = virtual transaction ID
                                        #   %x = transaction ID (0 if none)
                                        #   %q = stop here in non-session
                                        #        processes
                                        #   %% = '%'
                                        # e.g. '<%u%%%d> '
log_statement = 'all'                   # none, ddl, mod, all
                                        # than the specified size in kilobytes;
                                        # -1 disables, 0 logs all temp files
                                        # setting










                                        # requires track_counts to also be on.
log_autovacuum_min_duration = 0       # -1 disables, 0 logs all actions and
                                        # their durations, > 0 logs only
                                        # actions running at least this number
                                        # of milliseconds.
                                        # (change requires restart)
                                        # vacuum
                                        # analyze
                                        # (change requires restart)
                                        # autovacuum, in milliseconds;
                                        # -1 means use vacuum_cost_delay
                                        # autovacuum, -1 means use
                                        # vacuum_cost_limit




search_path = '"$user",public,reporting'        # schema names
                                        # only default tablespace


datestyle = 'iso, mdy'
timezone = 'UTC'                        # actually, defaults to TZ environment
                                        # setting
                                        # abbreviations.  Currently, there are
                                        #   Default
                                        #   Australia
                                        #   India
                                        # You can create your own file in
                                        # share/timezonesets/.
                                        # encoding

lc_messages = 'en_US.UTF-8'                     # locale for system error message
                                        # strings
lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
lc_time = 'en_US.UTF-8'                         # locale for time formatting

default_text_search_config = 'pg_catalog.english'