| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: rotatelog / logrotate with PostgreSQL |
| Date: | 2002-09-26 00:47:57 |
| Message-ID: | 20020926004757.GC5706@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 25, 2002 at 08:58:22AM -0600, scott.marlowe wrote:
> Well, I've found the syslog facility to be noticeable slower than
> rotatelogs with pgsql doing its own logging. So that's why I do it the
> rotatelogs way. Choice is good.
One thing to be careful of is to put a hyphen before the filename in the
syslog config. This will stop syslog doing a sync() after *every* message,
which quite noticably kills performance. Also make sure it's only logging to
the logs you want and not to multiple files.
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2002-09-26 01:26:21 | Re: [GENERAL] New PostgreSQL Tool available : |
| Previous Message | Marc G. Fournier | 2002-09-26 00:26:37 | [URGENT] Need large installations of mission critical uses of PgSQL |