Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (Postfix) with ESMTP id F32E6476223 for ; Wed, 20 Mar 2002 11:38:44 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id 02C8868A17; Wed, 20 Mar 2002 10:38:49 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 9657E68A81; Wed, 20 Mar 2002 10:38:48 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.34 #1 (Debian)) id 16nj6u-0001JR-00; Wed, 20 Mar 2002 10:38:48 -0600 Date: Wed, 20 Mar 2002 10:38:48 -0600 From: "Ross J. Reedstrom" To: Ken Corey Cc: pgsql-sql@postgresql.org Subject: Re: How do I set the system time on production server? Message-ID: <20020320163848.GD4567@rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , Ken Corey , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.27i X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200203/261 X-Sequence-Number: 7140 Ken - Note that we're talking _system_ time, so you won't find the answer in the RDBMS docs - it's in the underlying OS docs. You don't mention what OS you're running, and what it's idea of the current time is, so we can't help you very well. If it's some flavor of unix, try looking at 'man date'. Personally, I use ntp to keep my linux system sync'ed with a timeserver on campus. Ross On Fri, Mar 15, 2002 at 05:29:32PM +0000, 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. > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)