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 973DB3A56D3 for ; Tue, 25 Jan 2005 04:56:25 +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 72743-07 for ; Tue, 25 Jan 2005 04:56:23 +0000 (GMT) Received: from mail.netsity.com (unknown [61.246.180.169]) by svr1.postgresql.org (Postfix) with ESMTP id E3C793A56C8 for ; Tue, 25 Jan 2005 04:56:22 +0000 (GMT) Received: by mail.netsity.com with Internet Mail Service (5.5.2653.19) id ; Tue, 25 Jan 2005 10:26:33 +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 D3CHC12M; Tue, 25 Jan 2005 10:26:25 +0530 From: Inpreet Singh To: pgsql-admin@postgresql.org Message-ID: <006d01c5029a$38fb4e60$3c67a8c0@netsity.com> Subject: Restore postgres database problem Date: Tue, 25 Jan 2005 10:26:25 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C502C8.52AA1480" 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.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/262 X-Sequence-Number: 16121 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C502C8.52AA1480 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am using postgres 7.3.4. I am trying to restore database dump using psql command but getting following error. =20 Taken Dump : /usr/bin/pg_dumpall > /home/inpreet/postgres.sql=20 Restoring Dump : su - postgres /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql =20 but getting error ERROR: copy: line 32, Bad date external representation '\N lost synchronization with server, resetting connection =20 Please tell me which way to go. =20 Thanks and Regards Inpreet Singh =20 ------=_NextPart_000_006A_01C502C8.52AA1480 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
I am using postgres 7.3.4. I am trying = to restore=20 database dump using psql command but getting following = error.
 
Taken Dump = :  =20 /usr/bin/pg_dumpall > /home/inpreet/postgres.sql
Restoring Dump = :   su -=20 postgres
/usr/local/pgsql/bin/psql -d template1 = <=20 /home/inpreet/postgres.sql
 
but getting error
ERROR:  copy: line 32, Bad date = external=20 representation '\N
lost synchronization with server, resetting=20 connection
 
Please tell me which way to = go.
 
Thanks and = Regards
Inpreet = Singh
 

------=_NextPart_000_006A_01C502C8.52AA1480--