Tom Lane wrote:
>"Oliver Elphick" <[EMAIL PROTECTED]> writes:
>> Notices are being timestamped in GMT in the syslog, instead of local
>> time like all other log entries. Here's a fragment from my syslog:
>
>Curious. I always assumed that syslog timestamps were supplied by the
>syslog daemon, but to make this happen they'd have to be supplied in the
>syslog client process (viz. the Postgres process). What timezone is the
>Postgres backend being run in, and is it different from all the other
>syslog clients on the system?
I just got this extra information from the reporter.
------- Forwarded Message
Date: Thu, 24 May 2001 08:57:49 -0400
From: "Marc Sherman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Bug#98565: More info on this bug
The connection that is creating this NOTICE is executing
"set time zone 'GMT';" immediately after connection; I
suspect that what's happening is that postmaster is setting the
libc timezone (by changing the environment and calling tzset)
when is executes that query, causing subsequent system calls
(including syslog) to use the new timezone.
- - Marc
------- End of Forwarded Message
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I will praise thee; for I am fearfully and wonderfully
made..." Psalms 139:14
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
