Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.com Date: Fri, 30 Jan 2004 11:20:20 -0600 From: George Weaver Subject: Setting date and time To: Cygwin Message-id: <008401c3e755$569270e0$6400a8c0@Dell4500> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit References: <013e01c3e05a$6e37e060$6400a8c0@Dell4500> <002a01c3e66b$d39321b0$6400a8c0@Dell4500> <23862.1075394766@sss.pgh.pa.us> <00ac01c3e68d$4c2b9e10$6400a8c0@Dell4500> <24919.1075399207@sss.pgh.pa.us> Hi All, I am trying to resolve a problem using PostgreSQL that may have its roots in Cygwin (see below). I am running PostgreSQL version 7.3.2 on Windows XP using Cygwin version 1.3.20. Once the PostgreSQL postmaster has started, if I change the system date on the PC, and query the database (Select current_date), the result I get is the date on the system relative to when postmaster started as a service, not the new date on the PC. Am I missing something really obvious?? test=# select now(); now ---------------------------- 2004-01-29 11:25:06.553-06 (1 row) test=# \! $ date Thu Jan 29 11:25:09 CST 2004 $ date 01\25\2004 Sun Jan 25 20:04:00 CST 2004 $ date Sun Jan 25 20:04:01 CST 2004 $ exit test=# select now(); now ---------------------------- 2004-01-29 11:25:34.032-06 (1 row) Thanks for your consideration of this request for help. George ----- Original Message ----- From: "Tom Lane" To: "George Weaver" Cc: "Manuel Sugawara" ; Sent: Thursday, January 29, 2004 12:00 PM Subject: Re: [NOVICE] Setting date and time > George Weaver writes: > > > > Hm, you're running PG under Cygwin then? This must be a Cygwin issue. > Postgres itself gets the time from the operating system at the start of > each transaction, and it's going to believe whatever the Cygwin > implementation of gettimeofday() tells it. > > regards, tom lane > -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Problem reports: http://cygwin.com/problems.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/