deeejay icon

PostgreSQL - Truncate old csv logs

deeejay | PRO | 04/08/16 06:21:35 PM UTC | 0 ⭐ | 271 👁️ | Never ⏰ | []
PostgreSQL |

280 B

|

None

|

0 👍

/

0 👎

Change directory to PostgreSQL version and pg_log (or where you store the log files)
===
cd /var/lib/pgsql/9.3/data/pg_log/
 
List CSV logs older than 29 days
===
find *.csv -mtime +29 -exec ls {} \;
 
Truncate CSV logs older than 15 days
===
find *.csv -mtime +15 -exec rm {} \;

Comments