Changeset 5818 for trunk/INSTALL/debian/squeeze/etc/postgresql/8.4/main/postgresql.conf

Timestamp:

03/26/12 16:01:38 (12 years ago)

Author:

wmerlotto

Message:

Ticket #2557 - Finalizada as correções para Debian Squeeze e Centos 6

Location:

trunk/INSTALL/debian/squeeze/etc/postgresql

Files:

• . (copied) (copied from trunk/INSTALL/debian/squeeze/var/lib/postgresql)
• 8.4/main/postgresql.conf (modified) (8 diffs)

trunk/INSTALL/debian/squeeze/etc/postgresql/8.4/main/postgresql.conf

@@ -39 +39 @@
 # option or PGDATA environment variable, represented here as ConfigDir.
 
-#data_directory = 'ConfigDir'           # use data in another directory
-                                        # (change requires restart)
-#hba_file = 'ConfigDir/pg_hba.conf'     # host-based authentication file
-                                        # (change requires restart)
-#ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
+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)
 
 # If external_pid_file is not explicitly set, no extra PID file is written.
-#external_pid_file = '(none)'           # write an extra PID file
+external_pid_file = '/var/run/postgresql/8.4-main.pid'          # write an extra PID file
                                         # (change requires restart)
 
@@ -76 +76 @@
 
 #authentication_timeout = 1min          # 1s-600s
-#ssl = off                              # (change requires restart)
+#ssl = true                             # (change requires restart)
 #ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'      # allowed SSL ciphers
                                         # (change requires restart)
@@ -105 +105 @@
 # - Memory -
 
-shared_buffers = 32MB                   # min 128kB
+shared_buffers = 24MB                   # min 128kB
                                         # (change requires restart)
 #temp_buffers = 8MB                     # min 800kB
@@ -238 +238 @@
 
 # This is used when logging to stderr:
-logging_collector = on                  # Enable capturing of stderr and csvlog
+logging_collector = on          # Enable capturing of stderr and csvlog
                                         # into log files. Required to be on for
                                         # csvlogs.
@@ -246 +246 @@
 log_directory = 'pg_log'                # directory where log files are written,
                                         # can be absolute or relative to PGDATA
-log_filename = 'postgresql-%a.log'      # log file name pattern,
+log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
                                         # can include strftime() escapes
 log_truncate_on_rotation = on           # If on, an existing log file of the
@@ -258 +258 @@
 log_rotation_age = 1d                   # Automatic rotation of logfiles will
                                         # happen after that time.  0 disables.
-log_rotation_size = 0                   # Automatic rotation of logfiles will 
+log_rotation_size = 10MB                # Automatic rotation of logfiles will 
                                         # happen after that much log output.
                                         # 0 disables.
@@ -332 +332 @@
 #log_duration = off
 #log_hostname = off
-#log_line_prefix = ''                   # special values:
+log_line_prefix = '%t '                 # special values:
                                         #   %u = user name
                                         #   %d = database name
@@ -484 +484 @@
 #backslash_quote = safe_encoding        # on, off, or safe_encoding
 #default_with_oids = off
-# Necessario para o Expresso
-standard_conforming_strings = off
-bytea_output = 'escape'
-# Necessario para o Expresso
 #escape_string_warning = on
 #regex_flavor = advanced                # advanced, extended, or basic