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 <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> 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 [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 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html