Restarting Heroku database

Question

I'm runnning a rails app on heroku with a postgres database hosted by Amazon. I tried a migration that would never end (over 40 minutes) and ran it a few too many times. Now I have 20 connections open to the database, which is the maximum, and no idea how to close those connections.

What can I do?

Please take a look here: http://stackoverflow.com/a/11951744/139687 — berislavbabic, Oct 17 '13 at 19:02
@babinho, I already saw that. It's not a matter of my application holding on to connections so the first part doesn't help. And since I'm already at my max number of connections, I can't run the sql from the second half of the answer to close connections. — Anthony DeSimone, Oct 17 '13 at 19:07
The last thing i can think of is `heroku ps:scale web=0` to turn off your web dynos, and then `heroku ps:scale web=1` but you can do that from the web UI too — berislavbabic, Oct 17 '13 at 19:14
Yea I tried doing that as well. It's seems to be a completely separate issue from the dynos though. — Anthony DeSimone, Oct 17 '13 at 19:16
if you have a postgres database hosted by amazon. connect to that amazon database server and restart it. what does have heroku todo with that? — phoet, Oct 17 '13 at 21:15
@phoet, agreed. How can I access the ec2 database through AWS that Heroku created for me? — Anthony DeSimone, Oct 17 '13 at 21:23

score 5 · Answer 1 · answered Oct 18 '13 at 21:47

5

If you database is on heroku then you can kill all database connections using a heroku plugin

heroku-pg-extras

pg:killall [DATABASE]  #  terminates ALL connections

To you above command you need to install heroku-pg-extra plugin

answered Oct 18 '13 at 21:47

arunagw

1,193
6
8

1

Just as a note it looks like pg:killall was removed from pg extras – ScottJShea Jul 16 '15 at 17:50
2

(Seems like more than just a note) – deepelement Dec 04 '15 at 21:41

Restarting Heroku database

1 Answers1