On 19 nov., 16:36, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> Tech 2010 <tch(dot)(dot)(dot)(at)gmail(dot)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.