* 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