Re: crash creating tsearch2 index

Could you provide a test suite?

John DeSoi wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/