Re: Feature request concerning postmaster log file.

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: David BOURIAUD <david(dot)bouriaud(at)ac-rouen(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature request concerning postmaster log file.
Date: 2007-11-09 14:56:08
Message-ID: Pine.GSO.4.64.0711090951240.1537@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 9 Nov 2007, David BOURIAUD wrote:

> using a text utility like grep is not suitable. I think of this when you
> get a many hundreds of MB logfile at least, or when you need to track
> commands made by one peculiar user in real-time.

If your problem is that individual log files are too big to search
usefully, one option is to set log_rotation_size so that doesn't happen.
As for real-rime, I do this all the time with some variant on

tail -f <log> | grep <user>

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-09 16:09:19 Re: New tzdata available
Previous Message Zdenek Kotala 2007-11-09 14:55:15 Re: Feature request concerning postmaster log file.