heroku_cloud_backup icon indicating copy to clipboard operation
heroku_cloud_backup copied to clipboard

Published 20 hours ago • verified publisher icon kamui

Pruning not working

Open kbaum opened this issue 12 years ago • 1 comments

Pruning did not seem to be working and I am not sure how it could have ever worked. Specifically i noticed that following code within prune was comparing an number and a string which failed:

if file_count > number_of_files

thx!

kbaum avatar Jun 04 '12 17:06 kbaum

So it looks like because i am doing the backups myself and also the heroku backup add on, there's a mixture of backups that it returns:

2012/05/15 20:02.13 DATABASE_URL
2012/05/22 20:02.14 DATABASE_URL
2012/05/29 20:02.18 DATABASE_URL
2012/06/06 20:02.18 DATABASE_URL
2012/06/13 20:02.19 DATABASE_URL
2012/06/19 20:02.36 DATABASE_URL
2012/06/21 20:02.42 DATABASE_URL
2012/06/22 20:02.25 DATABASE_URL
2012/06/23 20:02.43 DATABASE_URL
2012/06/24 20:02.25 DATABASE_URL
2012/06/25 20:02.35 DATABASE_URL
2012/06/26 20:02.33 DATABASE_URL
2012/06/27 01:54.25 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:04.25 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:14.26 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:24.26 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:34.20 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:44.32 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 02:54.30 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:04.25 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:14.36 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:24.31 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:34.39 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:44.20 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 03:54.21 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:04.27 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:14.21 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:24.32 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:34.32 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:44.25 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 04:54.27 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:04.27 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:14.22 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:24.17 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:34.19 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:44.21 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 05:54.23 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:04.28 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:14.22 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:24.22 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:34.23 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:44.26 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 06:54.22 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:04.22 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:14.33 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:24.19 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:34.33 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:44.26 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 07:54.26 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:04.23 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:14.21 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:24.29 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:34.18 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:44.27 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 08:54.25 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 09:04.28 HEROKU_POSTGRESQL_NAVY_URL
2012/06/27 09:14.22 HEROKU_POSTGRESQL_NAVY_URL
2012/05/15 20:02.13 DATABASE_URL
2012/05/22 20:02.14 DATABASE_URL
2012/05/29 20:02.18 DATABASE_URL
2012/06/06 20:02.18 DATABASE_URL
2012/06/13 20:02.19 DATABASE_URL
2012/06/19 20:02.36 DATABASE_URL
2012/06/21 20:02.42 DATABASE_URL
2012/06/22 20:02.25 DATABASE_URL
2012/06/23 20:02.43 DATABASE_URL
2012/06/24 20:02.25 DATABASE_URL
2012/06/25 20:02.35 DATABASE_URL
2012/06/26 20:02.33 DATABASE_URL

So in that query, the last database snap was taken at 2012/06/27 09:14 but if we dont sort, it will take from 2012/06/26.

HEROKU_POSTGRESQL_NAVY_URL is a follower of DATABASE_URL.

Sorry it's taken me so long to write back.

thx!

kbaum avatar Jun 27 '12 16:06 kbaum