Search Postgresql Archives

Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 19 nov., 16:36, t...@xxxxxxxxxxxxx (Tom Lane) wrote:
> Tech 2010 <tch...@xxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux