Re: [ADMIN] [7.0.2] rotating log files ...

[Alfred Perlstein]

* The Hermit Hacker <[EMAIL PROTECTED]> [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