| From: | <trena-no-spam(at)cotse(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Forcing postgres to reload current time zone. |
| Date: | 2004-07-01 13:48:33 |
| Message-ID: | dHJlbmE=.a1f5c74717693b1d1ebc35f898424005@1088689713.nulluser.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I'm writing an application that issues "SELECT current_timestamp" from
postgres on a regular basis to get the time. However, the user may
change the system's time zone and postgres does not seem to reflect this
change unless I restart the database daemon. I cannot have all of my
program threads issue a SET TIME ZONE query, and was hoping there is a
query I could issue that would globally update the time zone for all
currently running postgres sessions, or a more gentle way to force
postgres to reload its time zone information without completely
restarting the daemon. Any advice?
I've done quite a bit of searching for this answer and I'm not coming up
with anything useful. I'm running postgres on RedHat Linux 9.
Many thanks,
trena
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-07-01 15:25:29 | Re: Postgres IDENT auth problems... |
| Previous Message | Tom Lane | 2004-07-01 13:09:15 | Re: Postgres IDENT auth problems... |