Broken pg_class table
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Broken pg_class table
- From: Roger Ging <roger@xxxxxxxxxxxxxxxx>
- Date: Fri, 14 Jul 2006 13:20:49 -0700
- User-agent: Thunderbird 1.5.0.4 (Windows/20060516)
I accidentally wrecked the pg_class table in a database by leaving off
the where clause of an update statement when setting the reltriggers
back to the count from pg_trigger after a bulk data load. I can no
longer connect to the database, although it does start up without
error. running psql [dbname] causes extreme cpu load, and the command
just hangs. Memory usage continues climbing until a oom killer crashes
everything. I presume that my blunder is causing some sort of infinite
loop during postmaster startup for the spawned process. Is there a way
I can get direct access to the file for pg_class and reset the
reltriggers to the correct values without a full dbinit process?
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]