scripts/surveillance/maintenance/delete.sql

6 lines
320 B
SQL

-----------------------------------------------------------------
-- Maintenance de la base pgsql filtrage sur odlyd, lancé par cron
-----------------------------------------------------------------
-- effacement des vieux enregistrements
DELETE FROM upload where stamp_inserted < timestamp 'now' - interval '5 days';