From: | "Aurangzeb M(dot) Agha" <aagha(at)bigfoot(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: error: lost syncronization with server |
Date: | 2002-11-13 17:56:59 |
Message-ID: | Pine.LNX.4.44.0211130954210.32374-100000@cinemaspace.berkeley.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-13 18:09:26 | Re: index question.. |
Previous Message | Tom Lane | 2002-11-13 17:50:18 | Re: tsearch consistency trigger on inheritated table |