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