Skip to content

Instantly share code, notes, and snippets.

@onmoving

onmoving/postgresql logging query

Created July 16, 2012 07:20
Show Gist options
  • Save onmoving/3121329 to your computer and use it in GitHub Desktop.
Save onmoving/3121329 to your computer and use it in GitHub Desktop.
Download ZIP
postgresql: logging query 쿼리 로깅
Raw
postgresql logging query
enable logging using pgadmin tool
menu: tools --> server configuration --> postgresql.conf
- enable below 3 item
1. log_directory
2. log_filename
3. log_statement = mod
after that, reload configuration
log location :
- windows: C:\Program Files\PostgreSQL\9.1\data\pg_log
- also verifiable using pgadmin tool: tools --> server status
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment