| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>, PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>, Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] syslog slowing the database? |
| Date: | 2004-03-11 04:09:41 |
| Message-ID: | 15549.1078978181@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> You could also consider not using syslog at all: let the postmaster
>> output to its stderr, and pipe that into a log-rotation program.
>> I believe some people use Apache's log rotator for this with good
>> results.
> Not an option I'm afraid. PostgreSQL just jams and stops logging after
> the first rotation...
I know some people use this in production. Dunno what went wrong in
your test, but it can be made to work.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-03-11 09:02:31 | Re: Explain Analyze help |
| Previous Message | karthikeyan | 2004-03-11 03:56:55 | How to unsubcribe from this list ??? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pablo Marrero | 2004-03-11 13:54:03 | started Data Warehousing |
| Previous Message | Bruno Wolff III | 2004-03-11 02:03:46 | Re: [PERFORM] syslog slowing the database? |