Hi Kevin, Thanks for this. I've found a lot of information on this online but I'm a little unclear about how exactly I should connect and run the reindex.
My thinking based on the documentation is I run (as postgres user): postgres -O -P -D /dbcluster/location Then I run: REINDEX TABLE pg_class_oid_in; Is this correct? Nate On Wed, Jun 30, 2010 at 11:51 AM, Kevin Grittner < [email protected]> wrote: > Nathan Robertson <[email protected]> wrote: > > > The failure basically happened because the Django webapp we're > > running isn't effectively closing database connections. So, memory > > is completely filling up and causing the server to hang. > > Yesterday, when this happened it caused the entire network > > interface to become inoperable which meant that the iscsi > > connection to the shared drive stopped working and data became > > corrupt. > > > > I stopped the postgresql service before unmounting and remounting > > the target. > > OK, I think the appropriate next step would be to try to run the > PostgreSQL cluster in single-user mode: > > http://www.postgresql.org/docs/8.1/interactive/app-postgres.html > > Try to REINDEX pg_class_oid_index in that mode. If that fails, it > might possibly help to run these statements and try the REINDEX > command again: > > set enable_indexscan = off; > set enable_bitmapscan = off; > > I hope this helps. > > -Kevin >
