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

I don't think so, otherwise I think I would have seen this as soon as I
started the load.

What I did change 2nd time round was my pg_cumpall command:

    %> pg_dump -d <databasename> > databaseFile.sql

This seems to have gotten rid of all the "stdin" messages, and the load
goes fine.

FYI, pg_dump -d, --inserts dump data as INSERT, rather than COPY, commands

I think that was the problemo.

    Thx,
    Aurangzeb

On Wed, 13 Nov 2002, Stephan Szabo wrote:

:On Wed, 13 Nov 2002, Aurangzeb M. Agha wrote:
:
:> 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
:
:Is it possible that you're running into an end of line issue moving from
:Windows to Linux?