X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 70CF43A5DA3 for ; Thu, 27 Jan 2005 10:02:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32135-09 for ; Thu, 27 Jan 2005 10:02:11 +0000 (GMT) Received: from smtp.ualg.pt (smtp1.ualg.pt [193.136.224.8]) by svr1.postgresql.org (Postfix) with ESMTP id B91503A5DA5 for ; Thu, 27 Jan 2005 10:02:11 +0000 (GMT) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 06DFE4BB83; Thu, 27 Jan 2005 11:01:44 +0000 (WET) Received: from smtp.ualg.pt ([127.0.0.1]) by localhost (smtp.ualg.pt [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 02455-01; Thu, 27 Jan 2005 11:01:41 +0000 (WET) Received: from [10.10.20.85] (raio.ualg.pt [10.10.20.85]) by smtp.ualg.pt (Postfix) with ESMTP id C5C614BB53; Thu, 27 Jan 2005 11:01:36 +0000 (WET) Message-ID: <41F8BBF7.6070600@ualg.pt> Date: Thu, 27 Jan 2005 10:01:27 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050105 Debian/1.7.5-1 X-Accept-Language: en-pt MIME-Version: 1.0 To: Inpreet Singh Cc: pgsql-admin Subject: Re: Restore postgres database problem References: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> <41F76C2C.8070007@ualg.pt> <00ad01c50431$7c5f5be0$3c67a8c0@netsity.com> In-Reply-To: <00ad01c50431$7c5f5be0$3c67a8c0@netsity.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.34 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, URIBL_SBL X-Spam-Level: X-Archive-Number: 200501/275 X-Sequence-Number: 16134 The command I use for dump is: pg_dump -Fc -h > For restore, I create the database first on pgsql, and then (on shell) I give the command: pg_restore -d Luis Sousa Inpreet Singh wrote: >*Taken Dump :* /usr/bin/pg_dumpall > /home/inpreet/postgres.sql /*which >was taken at client site*/ > >*Restoring Dump :* su - postgres /*This process I am doing*/ > /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql > >Sir I have some table values which are of type timestamp and those columns >have values like >""2004-10-09 10:03:36.689993"". So is it possible that when I am restoring >values this columns are creating all sort of trouble??? as timestamp field >means date time at the time of insertion of record and I am trying to insert >earlier date time. > >Regards >Inpreet Singh > >----- Original Message ----- >From: "Luis Sousa" >To: "Inpreet Singh" >Sent: Wednesday, January 26, 2005 3:38 PM >Subject: Re: [ADMIN] Restore postgres database problem > > > > >>Which options did you use to dump data? >>And which options did you use to restore it? >>Please submit the command lines used. >> >>Luis Sousa >> >>Inpreet Singh wrote: >> >> >> >>>Hello, >>>I am using postgres 7.3.4. I am trying to restore database dump using >>>psql command but getting following error. >>> >>>*Taken Dump :* /usr/bin/pg_dumpall > /home/inpreet/postgres.sql >>>*Restoring Dump :* su - postgres >>>/usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql >>> >>>but getting error >>>ERROR: copy: line 32, Bad date external representation '\N >>>lost synchronization with server, resetting connection >>> >>>Please tell me which way to go. >>> >>>Thanks a*n*d Regards >>>*Inpreet Singh* >>> >>> >>> >>> >> >> > > > >