Ticket #211 (closed defect: fixed)

Opened 5 years ago

Last modified 5 years ago

old unsaved graphs not being delete.

Reported by: jesus Assigned to: jesus
Priority: minor Milestone: Intrigue
Component: database Severity: annoying
Keywords: Cc:

Description

{{{01 00 * * * /opt/pgsql835/bin/psql -d reconnoiter -c "delete from prism.saved_graphs where saved = false and last_update<current_timestamp - '1 day' ::interval;" 1>/dev/null}}}

psql command is missing a user to run as. It tried to run as root and fails on my system. Fix is to use "-U reconnoiter", the same as all the other jobs.

Change History

11/05/09 17:56:25 changed by jesus

  • status changed from new to closed.
  • resolution set to fixed.

(In [1068]) fixes #211