Project

General

Profile

Bug #5472

Filesystems filling up with postgres backup files

Added by Robert Waltz over 10 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Robert Waltz
Category:
d1_cn_buildout
Target version:
Start date:
2014-06-10
Due date:
2014-07-05
% Done:

100%

Milestone:
CCI-1.2
Product Version:
*
Story Points:
Sprint:

Description

/etc/cron.daily/pgsql script runs everyday and dumps a postgres backup to /var/postgres-bak

These dumps eventually fill up /var on the machines it is run and cause failures.

edit the /etc/cron.daily/pgsql to rotate its files only keeping month worth of dumps.

The dump from the first day of each month should be placed in a separate directory /var/postgres-bak/monthly.

monthly dumps should only be retained for 13 months at most. Each dump from the beginning of the year should be moved to /var/postgres-bak/yearly

Associated revisions

Revision dd3264d6
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13949
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13949
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13949
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 9eebe138
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13950
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13950
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision 13950
Added by Robert Waltz over 10 years ago

refs #5472

create pgsql files for montly and daily cron jobs that will rotate and delete pgdump files

Revision b9a863f8
Added by Robert Waltz over 10 years ago

refs #5472 Filesystems filling up with postgres backup files

Revision 14055
Added by Robert Waltz over 10 years ago

refs #5472 Filesystems filling up with postgres backup files

Revision 14055
Added by Robert Waltz over 10 years ago

refs #5472 Filesystems filling up with postgres backup files

History

#1 Updated by Robert Waltz over 10 years ago

  • Status changed from New to In Progress

#2 Updated by Robert Waltz over 10 years ago

  • Status changed from In Progress to Testing

#3 Updated by Robert Waltz over 10 years ago

  • Due date changed from 2014-06-21 to 2014-07-05
  • Target version changed from 2014.24-Block.3.4 to 2014.26-Block.4.1

#4 Updated by Robert Waltz over 10 years ago

  • Status changed from Testing to Closed

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)