Re: How do I set the system time on production server? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: How do I set the system time on production server?
Date
Msg-id Pine.LNX.4.30.0203201218330.812-100000@peter.localdomain
Whole thread Raw
In response to How do I set the system time on production server?  (Ken Corey <ken.corey@atomic-interactive.com>)
Responses Re: How do I set the system time on production server?
List pgsql-sql
Ken Corey writes:

> 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?

The system time is inherited from the operating system.  You can use
date(1) or maybe hwclock(8) to alter the system time.  On some systems it
is not recommended to change the system time because that messes up all
kinds of scheduling, so if you can afford it, reboot and change the time
in the BIOS.  You should find information in those man pages about the
recommended way to do it on your system.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: What is Syntax for multiple FULL OUTER JOINS?
Next
From: "Mike Biamonte"
Date:
Subject: delete -> copy in -> WAL problem..?