2009/11/19 Tech 2010 <tch...@gmail.com>: > On 18 nov., 16:48, Tech 2010 <tch...@gmail.com> wrote: >> On 18 nov., 13:40, thombr...@gmail.com (Thom Brown) wrote:> 2009/11/18 Tech >> 2010 <tch...@gmail.com>: >> >> > > Hello! >> >> > > How do I location of this pointer and how do I zero it so I can access >> > > the rest of the data? >> >> > > "zero_damaged_pages = true" did not help in this case, because I >> > > always get same numbers being zeroed. This is with 8.4.0 and 8.4.1. >> >> > > Thanks. >> >> > You probably just need to reindex a table. Try vacuuming each table >> > individually until you get this error, or just check the vacuum log >> > output to identify it, then just run a REINDEX on it. >> >> xy=# reindex table xy_data; >> ERROR: concurrent insert in progress > > Should I drop and recreate indexes? >
That might be a good idea. Use the CREATE INDEX CONCURRENTLY command to prevent that previous error message from appearing. Regards Thom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
