Heroku: rogue transfer in progress

You can remove the problem backup stuck in the "a transfer is currently in progress" by finding the name of the backup and then destroying it. E.g.

heroku pgbackups

My problem backup was listed like this:

b210 | 2013/01/02 12:29.33 | unknown | DATABASE_URL

So to destroy it I just did:

heroku pgbackups:destroy b210

It removed the problem backup for me so I could get on with using pgbackups again properly.

I just had this problem too. Found an easier way of fixing it - briefly remove the pgbackups addon.

heroku addons:remove pgbackupsheroku addons:add pgbackups

WARNING as mentioned in the comments below, this will destroy all extant backups!

I accidentally did a transfer from my COLOR_URL database to my DATABASE_URL which was the same database. heroku pgackups:transfer let this happen which caused the main database to get stuck in

a transfer is currently in progress

I fixed it by looking at the process list pg:ps and killing all connections pg:killallAfter doing this and looking at pg:ps the process list was empty and I was free to use the main database again with pgbackups.

NOTE this could be a destructive operation so make sure you have a snapshot before you do this.