Re: [ADMIN] logging full queries separately

2013-02-27 Thread John Rouillard
On Wed, Feb 27, 2013 at 05:52:49AM -0500, Charles Sprickman wrote: > On Feb 25, 2013, at 9:59 AM, John Rouillard wrote: > > On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote: > >> [...] > >> The one huge downside to this is that the logs are so noisy, it's > >> hard to track down er

Re: [ADMIN] logging full queries separately

2013-02-27 Thread Charles Sprickman
On Feb 25, 2013, at 9:59 AM, John Rouillard wrote: > On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote: >> [...] >> The one huge downside to this is that the logs are so noisy, it's >> hard to track down errors and stats real-time since the query logging >> is so noisy. >> [...] >>

Re: [ADMIN] logging full queries separately

2013-02-25 Thread John Rouillard
On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote: >[...] >The one huge downside to this is that the logs are so noisy, it's >hard to track down errors and stats real-time since the query logging >is so noisy. > [...] >Right now I'm considering just switching to syslog-ng or rsyslog

Re: [ADMIN] logging full queries separately

2013-02-23 Thread k...@rice.edu
On Sat, Feb 23, 2013 at 12:55:07AM -0500, Charles Sprickman wrote: > Howdy, > > I've been finding that keeping full query logs is quite helpful; I started > doing this to be able to run pgbadger each day to get a nice overview of > what's going on with the db servers. The one huge downside to t