Postgres Pro
Downloads
Home   >   mailing lists

what is the origin of postgreSQL time - Mailing list pgsql-admin

From Julius Tuskenis
Subject what is the origin of postgreSQL time
Date
Msg-id 47F0A958.2040608@nsoft.lt
Whole thread Raw
Responses Re: what is the origin of postgreSQL time  (Thomas Markus <t.markus@proventis.net>)
Re: what is the origin of postgreSQL time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Hello,

I have problem with postgreSQL current_timestramp. Where does it get its
value, because it doesnt match system time. The problem appeared after
this saturday-sunday night and is connected somehow with the daylight
saving. Now "date" on the server returns good value, but the SELECT
current_timestmap is 1 hour late.

Postgresql 8.1.4
OS: Gentoo Linux

--
Julius Tuskenis

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: how to improve COPY timings or reduce data loading time using copy
Next
From: Thomas Markus
Date:
Subject: Re: what is the origin of postgreSQL time