pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres TimeZone
3+ messages / 2 participants
[nested] [flat]

* Postgres TimeZone
@ 2011-04-30 04:13  Anibal David Acosta <aa@devshock.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Anibal David Acosta @ 2011-04-30 04:13 UTC (permalink / raw)
  To: pgsql-admin

Hello, I have a postgres installed on a Windows server machine.

In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.

Is possible to kept the Postgres in sync with the windows time (time and
timezone)?

If not, can I reload the new timezone without restaring the postgres
service?

Thanks!.

Anibal




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Postgres TimeZone
@ 2011-05-02 13:36  Anibal David Acosta <aa@devshock.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Anibal David Acosta @ 2011-05-02 13:36 UTC (permalink / raw)
  To: pgsql-admin

Hello, I have a postgres installed on a Windows server machine.

In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.

Is possible to kept the Postgres in sync with the windows time (time and
timezone)?

If not, can I reload the new timezone without restaring the postgres
service?

Thanks!.

Anibal




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Postgres TimeZone
@ 2011-05-02 13:47  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Anibal David Acosta <aa@devshock.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Kevin Grittner @ 2011-05-02 13:47 UTC (permalink / raw)
  To: Anibal David Acosta <aa@devshock.com>; pgsql-admin

"Anibal David Acosta" <aa@devshock.com> wrote:
 
> In my country we have daylight saving so my windows OS is
> configured to automatically change timezone but the postgres only
> reload the new timezone after restart.
 
Can you show us your settings?
 
http://wiki.postgresql.org/wiki/Server_Configuration
 
You're not changing time zone configuration every time DST starts or
ends, are you?
 
-Kevin



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2011-05-02 13:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-30 04:13 Postgres TimeZone Anibal David Acosta <aa@devshock.com>
2011-05-02 13:36 Postgres TimeZone Anibal David Acosta <aa@devshock.com>
2011-05-02 13:47 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox