469,167 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Timestamp with Timezone


I recently upgraded an application from postgresql 7.4.2 to 7.4.5, and now I am having timezone nightmares.

I checked on the old server, and found that in the postgresql.conf, the timezone was set for unknown. The timezone portion of the records was being set to GMT+06 ( for reference, I am in GMT-06 ). Now, on the old server, wheni pulled data, the dates came back correctly.

However, on the new server, I am getting dates that adjust properly for thetimezone in the record, which means that my records show as having been entered a day before, which is killing my users. Can someone help me understand the timezone nightmare, and how i can fix my records so that they appearon the correct day?

I am using the exact same jdbc library to connect to both servers, and my setup is:

OLD Setup
Redhat 9
Postgres 7.4.2 (compiled from source)

NEW Setup
Redhat 3 Enterprise
Postgres 7.4.5 (compiled from source)
Thanks,

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
1 2148
"Chris M. Gamble" <ch**********@cpbinc.com> writes:
I checked on the old server, and found that in the postgresql.conf,
the timezone was set for unknown.


Which would mean "use the system-wide timezone setting". I suspect you
have the new server configured with a different system-wide setting.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Craig Bailey | last post: by
1 post views Thread by Will Trillich | last post: by
6 posts views Thread by Scott Nixon | last post: by
6 posts views Thread by Chris Burnley | last post: by
2 posts views Thread by James | last post: by
7 posts views Thread by Damir | last post: by
4 posts views Thread by =?Utf-8?B?QnJhc3NpY2FOaWdyYQ==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.