From jklcom@mindspring.com Wed Apr  2 15:12:58 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 42C17475ED4
	for <pgsql-sql@postgresql.org>; Wed,  2 Apr 2003 10:12:58 -0500 (EST)
Received: from mgci.com (box1.mpowercom.net [208.57.0.10])
	by postgresql.org (Postfix) with SMTP id 312D7475EC9
	for <pgsql-sql@postgresql.org>; Wed,  2 Apr 2003 10:12:27 -0500 (EST)
Received: (qmail 17060 invoked by uid 0); 2 Apr 2003 15:12:33 -0000
Received: from unknown (HELO DemoServer) (208.57.212.250)
	by mgci.com with SMTP; 2 Apr 2003 15:12:33 -0000
From: "Jeff Lu" <jklcom@mindspring.com>
To: <pgsql-general@postgresql.org>, <pgsql-sql@postgresql.org>,
	<pgsql-sql-owner@postgresql.org>
Subject: error: lost syncronization with server
Date: Wed, 2 Apr 2003 10:19:25 -0500
Message-ID: <01c901c2f92b$3fa43030$1501a8c0@DemoServer>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01CA_01C2F901.56CE2830"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
X-Spam-Status: No,
 hits=0.0 required=5.0 tests=BAYES_30,HTML_20_30 version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/21
X-Sequence-Number: 12722

This is a multi-part message in MIME format.

------=_NextPart_000_01CA_01C2F901.56CE2830
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

I have recently upgrade to postgresql 7.3.2-1. I'm having problem in
restoring my database. I'm getting the following errors
while restoring:

CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
ERROR: copy: line 1, CopyReadAttribute: end of record marker
corrupted
FATAL: Socket command type
unknown
could not receive data from server: Connection aborted
lost synchronization with server, resetting connection

What's wrong? I need help

Thanks
-Jeff



------=_NextPart_000_01CA_01C2F901.56CE2830
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV>
<DIV><FONT face=3DArial size=3D2>Hi,<BR><BR>I have recently upgrade to post=
gresql=20
7.3.2-1. I'm having problem in<BR>restoring my database. I'm getting the=20
following errors<BR>while restoring:<BR><BR>CREATE TABLE<BR>CREATE=20
TABLE<BR>CREATE TABLE<BR>CREATE TABLE<BR>CREATE TABLE<BR>ERROR: copy: line =
1,=20
CopyReadAttribute: end of record marker<BR>corrupted<BR>FATAL: Socket comma=
nd=20
type<BR>unknown<BR>could not receive data from server: Connection=20
aborted<BR>lost synchronization with server, resetting connection<BR><BR>Wh=
at's=20
wrong? I need=20
help<BR><BR>Thanks<BR>-Jeff<BR><BR></FONT></DIV></DIV></BODY></HTML>

------=_NextPart_000_01CA_01C2F901.56CE2830--




From tgl@sss.pgh.pa.us Wed Apr  2 15:35:52 2003
X-Original-To: pgsql-general@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id CD316474E44; Wed,  2 Apr 2003 10:35:52 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP
	id 978BC474E44; Wed,  2 Apr 2003 10:35:21 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h32FZN2L021212;
	Wed, 2 Apr 2003 10:35:24 -0500 (EST)
To: "Jeff Lu" <jklcom@mindspring.com>
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] error: lost syncronization with server 
In-reply-to: <01c901c2f92b$3fa43030$1501a8c0@DemoServer> 
References: <01c901c2f92b$3fa43030$1501a8c0@DemoServer>
Comments: In-reply-to "Jeff Lu" <jklcom@mindspring.com>
	message dated "Wed, 02 Apr 2003 10:19:25 -0500"
Date: Wed, 02 Apr 2003 10:35:23 -0500
Message-ID: <21211.1049297723@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-32.5 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/85
X-Sequence-Number: 40150

"Jeff Lu" <jklcom@mindspring.com> writes:
> ERROR: copy: line 1, CopyReadAttribute: end of record marker
> corrupted

I'd wonder if you did something to the dump file that caused newlines to
get converted from \n to \r\n, or some such.  COPY isn't real forgiving
about that ...

			regards, tom lane