pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

error: lost syncronization with server
2+ messages / 2 participants
[nested] [flat]

* error: lost syncronization with server
@ 2003-04-02 15:19 Jeff Lu <jklcom@mindspring.com>
  2003-04-02 15:35 ` Re: [SQL] error: lost syncronization with server Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Jeff Lu @ 2003-04-02 15:19 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql; pgsql-sql-owner@postgresql.org

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] error: lost syncronization with server
  2003-04-02 15:19 error: lost syncronization with server Jeff Lu <jklcom@mindspring.com>
@ 2003-04-02 15:35 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2003-04-02 15:35 UTC (permalink / raw)
  To: Jeff Lu <jklcom@mindspring.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql

"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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-04-02 15:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-02 15:19 error: lost syncronization with server Jeff Lu <jklcom@mindspring.com>
2003-04-02 15:35 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox