Postgres Pro
Downloads
Home   >   mailing lists

RESTORING A DATABASE WITH DIFFERENT TIMEZONES - Mailing list pgsql-general

From Rodrigo Sakai
Subject RESTORING A DATABASE WITH DIFFERENT TIMEZONES
Date
Msg-id 000901c72526$02c1d1b0$4700a8c0@SOFTWARE
Whole thread Raw
Responses Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES  ("Brandon Aiken" <BAiken@winemantech.com>)
Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Tree view

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!

pgsql-general by date:

Previous
From: James Robinson
Date:
Subject: Re: 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...
Next
From: "Brandon Aiken"
Date:
Subject: Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES