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

pg_dump and timestamp : problem with TimeZone

From: "Emmanuel Guyot" <emmguyot(at)wanadoo(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump and timestamp : problem with TimeZone
Date: 2001-10-22 11:59:41
Message-ID: 9r11np$mk9$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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


pgsql-admin by date

Next:From: Andrew HillDate: 2001-10-22 23:44:57
Subject: Re: Freeing Connections
Previous:From: Sudheer PalaparambilDate: 2001-10-22 08:29:32

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