How to create a time-driven trigger in postgresql

Question

I have a table in my database (postgres), that keeps in it the user accounting trace. I need to create a trigger that will perform a clean up at a given amount of time (let's say 30 minutes.) Is it possible to do that from postgres, or do I need to use something else? (By something else I mean C or Java or any other programming language that can sleep for a given time).

Thanks for link, but I don't know how to insatll pgAgent in my machine (I'm running Centos6.2) — artaxerxe
– artaxerxe, Commented Mar 21, 2012 at 13:00

wildplasser · Accepted Answer · 2012-03-21 13:44:03Z

3

Without PgAgent, things like this can be done using a cron script.

In both cases the periodic thing will be running from a different context (database owner, superuser, postgres), and in a separate transaction, obviously.

edited Mar 21, 2012 at 13:44

answered Mar 21, 2012 at 13:20

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a time-driven trigger in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related