Hi All, PST time changing tonight, I am not sure if this is going to affect the database. Please throw some light if the time change affect on our production system.
Briefly - We have 2 production database servers with postgresql 8.3.3 and pgpool 2.1 version running. Here is the postgres configuration details about time zone. #log_timezone = unknown # actually, defaults to TZ environment setting datestyle = 'iso, mdy' #timezone = unknown # actually, defaults to TZ environment # setting #timezone_abbreviations = 'Default' # Select the set of available time zone # abbreviations. Currently, there are # Default # Australia # India # You can create your own file in # share/timezonesets/. log_timezone, timezone and timezone_abbreviations are set to default. Thanks Deepak Murthy