deeejay

PostgreSQL - Truncate old csv logs

Apr 8th, 2016
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Change directory to PostgreSQL version and pg_log (or where you store the log files)
  2. ===
  3. cd /var/lib/pgsql/9.3/data/pg_log/
  4.  
  5. List CSV logs older than 29 days
  6. ===
  7. find *.csv -mtime +29 -exec ls {} \;
  8.  
  9. Truncate CSV logs older than 15 days
  10. ===
  11. find *.csv -mtime +15 -exec rm {} \;
Add Comment
Please, Sign In to add comment