On 19 nov., 16:36, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Tech 2010 <tch...@gmail.com> writes:
> >> xy=# reindex table xy_data;
> >> ERROR: concurrent insert in progress
> > Should I drop and recreate indexes?
>
> I think that database is pretty well hosed. (What happened to it to
> cause all this, anyway?) A dump/initdb/reload is probably indicated
> at this point.
reindex did not help. pg_dump crashes and select * into new_tables
crashes as well. Any idea?
Thanks.