49 | | lc_messages = 'en_US.UTF-8' # locale for system error message |
50 | | lc_monetary = 'en_US.UTF-8' # locale for monetary formatting |
51 | | lc_numeric = 'en_US.UTF-8' # locale for number formatting |
52 | | lc_time = 'en_US.UTF-8' # locale for time formatting |
53 | | listen_addresses = '*' |
54 | | log_directory = 'pg_log' |
55 | | log_filename = 'postgresql-%a.log' # log file name pattern, |
56 | | log_rotation_age = 1d # Automatic rotation of logfiles will |
57 | | log_rotation_size = 0 # Automatic rotation of logfiles will |
58 | | log_statement = 'ddl' # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/ |
59 | | log_truncate_on_rotation = on # If on, an existing log file of the |
60 | | max_connections = 100 # (change requires restart) |
61 | | shared_buffers = 32MB # min 128kB |
62 | | logging_collector = on # Enable capturing of stderr and csvlog |
| 49 | # defaults grep '^[a-z]' postgresql.conf.orig > postgresql.conf |
| 52 | lc_messages = 'en_US.UTF-8' # locale for system error message |
| 53 | lc_monetary = 'en_US.UTF-8' # locale for monetary formatting |
| 54 | lc_numeric = 'en_US.UTF-8' # locale for number formatting |
| 55 | lc_time = 'en_US.UTF-8' # locale for time formatting |
| 56 | log_directory = 'pg_log' # directory where log files are written, |
| 57 | log_filename = 'postgresql-%a.log' # log file name pattern, |
| 58 | logging_collector = on # Enable capturing of stderr and csvlog |
| 59 | log_rotation_age = 1d # Automatic rotation of logfiles will |
| 60 | log_rotation_size = 0 # Automatic rotation of logfiles will |
| 61 | log_truncate_on_rotation = on # If on, an existing log file of the |
| 62 | max_connections = 100 # (change requires restart) |
| 63 | shared_buffers = 32MB # min 128kB |
| 64 | # custom settings |
| 65 | listen_addresses = '*' |
| 66 | autovacuum = on |
| 67 | checkpoint_completion_target = 0.9 |
| 68 | checkpoint_segments= 32 |
| 69 | effective_cache_size = 1GB #1/2 your RAM |
| 70 | listen_addresses = '*' |
| 71 | log_statement = 'ddl' # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/ |
| 72 | maintenance_work_mem= 256MB |
| 73 | random_page_cost = 3.0 |
| 74 | wal_buffers = 16MB |