Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Will changing the server date/time cause problems?


  • From: Justin Pasher <justinp(at)newmediagateway(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Will changing the server date/time cause problems?
  • Date: Mon, 17 Apr 2006 11:33:20 -0500
  • Message-id: <4443C350(dot)3090700(at)newmediagateway(dot)com>

A client of ours has requested that we change the time on the server to match their time zone (one hour ahead of us). Are there any know issues or gotchas to look out for when bumping the server time forward an hour? I couldn't imagine any issues occurring, since it's really just like the server when 1 hour without performing any activity. Obviously any fields in the database stored with a time without a timezone would be off afterwards, but that's not a huge concern.

Another client has requested the same thing, but their time is two hours behind us. This is the change that I'm more worried about, since you are going to have some data/time overlap on the server after the change is made. Are there any known issues with this situation in Postgres? Should everything be shutdown prior to the change, then restarted again?

Thanks.

Justin Pasher



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group