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...
pgsql-admin by date
|Next:||From: Andrew Hill||Date: 2001-10-22 23:44:57|
|Subject: Re: Freeing Connections|
|Previous:||From: Sudheer Palaparambil||Date: 2001-10-22 08:29:32|
|Subject: REMOTE PROCEDURE CALLS|