On Thu, May 13, 2004 at 15:07:13 -0500,
Bruno Wolff III <bruno@wolff.to> wrote:
> On Thu, May 13, 2004 at 12:56:48 -0600,
> Anony Mous <A.Mous@shaw.ca> wrote:
> > Hi,
> >
> > Is there a function that would allow me to set the local time while the
> > server is running? I can't seem to find anything on this...
>
> You probably want to set the timezone, not the local time.
> You can do that with something like:
> SET TIMEZONE='EST5EDT';
Thinking about this some more; this only changes it for the session not
the default for new sessions.
Reading the documentation suggests that you can set the timezone in the
config file and sighup the postmaster to get it to reread the config file.
It might also be possible to change the underlying system's timezone
and do a sighup to have it pick up the correct timezone.
If the underlying system has the correct timezone, but for some reason has
the wrong time, you should be able to change its time. How you do that
varies a bit from system to system. Under *nix systems you usually use
the 'date' command (if you aren't using ntp). Under Linux, at least,
you also want to run setclock to set the hardware clock to the right
time so the time is still correct after the next reboot.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
