Re: Timezone for %t log_line_prefix

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Timezone for %t log_line_prefix
Date: 2004-08-04 20:37:45
Message-ID: 41114919.5060700@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Pflug wrote:

> If %t is used in log_line_prefix, win32's strftime will print a very
> long timezone information, e.g. "W. Europe Daylight Time" where Linux
> would write "UTC". This makes the timestamp consuming more than half
> of an average line length.
> Do we have alternatives to the long form? Do we need the timezone
> information at all? We know already it's the server's time. Another
> alternative would be a short timestamp (%t vs. %T) to have both.
>
>

That's ugly, and unfortunately %z is GNU-specific. The quick fix for now
does seem to be providing alternative forms - %T and %S make sense. Of
course, if we wanted it *really* short we could just print out the
current epoch time in 8 hex digits :-)

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan Gardner 2004-08-04 20:47:38 Re: Updateable Views?
Previous Message Tom Lane 2004-08-04 19:33:15 Re: 7.5 backend crash