Re: Time slowly goes out of sync Cygwin+windows+psotgres

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Aaron <aarmel(at)netagi(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Time slowly goes out of sync Cygwin+windows+psotgres
Date: 2002-08-29 14:22:53
Message-ID: 20020829072125.Q96596-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mitchell 2002-08-29 15:12:56 Interpretting WAL debug.
Previous Message Tom Lane 2002-08-29 14:17:06 Re: Createlang problem.