pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ross J. Reedstrom <reedstrm@rice.edu>
To: Ken Corey <ken.corey@atomic-interactive.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How do I set the system time on production server?
Date: Wed, 20 Mar 2002 10:38:48 -0600
Message-ID: <20020320163848.GD4567@rice.edu> (raw)
In-Reply-To: <E16lvXk-0006mI-00@arrows.timewarp.co.uk>
References: <E16lvXk-0006mI-00@arrows.timewarp.co.uk>

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)



view thread (8+ messages)  latest in thread

Message-ID: <20020320163848.GD4567@rice.edu>
Permalink:  ../20020320163848.GD4567@rice.edu/
Also on:    postgresql.org/message-id/20020320163848.GD4567@rice.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: reedstrm@rice.edu, ken.corey@atomic-interactive.com
  Subject: Re: How do I set the system time on production server?
  In-Reply-To: <20020320163848.GD4567@rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox