Skip site navigation (1) Skip section navigation (2)

Re: pg_dump and timestamp : problem with TimeZone

From: "Emmanuel Guyot" <emmguyot(at)wanadoo(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump and timestamp : problem with TimeZone
Date: 2001-10-28 13:43:17
Message-ID: 9rh2d1$2q93$1@news.tht.net (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)wanadoo(dot)fr> a crit dans le message de news:
9r11np$mk9$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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
>
>
>



In response to

pgsql-admin by date

Next:From: Marko KreenDate: 2001-10-28 15:09:45
Subject: Re: UNICODE
Previous:From: Jean-Michel POUREDate: 2001-10-28 13:34:49
Subject: Re: UNICODE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group