Thread: pg_dump and timestamp : problem with TimeZone
I have some columns with timestamp data type wich includes the time zone. I access these columns using JDBC which handle the time zone automaticly. Writing and reading data work fine. Though when I dump the base and restore it, the date are 2 hours later. Is seems to me that the timezone is lost somewhere. Here are technical information : - I've launched my base (7.1.3 with cygwin) while TZ=GMT-2. - To dump I use : pg_dump.exe -c -F c -Z 9 myDB - To restore I use : zcat file.gz | pg_restore -v -c -F c -d myDB For both dump and restore TZ is GMT-2. Thanks for your hints... Emmanuel Guyot
I hardly believe that noone knows about this problem. Emmanuel Guyot "Emmanuel Guyot" <emmguyot@wanadoo.fr> a �crit dans le message de news: 9r11np$mk9$1@news.tht.net... > I have some columns with timestamp data type wich includes the time zone. > I access these columns using JDBC which handle the time zone automaticly. > Writing and reading data work fine. > > Though when I dump the base and restore it, the date are 2 hours later. Is > seems to me that the timezone is lost somewhere. > > Here are technical information : > - I've launched my base (7.1.3 with cygwin) while TZ=GMT-2. > - To dump I use : pg_dump.exe -c -F c -Z 9 myDB > - To restore I use : zcat file.gz | pg_restore -v -c -F c -d myDB > > For both dump and restore TZ is GMT-2. > > Thanks for your hints... > > Emmanuel Guyot > > >
Well, I've just solved the problem : I don't use anymore the TZ variable. And now there is no more problem. Though, I had to modify my programs to force the Timezone at each request. If you have another workaround, just tell... Emmanuel Guyot "Emmanuel Guyot" <emmguyot@wanadoo.fr> a �crit dans le message de news: 9r11np$mk9$1@news.tht.net... > I have some columns with timestamp data type wich includes the time zone. > I access these columns using JDBC which handle the time zone automaticly. > Writing and reading data work fine. > > Though when I dump the base and restore it, the date are 2 hours later. Is > seems to me that the timezone is lost somewhere. > > Here are technical information : > - I've launched my base (7.1.3 with cygwin) while TZ=GMT-2. > - To dump I use : pg_dump.exe -c -F c -Z 9 myDB > - To restore I use : zcat file.gz | pg_restore -v -c -F c -d myDB > > For both dump and restore TZ is GMT-2. > > Thanks for your hints... > > Emmanuel Guyot > > >