Re: Cannot rename init file

Russell,

On Mon, Sep 24, 2001 at 10:05:52AM -0600, Russell Black wrote:
> From: "Jason Tishler" <jason@tishler.net>
> > BTW, are your running vacuumdb under cron or just at the command line?
>
> I'm running vacuumdb from cron every morning at 3 AM.

Please see if you can reproduce the problem from the command line.  I
have seen some "issues" with cron that I trying to track down myself.
Since cron is switching user context via NT's security APIs maybe it is
cause you some permission problems.

> How often should I run vacuumdb?  What exactly does it do?

Sorry, I'm not qualified to answer the above.  To be honest, I'm not very
experienced with PostgreSQL.  I just submitted some patches to get 7.0.2
to build under the Cygwin Net Release and the rest is history...  :,)

> In the above link, Tom Lane said
> "The first backend to fire up after a vacuum will try to rebuild
> pg_internal.init, and then move it into place."
> Perhaps I should restart my jboss server every time I run vacuumdb, so the
> files will be released.

The above sounds like a reasonable workaround -- stop jboss right before
the nightly vacuumdb.  But, it would be much better to understand why
the rename is failing before resorting to workarounds.  If this is truly
a problem in Cygwin, then we should try to get it fixed.  Since I can no
longer reproduce the problem, I cannot attempt to debug it.

Thanks,
Jason