Re: strange behavior (corruption?) of large production database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: strange behavior (corruption?) of large production database
Дата
Msg-id 10027.1133569209@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: strange behavior (corruption?) of large production  (Joe Conway <mail@joeconway.com>)
Ответы Re: strange behavior (corruption?) of large production  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> You could try a VACUUM FREEZE on pg_database though.

> Since this is a production machine, putting pg_filedump on it may be 
> problematic -- if I grovel through the bits by hand, can you give me a 
> hint about what to look for?

How about you copy off the pg_database file to someplace where it's OK
to run pg_filedump?  Doing that by hand is mighty tedious.

BTW, forget the "FREEZE" part, just VACUUM:
http://archives.postgresql.org/pgsql-general/2005-11/msg00097.php
        regards, tom lane


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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: strange behavior (corruption?) of large production
Следующее
От: Philip Warner
Дата:
Сообщение: Re: Optimizer oddness, possibly compounded in 8.1