Re: Postgresql log analyzer - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Postgresql log analyzer
Date
Msg-id Pine.LNX.4.30.0108211747130.856-100000@peter.localdomain
Whole thread Raw
In response to Postgresql log analyzer  (Gilles DAROLD <gilles@darold.net>)
List pgsql-hackers
Gilles DAROLD writes:

> Is it possible to have it into the last line as we have the information of
> the database
> shutdown timestamp in the first line ?

We not just turn time stamping on?

> Also, an other question is why using timestamp into the other log instead of
> the value
> of  time  in  seconds  since  the  Epoch like the time() function do ?

Because humans generally reckon time the former way.

> I don't know if it is speedest or not but if timestamp is system local
> dependant
> I think it should be very difficult to me to have a portable log analyzer...

In the current system, the timestamp is not locale dependent, but that
doesn't mean that it could be in the future.  (I wouldn't find it
particularly useful, because the current format is internationally
readable.)

What *is* locale dependent are the messages, though.  Not sure how you
plan to deal with that.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Link to bug webpage
Next
From: mlw
Date:
Subject: Re: Link to bug webpage