execute on log_rotation - Mailing list pgsql-hackers

From Jaime Casanova
Subject execute on log_rotation
Date
Msg-id 3073cc9b0907141911x5f59f4aegc8ca930daf9b9bf3@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hi,

I was thinking that could be useful to have a guc to indicate some
command to execute on rotation of logs (ok, i'm not inventing "warm
water" here, but...).
it could be useful for:
- load data from a csvlog to a table
- execute some magic to analyze logs
- archive logs (compress, move to another site, etc)
- other things i haven't thinked of

yes, we can create a cron for that but doing it at rotation time is
good because we don't need to complicate scripts to try to find if
there is some log not processed we know there is... and exactly wich
one...

if people i agree i will try this... after the commitfest, of
course... but i ask now because my memory is a lot worst every single
day...

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: navigation menu for documents
Next
From: Itagaki Takahiro
Date:
Subject: Re: Sampling profiler updated