Quick Links

Re: [PERFORM] syslog slowing the database?

From:	Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 01:34:54
Message-ID:	404FC23E.9000207@familyhealth.com.au
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-performance

> 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've read in the docs that syslog logging is the only "production"
solution...

Chris

In response to

Re: syslog slowing the database? at 2004-03-10 16:53:51 from Tom Lane

Responses

Re: [PERFORM] syslog slowing the database? at 2004-03-11 01:37:38 from Chris Smith
Re: [PERFORM] syslog slowing the database? at 2004-03-11 02:03:46 from Bruno Wolff III
Re: [PERFORM] syslog slowing the database? at 2004-03-11 04:09:41 from Tom Lane
Re: [ADMIN] syslog slowing the database? at 2004-03-14 16:00:18 from Andrew Sullivan
Re: [PERFORM] syslog slowing the database? at 2004-03-15 15:17:49 from scott.marlowe

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Chris Smith	2004-03-11 01:37:38	Re: [PERFORM] syslog slowing the database?
Previous Message	Vivek Khera	2004-03-10 21:00:36	Re: syslog slowing the database?

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Chris Smith	2004-03-11 01:37:38	Re: [PERFORM] syslog slowing the database?
Previous Message	Joseph Shraibman	2004-03-11 00:43:57	Re: Postgresql on SAN