Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 7, 2012
Logs can tell you a lot about what's going on in your database: which user logged in when, what queries they ran and how long they took, when the database restarted. We'll discuss various logging GUCs PostgreSQL offers, and talk about what to do with your logs once you have them (hint: you don't have to stay up at night reading them!) Abstract
Logging is an important part of your database monitoring suite, providing historical information for troubleshooting and forensic purposes: which user logged in when, what queries they ran and how long they took, when the database restarted. PostgreSQL offers different file format, message format, and message content options for logging. These options can be kind of overwhelming for the first-time user. We'll walk through the various configuration parameters to help you figure out how to get what you need in a format that's useful to you. Then we'll discuss some solutions (pgFouine and friends) for extracting information from your logs.
This is a slightly revamped version of the talk I gave at PgCon 2011. This talk is best for people who haven't played around with logging yet, but know where their postgresql.conf is.