Re: Almost all access to database hangs (fwd)
От | Sven Fischer |
---|---|
Тема | Re: Almost all access to database hangs (fwd) |
Дата | |
Msg-id | 01040516374604.10595@fischer обсуждение исходный текст |
Ответ на | Re: Almost all access to database hangs (fwd) (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Am Donnerstag, 5. April 2001 16:23 schrieb Tom Lane: > "Oliver Elphick" <olly@lfix.co.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@gmx.de
В списке pgsql-general по дате отправления: