Results 1 to 3 of 3

Thread: Auto Truncate

  1. #1
    Join Date
    Aug 2011
    Posts
    3

    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.

  2. #2
    Join Date
    Mar 2011
    Posts
    27
    The only automatic way you can do something like this is with triggers or scheduled scripts. For archiving old data, I would recommend using a script to delete them.

  3. #3
    Join Date
    Aug 2011
    Location
    Glasgow, UK
    Posts
    36

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •