Received: from lubitsch.akademie.de (ns.akademie.de [62.165.4.3]) by postgresql.org (Postfix) with ESMTP id 9606F476634 for ; Wed, 20 Mar 2002 11:59:07 -0500 (EST) Received: from [62.165.4.160] (helo=redgrave) by lubitsch.akademie.de with smtp (Exim 3.33 #2) id 16njQT-000746-00; Wed, 20 Mar 2002 17:59:01 +0100 From: Ian Barwick Organization: akademie.de Date: Wed, 20 Mar 2002 17:58:39 +0100 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: Ken Corey , pgsql-sql@postgresql.org References: In-Reply-To: Subject: Re: How do I set the system time on production server? MIME-Version: 1.0 Message-Id: <0203201758390B.27614@redgrave> Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/262 X-Sequence-Number: 7141 On Friday 15 March 2002 18:29, Ken Corey wrote: > Hi All, > > I've just realized that our (production, naturally) database's idea of the > 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, > searchable docs, gone through Bruce Momjian's book, hit google, even > sacrificed a few chickens just on the off chance, and found nothing. > > Lots of queries about dates, times, or how to find the current system > time...but not how to SET the current system date. Umm, the system date/time is generally the responsibility of your server hardware / operating system. In a shell, what does 'date' say? Ian Barwick PS tip for all those who haven't tried it: do not attempt to sacrifice chickens in your server room, the feathers tend to get stuck in the ventilation.