Am Donnerstag, 5. April 2001 16:23 schrieb Tom Lane: > "Oliver Elphick" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly