dump/restore problem

From: Andrei Ivanov <andrei(dot)ivanov(at)ines(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: dump/restore problem
Date: 2004-01-13 20:19:42
Message-ID: Pine.LNX.4.58L0.0401132212280.2355@webdev.ines.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-01-13 20:42:02 Re: Best practice? Web application: single PostgreSQL
Previous Message Daniel E. Fisher 2004-01-13 19:26:01 Error since powerouttage