Re: Renaming a DB

Oh, I forgot that the backends are reading the raw disk files to find
database names.  Thanks.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Tom, why was a VACUUM FULL required?
>
> I doubt that it was; a VACUUM would have sufficed to fix the tuple
> commit bits.  What I forgot to recommend was a CHECKPOINT to make
> sure the fixed pages got dumped to disk.  (Until they're written
> out to the kernel, a new backend would still see the old pages
> when it's doing the GetRawDatabaseInfo cruft.)
>
> I think a VAC FULL would have flushed dirty pages, but a plain VACUUM
> wouldn't, so VAC FULL is a second way of getting the result.
>
>             regards, tom lane
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073