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.