Search Postgresql Archives

Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



'2006-12-20 00:00:00-02' and '2006-12-19 23:00:00-03' *are* the same
time.  You *did* preserve it.  Is your application unaware of timezone?

If you want the server to behave like it's in a different time zone that
where it actually is, configure the locale in postgresql.conf.

http://www.postgresql.org/docs/8.2/interactive/runtime-config-client.htm
l#GUC-TIMEZONE


--
Brandon Aiken
CS/IT Systems Engineer
________________________________________
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rodrigo Sakai
Sent: Thursday, December 21, 2006 12:33 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

Hi all,

I'm having some troubles with time zones! I have a database dump file
that have the date fields stored as '2006-12-20 00:00:00-02'! 
And I have to restore it in a database that has the time zone configured
as 'BRST' (-3 from GMT). So, when it is restored the value becomes
'2006-12-19 23:00:00-03'. Ok this is logic because the difference of
time zones.

But I have to restore it and maintain the same value of datetime! How
can I do it?????

Thanks in advance! 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux