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

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Bug#98565: postgresql logs notices with GMT timestamps in syslog (fwd)
Date: 2001-05-24 08:30:05
Message-ID: 200105240830.f4O8U6Am029068@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I can't see any reason in the code why this should be happening.

------- Forwarded Message

Date: Thu, 24 May 2001 00:25:32 -0400
From: Marc Sherman <msherman(at)projectile(dot)ca>
To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)org>
Subject: Bug#98565: postgresql logs notices with GMT timestamps in syslog

Package: postgresql
Version: 7.1.1-3
Severity: normal

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:

May 23 23:17:30 projectile postgres[1035]: [1] DEBUG: connection: host=[local]
user=www-data database=inwopc
May 24 03:17:30 projectile postgres[1035]: [2] NOTICE: Adding missing FROM-cla
u
se entry for table "games"
May 23 23:17:30 projectile apache: NOTICE: Adding missing FROM-clause entry fo
r
table "games"

All three entries are from the same connection. The second entry is
the notice being logged by postgres, while the third entry (with the
local timestamp) is that same notice being logged by apache (php).

- - Marc

- -- System Information
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux projectile 2.2.19 #1 Mon May 7 09:24:37 EDT 2001 i586

Versions of packages postgresql depends on:
ii debconf 0.9.41 Debian configuration management sy
ii debianutils 1.15 Miscellaneous utilities specific t
ii libc6 2.2.3-1 GNU C Library: Shared libraries an
ii libpgsql2.1 7.1.1-3 Shared library libpq.so.2.1 for Po
ii libreadline4 4.2-3 GNU readline and history libraries
ii libssl0.9.6 0.9.6-2 SSL shared libraries
ii postgresql-client 7.1.1-3 Front-end programs for PostgreSQL
ii procps 1:2.0.7-4 The /proc file system utilities.
ii zlib1g 1:1.1.3-15 compression library - runtime

------- End of Forwarded Message

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)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..." Psalms 139:14

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-24 11:07:24 Smaller access privilege changes
Previous Message Alessio Bragadini 2001-05-24 07:39:23 Re: BSD gettext