On 18 nov., 13:40, thombr...@xxxxxxxxx (Thom Brown) wrote: > 2009/11/18 Tech 2010 <tch...@xxxxxxxxx>: > > > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
