Search Postgresql Archives

Re: timestamp skew during 7.4 -> 8.2 upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Louis-David Mitterrand <vindex+lists-pgsql-general@xxxxxxxxxxx> writes:
> But, I found something fishy that particular server:
> 	uruk:~# hwclock 
> 	Sat 11 Aug 2007 10:47:36 AM CEST  -0.630123 seconds
> 	uruk:~# hwclock --utc
> 	Sat 11 Aug 2007 12:47:39 PM CEST  -0.600430 seconds

If this is PC-type hardware, I'd guess that something is confused about
whether the hardware clock is running in UTC or local time.

> Is postgres using the same time reference as "hwclock" or "date" ?

I'd expect PG to get the same results as "date".  I have no idea what
"hwclock" is really doing.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux