Re: dump/restore problem

Поиск
Список
Период
Сортировка
От Andrei Ivanov
Тема Re: dump/restore problem
Дата
Msg-id Pine.LNX.4.58L0.0401140947160.2355@webdev.ines.ro
обсуждение исходный текст
Ответ на Re: dump/restore problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: dump/restore problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
You will find more info attached.

What about the invalid UNICODE data ? How can I fix it ? In the attachment
there is the line that gives the error...

Thanks.

On Tue, 13 Jan 2004, Tom Lane wrote:

> Andrei Ivanov <andrei.ivanov@ines.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
>

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Optimising SQL Queries?
Следующее
От: Anton.Nikiforov@loteco.ru
Дата:
Сообщение: Re: Postgress and MYSQL