[ADMIN] logging full queries separately

2013-02-22 Thread Charles Sprickman
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 this is that the logs are so noisy, it's hard to track down errors and stats

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

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-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-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