RESTORING A DATABASE WITH DIFFERENT TIMEZONES

From: "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RESTORING A DATABASE WITH DIFFERENT TIMEZONES
Date: 2006-12-21 17:32:33
Message-ID: 000901c72526$02c1d1b0$4700a8c0@SOFTWARE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2006-12-21 17:34:59 Re: Password strength requirements
Previous Message Teodor Sigaev 2006-12-21 17:32:22 Re: TSearch2 Changeset 25387