Broken pg_class table

Поиск
Список
Период
Сортировка
От Roger Ging
Тема Broken pg_class table
Дата
Msg-id 44B7FCA1.40006@musicreports.com
обсуждение исходный текст
Ответы Re: Broken pg_class table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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?



В списке pgsql-admin по дате отправления:

Предыдущее
От: Satya Prakash Tripathi
Дата:
Сообщение: Re: Fwd: PITR- timeline query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Broken pg_class table