Re: dump/restore problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrei Ivanov <andrei(dot)ivanov(at)ines(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump/restore problem
Date: 2004-01-14 01:15:41
Message-ID: 15992.1074042941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrei Ivanov <andrei(dot)ivanov(at)ines(dot)ro> writes:
> 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

The "invalid byte sequence" problem occurs because you are trying to
load data that isn't valid UNICODE. You need to fix the data.

I'm more interested in the "invalid memory alloc request" messages,
myself. Could you show us the sections of the dump file that trigger
those errors?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dustin Sallings 2004-01-14 01:35:56 Re: serverless postgresql
Previous Message Jeff Bowden 2004-01-14 00:40:19 Re: serverless postgresql