crash creating tsearch2 index

Поиск
Список
Период
Сортировка
От John DeSoi
Тема crash creating tsearch2 index
Дата
Msg-id 71DE552E-7F5A-4A8A-9EED-B59D31D9B63E@pgedit.com
обсуждение исходный текст
Ответы Re: crash creating tsearch2 index  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-general
Hi,

I'm trying to dump and restore a copy of a database in the same
cluster. pg_restore would abort when creating a tsearch2 gist index.
So I dumped to text removed the CREATE INDEX commands and tried to do
that at the end after the rest of the database was loaded. I still
have the same problem:

CREATE INDEX song_tsx_title_idx ON song USING gist (tsx_title
public.gist_tsvector_ops);
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

This is pg 8.0.8 in a shared hosting environment, so I don't have a
lot of options for tweaking. Is there a known work-around for this?

Thanks,




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


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

Предыдущее
От: Gerhard Wiesinger
Дата:
Сообщение: Re: Tools for dumping pg_xlog, pg_clog, etc?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2