logfile rotation

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: logfile rotation
Date: 2004-06-13 16:43:20
Message-ID: 40CC8428.3090602@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom doesn't like returning the server's logfile using a pgsql function

unless logfile rotation is implemented, so here it is.

This proposal doesn't include a daemon that triggers pg_logfile_rotate
when appropriate (timestamp and/or length dependent), pg_autovacuum
might be a good place to do that.

I'd also like to see a table pg_logfile which contains all logfile
names, to be able to access older logfiles.

Comments?

Regards,
Andreas

Attachment Content-Type Size
logfile.diff text/plain 18.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-13 17:03:27 Re: logfile rotation
Previous Message Bruce Momjian 2004-06-13 14:09:30 Re: Nested transactions and tuple header info