Joe Conway <mail(at)joeconway(dot)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:
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Philip Warner||Date: 2005-12-03 00:35:04|
|Subject: Re: Optimizer oddness, possibly compounded in 8.1|
|Previous:||From: Joe Conway||Date: 2005-12-03 00:17:23|
|Subject: Re: strange behavior (corruption?) of large production|