dump/restore problem - Mailing list pgsql-general

From Andrei Ivanov
Subject dump/restore problem
Date
Msg-id Pine.LNX.4.58L0.0401132212280.2355@webdev.ines.ro
Whole thread Raw
Responses Re: dump/restore problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello,

I have a dump created with pg_dump ver 7.4.1 from a postgres 7.4 database,
with encoding SQL_ASCII.
I'm trying to import this dump in a 7.4.1 postgres database with encoding
UNICODE, but I'm getting some errors:

psql:dump.sql:1277: ERROR:  invalid memory alloc request size
1073741824
psql:dump.sql:3490: ERROR:  invalid byte sequence for encoding
"UNICODE": 0xce20
CONTEXT:  COPY products, line 1, column ldesc: "<li>capacitate de spalare
5 kg^M
<li>viteza de centrifugare 800 rpm^M
<li>18 programe variate de spala..."
psql:dump.sql:5414: ERROR:  invalid memory alloc request size
1073741824
psql:dump.sql:5577: ERROR:  invalid byte sequence for encoding
"UNICODE": 0xd650
CONTEXT:  COPY feedback, line 26, column comments: "Stimata Doamna/Domn,^M
^M
As dori sa achizitionez un aparat de tuns Philishave HQC888, pe care, cu
toa..."


What can I do ?

Thanks.

pgsql-general by date:

Previous
From: "Daniel E. Fisher"
Date:
Subject: Error since powerouttage
Next
From: John Allgood
Date:
Subject: Testing Email