Re: Bug#98565: postgresql logs notices with GMT timestamps in syslog (fwd)

Tom Lane wrote: >"Oliver Elphick" <olly@lfix.co.uk> writes: >> Notices are being timestamped in GMT in the syslog,
insteadof local >> time like all other log entries.  Here's a fragment from my syslog: > >Curious.  I always assumed
thatsyslog timestamps were supplied by the >syslog daemon, but to make this happen they'd have to be supplied in the
>syslogclient process (viz. the Postgres process).  What timezone is the >Postgres backend being run in, and is it
differentfrom 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" <msherman@projectile.ca>
To:      <98565@bugs.debian.org>
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                                Oliver.Elphick@lfix.co.uk
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..."
Psalms139:14