Re: [PORTS] Logging (was Re: PostgreSQL 7.0-2 RPMset released.)

Palle Girgensohn <girgen@partitur.se>

From: Palle Girgensohn <girgen@partitur.se>
To: "Roderick A. Anderson" <raanders@altoplanos.net>
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-ports@postgresql.org, "PostgreSQL::General List" <pgsql-general@postgresql.org>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2000-05-22T23:57:05Z
Lists: pgsql-hackers

Attachments

Hi,

Glad to hear you like the idea.

May I also suggest my favourite patch for rotatelogs
(enclosed). It creates a "hard link" to the latest log using
the base logfilename. i.e:

-rw-r--r-- 1 root wheel  8901 May 19 04:45
localhost-access.log.0958694400
-rw-r--r-- 2 root wheel 18430 May 21 17:05
localhost-access.log.0958867200
-rw-r--r-- 2 root wheel 18430 May 21 17:05 localhost-access.log

This is very nice when developing and debugging, since you
don't need to check for the latest log's filename, but can just
issue "tail -f localhost-access.log". FreeBSD'er can enjoy tail
-F, which will follow the log even after a rotation...

The function should probably be optional?

Cheers,
Palle

"Roderick A. Anderson" wrote:
> 
> On Mon, 22 May 2000, Peter Eisentraut wrote:
> 
> > Now there's a good idea. Why don't we abduct that program and teach pg_ctl
> > about it. (After all, we abducted that one as well. :)
> 
> Imitation is the sincerest form of flattery.  Not to mention this is the
> bazar.
> 
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814

-- 
Palle