From: | "Brandon Aiken" <BAiken(at)winemantech(dot)com> |
---|---|
To: | <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>, "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES |
Date: | 2006-12-21 17:00:06 |
Message-ID: | F8E84F0F56445B4CB39E019EF67DACBA401A8A@exchsrvr.winemantech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
'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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Rodrigo Sakai
Sent: Thursday, December 21, 2006 12:33 PM
To: pgsql-general(at)postgresql(dot)org
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2006-12-21 17:03:30 | Re: Autovacuum Improvements |
Previous Message | Mike Leahy | 2006-12-21 16:58:21 | Compiling PL/R library on win32 |