Re: restore whoes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simone Tellini <tellini(at)areabusiness(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore whoes
Date: 2002-02-11 01:43:16
Message-ID: 25645.1013391796@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simone Tellini <tellini(at)areabusiness(dot)it> writes:
> here's a bit of data: the \connect you can see is at line 94382

Okay, the problem with this file is fairly obvious after looking at it
with od -c:

00000d0 \n \r \n \ c o n n e c t - p o
00000e0 s t g r e s \r \n C O P Y " i n
00000f0 t e r r o g a z i o n i " F
0000100 R O M s t d i n ; \r \n 9 7 \t 2
0000110 0 0 0 0 5 1 2 \t B a n c a I n
0000120 t e s a e C e n t r o C o
0000130 n t a b i l e C o m i t d i
0000140 P a r m a \t 4 \t V E R B A L E
0000150 D E L C O N S I G L I O C
0000160 O M U N A L E \r \ \r \n S E D U
0000170 T A D E L 1 2 M A G G I O

The newlines in the file have been translated to \r\n, which messes up
the backslash escaping. It looks to me like the string data that was
originally dumped contained CR/LF newline sequences (\r\n), which
would have been emitted by COPY as \r\\n (ie, carriage return,
backslash, newline). What's coming back in is carriage return,
backslash, carriage return, newline --- so the backslash uselessly
quotes the second carriage return and the newline is taken as the end
of the line of COPY data. I see a result like so:

psql:tellini.sql:11: ERROR: copy: line 2, pg_atoi: error in "SEDUTA DEL 12 MAGG
": can't parse "SEDUTA DEL 12 MAGGIO 2000
psql:tellini.sql:11: lost synchronization with server, resetting connection

I suppose you are working under Windows, or have copied the file into
Windows at some point. You need to find a way to avoid corrupting the
data file with Windows newline conversion.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-11 02:34:18 Re: user to database restriction?
Previous Message Jon August 2002-02-11 01:14:16 Re: user to database restriction?