Question about 'copy' and datetime

From: Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Question about 'copy' and datetime
Date: 2001-01-22 04:08:30
Message-ID: 3A6BB23E.46FBE132@greatpacific.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-22 05:34:37 Re: Question about 'copy' and datetime
Previous Message Josh Berkus 2001-01-21 17:13:06 Re: abstract data types?