Received: from sss.pgh.pa.us ([209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0M5a4082447 for ; Mon, 22 Jan 2001 00:36:04 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0M5Yb917364; Mon, 22 Jan 2001 00:34:38 -0500 (EST) To: Carolyn Lu Wong cc: "pgsql-sql@postgresql.org" Subject: Re: Question about 'copy' and datetime In-reply-to: <3A6BB23E.46FBE132@greatpacific.com.au> References: <3A6BB23E.46FBE132@greatpacific.com.au> Comments: In-reply-to Carolyn Lu Wong message dated "Mon, 22 Jan 2001 15:08:30 +1100" Date: Mon, 22 Jan 2001 00:34:37 -0500 Message-ID: <17361.980141677@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/276 X-Sequence-Number: 945 Carolyn Lu Wong writes: > 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? Given your return address, I'm betting this is a conflict between USA and Aussie interpretations of "EST". You probably need to recompile with USE_AUSTRALIAN_RULES #defined. See http://www.postgresql.org/users-lounge/docs/7.0/postgres/datetime-appendix.htm regards, tom lane