It shows following when I try to reindex:
snort=# reindex index ip_src_idx;
ERROR: concurrent insert in progress
So I think it might be hard disk problem as Tom suggested.
Unfortunately I don't have replacement hard disk now, so I guess
I might change the DB location for a while.
thanks,
Ganbo
use REINDEX
REINDEX ip_dst_idx
OR
REINDEX table_name
http://www.postgresql.org/docs/8.3/static/sql-reindex.html
tell us the result
thank
--- On Fri, 6/27/08, Ganbold <[EMAIL PROTECTED]> wrote:
From: Ganbold <[EMAIL PROTECTED]>
Subject: [GENERAL] ERROR: concurrent insert in progress
To:
use REINDEX
http://www.postgresql.org/docs/8.3/static/sql-reindex.html
tell us the result
thank
--- On Fri, 6/27/08, Ganbold <[EMAIL PROTECTED]> wrote:
From: Ganbold <[EMAIL PROTECTED]>
Subject: [GENERAL] ERROR: concurrent insert in progress
To: pgsql-general@postgresql.org
Date: Friday, Jun
Ganbold <[EMAIL PROTECTED]> writes:
> I have problem with my DB:
> ERROR: could not read block 988 of relation 1663/16384/16472:
> Input/output error
> How to solve this problem?
First, replace your failed disk; then get out your backups and restore
your system ...
reg
