Re: [7.0.2] rotating log files ...

* The Hermit Hacker <scrappy@hub.org> [000828 11:19] wrote:
>
> can someone recommend on how to rotate the following log files without
> having to stop/start the server?
>
> postgres 85333 pgsql    1w  VREG  13,131084       995 762037 /pgsql/logs/postmaster.5432.61308
> postgres 85333 pgsql    2w  VREG  13,131084 316501241 762038 /pgsql/logs/5432.61308
>
> its the 316meg one and growing that I'm more interested in doing, obviously ...

This may not work: make a copy of it and try running a program that
calls ftruncate() on the file.

I think postgresql needs some utility to do this, I may whip one up when
time allows, it should be trivial.

-Alfred