Received: from wonder.kss.net.au ([203.41.122.41]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0M490077954 for ; Sun, 21 Jan 2001 23:09:06 -0500 (EST) (envelope-from carolyn@greatpacific.com.au) Received: from greatpacific.com.au (coco [10.10.1.9]) by wonder.kss.net.au (8.9.3/8.8.7) with ESMTP id PAA23814 for ; Mon, 22 Jan 2001 15:10:57 +1100 Message-ID: <3A6BB23E.46FBE132@greatpacific.com.au> Date: Mon, 22 Jan 2001 15:08:30 +1100 From: Carolyn Lu Wong X-Mailer: Mozilla 4.75 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Question about 'copy' and datetime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/275 X-Sequence-Number: 944 I'm using V6.5. I find that when I try to restore a backup database (done by pg_dump), the datetime value seem inconsistent. I've checked the dumped file, the data seems alright. However, the imported date is +16hr of the date in the data file. The system uses EST. The data dumped also has EST postfix. Is this a bug or there are other options I need to set? fyi, the command used in the backup script pg_dump -c -u -f $BACKUP_FILE $DATABASE and the command used in the restore script psql -e -u -f $BACKUP_FILE $DATABASE