Re: error: lost syncronization with server - Mailing list pgsql-general

From Aurangzeb M. Agha
Subject Re: error: lost syncronization with server
Date
Msg-id Pine.LNX.4.44.0211130559350.31901-100000@cinemaspace.berkeley.edu
Whole thread Raw
In response to error: lost syncronization with server  ("Aurangzeb M. Agha" <aagha@bigfoot.com>)
Responses Re: error: lost syncronization with server
List pgsql-general
I spoke to soon.  It seems the error I'm getting is from inside my dumpall
script:

-- Data for TOC Entry ID 147 (OID 16559)
--
-- Name: rating Type: TABLE DATA Owner: postgres
--
COPY "rating" FROM stdin;
\.

What _is_ this record?  Tehre seem to be quite a few of this type.

Did I use pg_dumpall incorrectly?

I simply started the postmaster and :

    %> pg_dumpall > myOutputFile.qsl

    Thx,
    Aurangzeb


On Wed, 13 Nov 2002, Aurangzeb M. Agha wrote:

:I'm trying to create a database on Linux RH 7.2 (postgres version 7.2.3)
:from a pg_dumpall generated script on W2K, Cygwin (postgres version 7.2.3
:also).  The script connects fine, starts creating tables, indexes, and
:recoards, and then suddently throws up this error:
:
:ERROR:  copy: line 1, CopyReadAttribute: end of record marker corrupted
:lost synchronization with server, resetting connection
:
:Any thoughts on what I need to be looking for?
:
:    Thx in Advance,
:    Aurangzeb
:
:


pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Upgrade to dual processor machine?
Next
From: Doug McNaught
Date:
Subject: Re: Solved, and a bug found! Re: JDBC question: Creating new arrays