pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
timezone Q for  postgresql v814
2+ messages / 2 participants
[nested] [flat]

* timezone Q for  postgresql v814
@ 2006-09-07 14:00  Mr. Dan <bitsandbytes88@hotmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Mr. Dan @ 2006-09-07 14:00 UTC (permalink / raw)
  To: pgsql-admin

Hi,

We have SLES set up to use UTC-4 right now, EDT.  When we do a restore, we 
have to set the time 1 hour earlier than we really want the restore time to 
be.  This is because we have a theory that something isn't defined quite 
right.  We think postgres is using UTC-5 for some reason.  We don't have 
timezone defined in the conf file, but we thought it would use the default, 
UTC-4.  Has anyone experienced this or know if the solution is to set 
timezone to America/New_York as the timezone variable in the conf file to 
get them both using UTC-4, EDT?  Is this a problem we'll experience in the 
summer since we're using the daylight savings time specification?

Thanks,
~DjK





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

* Re: timezone Q for  postgresql v814
@ 2006-09-07 14:28  Andrew Sullivan <ajs@crankycanuck.ca>
  parent: Mr. Dan <bitsandbytes88@hotmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Andrew Sullivan @ 2006-09-07 14:28 UTC (permalink / raw)
  To: pgsql-admin

On Thu, Sep 07, 2006 at 10:00:31AM -0400, Mr. Dan wrote:

> right.  We think postgres is using UTC-5 for some reason.  We don't have 

Why do you think that?  

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
		--Jane Jacobs 



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


end of thread, other threads:[~2006-09-07 14:28 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-07 14:00 timezone Q for  postgresql v814 Mr. Dan <bitsandbytes88@hotmail.com>
2006-09-07 14:28 ` Andrew Sullivan <ajs@crankycanuck.ca>

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