Skip to content

Instantly share code, notes, and snippets.

@vinnix
Created May 28, 2012 16:56
Show Gist options
  • Save vinnix/2820079 to your computer and use it in GitHub Desktop.
Save vinnix/2820079 to your computer and use it in GitHub Desktop.
postgresql conf. primeiras mudanças
240c240
< logging_collector = off # Enable capturing of stderr and csvlog
---
> logging_collector = on # Enable capturing of stderr and csvlog
248c248
< log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
---
> log_filename = 'postgresql-%a.log' # log file name pattern,
268c268
< silent_mode = on # Run server silently.
---
> silent_mode = off # Run server silently.
317c317
< log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
---
> log_min_duration_statement = 60000 # -1 is disabled, 0 logs all statements
334c334,335
< log_line_prefix = '%x - %t %r %d %u ' # special values:
---
> #log_line_prefix = '%x - %t %r %d %u ' # special values:
> log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d ' # special values:
352c353
< log_lock_waits = off # log lock waits >= deadlock_timeout
---
> log_lock_waits = on # log lock waits >= deadlock_timeout
367,368c368,369
< track_activities = off
< track_counts = off
---
> track_activities = on
> track_counts = on
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment