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