If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
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.
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.