Heroku pg: backup fails "

Question

This kind of arbitrary rejection seems to be part of the learning curve of Rails applications, so I apologize for such a simple question, but: " heroku pgbackups:capture " is just ... unsuccessful. That is, I grabbed the URL of my Postgresql database onto the hero, then pasted it into:

% heroku pgbackups: capture postgres: // <secret rest of db URL>

... and get the following answer:

Database on ec2-50-19-215-116.compute-1.amazonaws.com ---- backup ---> b003

Awaiting ... \

! An error occurred and your backup did not complete.

Useful, huh? Any tips on how I can discuss this? Thanks for the help with the naive question.

Steve upstill

Answer 1

If this fails, contact the support service - there cannot be a huge amount.

Answer 2

In my case, the problem was that the number of connections for my database was exhausted. I was on a db hobby that has a maximum of 20 simultaneous connections, and they were all in use. I was able to successfully start the backup after releasing some connections (which you can do, for example, by setting up connection pools or closing some nodes).

You can see the number of connections of your db through the pg extension user interface:

Answer 3

Make sure you are using the latest Heroku command-line tool:

 $ heroku update 

then reinstall the add-in:

 $ heroku addons:add pgbackups 

then fix the backup of your main database (without specifying the database path from the local localization branch on the local computer):

 $ heroku pgbackups:capture