Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Another interesting questions are what postgres does when timezone files
> are changed? Does it need SIGHUP to invoke rereading? What is impact on
> current running transaction when tz file is changed?
This falls into the category of "get a life". There is no program in
the world that automatically reacts to timezone data updates. The
normal expectation is that you reboot, because such always-on daemons as
"cron" will already have read the timezone file into memory. The libc
API doesn't even provide a way that one could tell libc to re-read after
SIGHUP, say.
regards, tom lane