Database just stopped working. HELP
От | Steve Heaven |
---|---|
Тема | Database just stopped working. HELP |
Дата | |
Msg-id | 3.0.1.32.20001214085659.007478a4@mail.thornet.co.uk обсуждение исходный текст |
Ответ на | Re: Problem with pg_hba.conf (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
One of the databases on our server has simply stopped. All the other dBs on that server are unaffected. No psql commands work, not even simple things like \d. A vaccumdb --verbose produces the output below and then just locks up. It doesnt seem to be in a loop as its not soaking up CPU power. This Db has been working fine until now. Any help would be _gratefully_ appreciated Steve NOTICE: --Relation pg_type-- NOTICE: Pages 3: Changed 0, Reapped 1, Empty 0, New 0; Tup 148: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 66, MinLen 105, MaxLen 109; Re-using: Free/Avail. Space 74 56/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. NOTICE: Index pg_type_typname_index: Pages 8; Tuples 148: Deleted 0. Elapsed 0/ 0 sec. NOTICE: Index pg_type_oid_index: Pages 5; Tuples 148: Deleted 0. Elapsed 0/0 se c. NOTICE: --Relation pg_attribute-- NOTICE: Pages 10: Changed 0, Reapped 1, Empty 0, New 0; Tup 755: Vac 0, Keep/VT L 0/0, Crash 0, UnUsed 25, MinLen 97, MaxLen 100; Re-using: Free/Avail. Space 25 72/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. NOTICE: Index pg_attribute_attrelid_index: Pages 27; Tuples 755: Deleted 0. Ela psed 0/0 sec. NOTICE: Index pg_attribute_relid_attnum_index: Pages 33; Tuples 755: Deleted 0. Elapsed 0/0 sec. NOTICE: Index pg_attribute_relid_attnam_index: Pages 76; Tuples 755: Deleted 0. Elapsed 0/0 sec. NOTICE: --Relation pg_proc-- NOTICE: Pages 21: Changed 0, Reapped 0, Empty 0, New 0; Tup 1021: Vac 0, Keep/V TL 0/0, Crash 0, UnUsed 0, MinLen 145, MaxLen 197; Re-using: Free/Avail. Space 0 /0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec. NOTICE: Index pg_proc_prosrc_index: Pages 7; Tuples 1021. Elapsed 0/0 sec. NOTICE: Index pg_proc_proname_narg_type_index: Pages 17; Tuples 1021. Elapsed 0 /0 sec. NOTICE: Index pg_proc_oid_index: Pages 5; Tuples 1021. Elapsed 0/0 sec. -- thorNET - Internet Consultancy, Services & Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
В списке pgsql-general по дате отправления: