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 9570A3A5DE3 for ; Thu, 27 Jan 2005 05:33:39 +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 93189-06 for ; Thu, 27 Jan 2005 05:33:36 +0000 (GMT) Received: from mail.netsity.com (unknown [61.246.180.169]) by svr1.postgresql.org (Postfix) with ESMTP id DBA843A5DD3 for ; Thu, 27 Jan 2005 05:33:34 +0000 (GMT) Received: by mail.netsity.com with Internet Mail Service (5.5.2653.19) id ; Thu, 27 Jan 2005 11:03:46 +0530 Received: from ISINGH ([192.168.103.60]) by mail.netsity.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id D3CHCH5S; Thu, 27 Jan 2005 11:03:43 +0530 From: Inpreet Singh To: Michael Fuhr Cc: pgsql-admin@postgresql.org Message-ID: <00bc01c50431$c3997590$3c67a8c0@netsity.com> References: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> <20050125213847.GA95908@winnie.fuhr.org> Subject: Re: Restore postgres database problem Date: Thu, 27 Jan 2005 11:03:43 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.329 tagged_above=0 required=5 tests=AWL, URIBL_SBL X-Spam-Level: X-Archive-Number: 200501/297 X-Sequence-Number: 16156 *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 at local site so thats why psql and dumpall are in diff directories*/ /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: "Michael Fuhr" To: "Inpreet Singh" Cc: Sent: Wednesday, January 26, 2005 3:08 AM Subject: Re: [ADMIN] Restore postgres database problem > On Tue, Jan 25, 2005 at 10:26:25AM +0530, Inpreet Singh wrote: > > > > 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 > > I see that pg_dumpall and psql are in different directories. Are > they from different versions of PostgreSQL? Are they connecting > to backends running different versions? Which commands and which > backends are running which versions? > > > but getting error > > ERROR: copy: line 32, Bad date external representation '\N > > lost synchronization with server, resetting connection > > What do the offending line and the line or two preceding it look > like? > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ >