Received: from arrows.timewarp.co.uk (arrows.timewarp.co.uk [217.149.108.6]) by postgresql.org (Postfix) with ESMTP id 09418475B66 for ; Fri, 15 Mar 2002 12:31:11 -0500 (EST) Received: from [217.149.96.22] (helo=there) by arrows.timewarp.co.uk with smtp (Exim 3.22 #3) id 16lvXk-0006mI-00 for pgsql-sql@postgresql.org; Fri, 15 Mar 2002 17:31:04 +0000 Content-Type: text/plain; charset="iso-8859-1" From: Ken Corey Organization: Atomic Interactive, Ltd. To: pgsql-sql@postgresql.org Subject: How do I set the system time on production server? Date: Fri, 15 Mar 2002 17:29:32 +0000 X-Mailer: KMail [version 1.3.1] MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: X-Scanner: exiscan *16lvXk-0006mI-00*thsXbBYTVp2* http://duncanthrax.net/exiscan/ X-Archive-Number: 200203/256 X-Sequence-Number: 7135 Hi All, I've just realized that our (production, naturally) database's idea of the= =20 current date/time is 24 hours and 14 minutes fast. What a weird thing. So, is there a way to set the date/time? I've hit the mail archives,=20 searchable docs, gone through Bruce Momjian's book, hit google, even=20 sacrificed a few chickens just on the off chance, and found nothing.=20=20 Lots of queries about dates, times, or how to find the current system=20 time...but not how to SET the current system date. Argh! Help! (P.S. I'd _love_ an RTFM answer as long as you tell me where the FM is...;^) --- Ken Corey CTO Atomic Interactive, Ltd. http://www.atomic-interactive.com