Re: Feature request concerning postmaster log file. - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Feature request concerning postmaster log file.
Date
Msg-id Pine.GSO.4.64.0711090951240.1537@westnet.com
Whole thread Raw
In response to Re: Feature request concerning postmaster log file.  (David BOURIAUD <david.bouriaud@ac-rouen.fr>)
List 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@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Feature request concerning postmaster log file.
Next
From: Tom Lane
Date:
Subject: Re: New tzdata available