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

From: Palle Girgensohn <girgen(at)partitur(dot)se>
To: "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-ports(at)postgresql(dot)org, "PostgreSQL::General List" <pgsql-general(at)postgresql(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PORTS] Logging (was Re: PostgreSQL 7.0-2 RPMset released.)
Date: 2000-05-22 23:57:05
Message-ID: 3929C951.DBA3B529@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-general pgsql-hackers pgsql-ports

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(at)altoplanos(dot)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

Attachment Content-Type Size
rotatelogs.diff text/plain 423 bytes

In response to

Browse pgsql-announce by date

  From Date Subject
Next Message Gustavo Henrique 2000-05-24 22:53:35 Re: PostgreSQL 7.0 a success
Previous Message Roderick A. Anderson 2000-05-22 23:13:31 Re: [PORTS] Logging (was Re: PostgreSQL 7.0-2 RPMset released.)

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2000-05-23 01:41:49 Re: OO Patch
Previous Message Tom Lane 2000-05-22 23:46:27 Re: Database is unstable after upgrade

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-22 23:58:45 Re: [PORTS] Re: port v7.0 to SGI-IRIX-6.5.7/64
Previous Message Bruce Momjian 2000-05-22 23:56:32 Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 2000-05-22 23:58:45 Re: [PORTS] Re: port v7.0 to SGI-IRIX-6.5.7/64
Previous Message Bruce Momjian 2000-05-22 23:56:32 Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64