Forums

Restart Postgres database?

Hi,

I managed to crash my Postgres database (hosted on PythonAnywhere) and I can no longer access it.

Every time I try to start a Postgres console, I get the following error

psql: could not connect to server: Connection refused Is the server running on host "..." and accepting TCP/IP connections on port ****?

Is it possible to restart it myself or does it need a staff member to do it? If the latter, can someone please help?

Thank you!

Ok. I have re-activated your postgres database. Do you remember what you did to crash it?

Hi glenn,

thank for restarting the server. I assume that if this happens again, I can't restart it myself.

It crashed while I was trying to upload some data into the database via psql. It would appear that I used up all my storage (2GB at the time). I have since upgraded the available storage to 6GB and I hope I will be able to upload the data without a problem this time. I hope this was the problem and not something else :)

Thank you!

Thanks for the information. It could have been that.

This happened to my Postgres server as well. I don’t see any way to open a ticket or restart the server. I already sent an email to support@golfsmartacademy.com 8 hours ago but the server is still down please advise. Thanks.

I see that the email you sent to support@pythonanywhere.com has been handled now -- your server is up and running now.

hi i having now same issue

No problem. I have restarted your Postgres server for you.

Could I also have my postgres server restarted? same issue, I exceeded my posgre storage, then keep getting this error. i have since upgraded my account, would appreciate if the server could be restarted.

Hello I would also like a reset to my Mysql server, if possible. Thank you

@Bugy What do you mean by that and what problem do you want to solve that way?

I had a bug in the code that kept creating new connections. Now I can't connect to the SQL server anymore as the connections don't seem to timeout

OK -- there were a few inactive connections associated with your account on the server, so I've killed them.

hello

is there any way to get service faster ?

i am a paid user, my postgres service is not working some table.

I tried to truncate one table which is not loading. please help me to get rid of this issue or else i have to forcefully shift my app to somewhere with another provided. because here i can't found any direct contact for issue

I believe we already replied you via email -- let's continue our conversation there.

same here my server not working

Hey eyeclinic, I've restarted your database. Have a good one

I have same issue

@ziadsindion I've restarted your postgres instance.

hey, the same problem! can you help me?

@Azamatov You do not have postgres.