"Thomas F. O'Connell" <tf(at)o(dot)ptimized(dot)com> writes:
> I'm curious. For 7.4.x, does the database require a restart for the
> change to take effect? I'm aware of a few production installations
> where the OS changed, but postgres time functions didn't take hold.
Yes, probably. On those systems you will likely also find cron and
other time-sensitive subsystems in need of a restart ...
regards, tom lane