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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073