Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 64586475DF5 for ; Wed, 20 Mar 2002 11:23:58 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 106CBD5F7; Wed, 20 Mar 2002 08:24:03 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 061805BFC; Wed, 20 Mar 2002 08:24:03 -0800 (PST) Date: Wed, 20 Mar 2002 08:24:02 -0800 (PST) From: Stephan Szabo To: Ken Corey Cc: Subject: Re: How do I set the system time on production server? In-Reply-To: Message-ID: <20020320082235.G45997-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/260 X-Sequence-Number: 7139 On Fri, 15 Mar 2002, 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. If you're logged into a shell on the system is the time off there as well? If so, use the OS's tools to change the date/time.