Re: Almost all access to database hangs (fwd)

Am Donnerstag, 5. April 2001 16:23 schrieb Tom Lane:
> "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
> >> However, if \dt hangs, the problem is probably in a system index;
> >> pg_class has two indexes: pg_class_oid_index and
> >> pg_class_relname_index.
> >
> > I can do a select * on pg_class, but that's it. Anything else I tried
> > hangs.
>
> Sounds like a job for REINDEX. I have not had to do this myself, but
> I think the procedure is (a) stop postmaster, (b) start a standalone
> backend with -O -P, (c) tell it to REINDEX DATABASE. Not sure about
> that, especially about the switches to start the backend with. Read
> the documentation.

Read the documentation, made the reindex (reindex database etcs)...
...same symptoms.

Any additional things to reindex? Other hints?

Greetings, Sven

--
Sven Fischer -- Mülheimer Str. 133, 51469 Bergisch Gladbach, Germany
Tel.: +49-(0)2202-458799 Fax.: +49-(0)89-244310437
sepreh(at)gmx(dot)de