| From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [7.0.2] rotating log files ... |
| Date: | 2000-08-28 18:27:38 |
| Message-ID: | 20000828112738.U1209@fw.wintelcom.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
* The Hermit Hacker <scrappy(at)hub(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alfred Perlstein | 2000-08-28 18:30:30 | Re: [7.0.2] rotating log files ... |
| Previous Message | Mitch Vincent | 2000-08-28 18:26:32 | Re: [7.0.2] rotating log files ... |