Re: rotatelog / logrotate with PostgreSQL

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: rotatelog / logrotate with PostgreSQL
Date: 2002-09-24 20:52:11
Message-ID: Pine.LNX.4.33.0209241448450.1889-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 23 Sep 2002, Johnson, Shaunn wrote:

> Howdy:
>
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7.
>
> Can someone send an example of how they have the
> logrotate / rotatelog script working with PostgreSQL?
> I'm looking at a few things and I can't seem to
> get it to work.
>
> Also, is there an easy way to tell if PostgreSQL have
> been configured with "--enable-syslog"? If I have that,
> then I can just use the syslog.conf and collect logs
> that way.

My rc.local line looks something like this:

su - postgres -c 'pg_ctl start | rotatelogs $PGDATA/pglog 86400 2>1&'

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roland Roberts 2002-09-24 21:48:21 Re: [SQL] CURRENT_TIMESTAMP
Previous Message Robert Treat 2002-09-24 20:14:12 Re: Postmaster Uptime