Re: Time slowly goes out of sync Cygwin+windows+psotgres - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Time slowly goes out of sync Cygwin+windows+psotgres
Date
Msg-id 20020829072125.Q96596-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Time slowly goes out of sync Cygwin+windows+psotgres  (Aaron <aarmel@netagi.com>)
List pgsql-admin
On Fri, 23 Aug 2002, Aaron wrote:

> Running postgres on cygwin and windows.
>
> Cygwin has the correct time.
> Windows has the same time as cygwin.
>
> Postgres slowly goes out of sync.  Over a month it ends up 10 minutes out.
>
> using e.g. "SELECT NOW()";

It might be possible that time() and gettimeofday() are returning
different times, we use the latter, I'd guess that what you're using
to get the date may use the former if it only gives integral seconds.



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Createlang problem.
Next
From: "Marc Mitchell"
Date:
Subject: Interpretting WAL debug.