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 C5C3D3A568F for ; Tue, 25 Jan 2005 21:39:13 +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 23268-01 for ; Tue, 25 Jan 2005 21:39:01 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 43D343A46A0 for ; Tue, 25 Jan 2005 21:39:02 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0PLct56014022 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 25 Jan 2005 14:38:58 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0PLctVq095941; Tue, 25 Jan 2005 14:38:55 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0PLcloB095940; Tue, 25 Jan 2005 14:38:47 -0700 (MST) (envelope-from mfuhr) Date: Tue, 25 Jan 2005 14:38:47 -0700 From: Michael Fuhr To: Inpreet Singh Cc: pgsql-admin@postgresql.org Subject: Re: Restore postgres database problem Message-ID: <20050125213847.GA95908@winnie.fuhr.org> References: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/264 X-Sequence-Number: 16123 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/