| From: | John DeSoi <desoi(at)pgedit(dot)com> | 
|---|---|
| To: | "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | crash creating tsearch2 index | 
| Date: | 2007-05-26 13:46:23 | 
| Message-ID: | 71DE552E-7F5A-4A8A-9EED-B59D31D9B63E@pgedit.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-05-26 14:52:23 | Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2 | 
| Previous Message | Gerhard Wiesinger | 2007-05-26 10:58:08 | Re: Tools for dumping pg_xlog, pg_clog, etc? |