var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Auto Truncate
Have Postgresql setup for a simple log capture database. Anyone know how to tell the program to automatically truncate entries that are older than 30 days?
My logging software cannot do it and I'd like to do this at the DB automatically.
What OS are you using?
For eample if it's Linux/Unix -- you could create a cron job and schedule once a day, every day it to call your sql script that deletes rows > 30 days.
If it's windows use a scheduled task to call your sql delete script.
Alternatively, use a tool like pgAgent:
Last edited by marc_; 09-01-11 at 11:25.
Reason: Added links
Great! Got it to work perfect with PGAgent.
No worries - Glad it worked for you