crash creating tsearch2 index
От | John DeSoi |
---|---|
Тема | crash creating tsearch2 index |
Дата | |
Msg-id | 71DE552E-7F5A-4A8A-9EED-B59D31D9B63E@pgedit.com обсуждение исходный текст |
Ответы |
Re: crash creating tsearch2 index
|
Список | 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 по дате отправления: