Forums

I can't connect to my postgresql server

Hi,

I'm trying to connect to my postgresql with Datagrip but the tunnel ssh doesn't work?

When I use my terminal on my mac, the ssh access works.

Screenshot:

https://www.dropbox.com/s/kesl81ygtq1scs2/Capture%20d%27%C3%A9cran%202018-05-08%2015.42.18.png?dl=0

Can you confirm that I'm a paid user? I've paid today.

Thanks!

Btw, my database url is:

postgresql://xx:xx@swdating-759.postgres.pythonanywhere-services.com:10759

Now I have:

https://www.dropbox.com/s/jhzu4lpwbf0xqrz/Capture%20d%27%C3%A9cran%202018-05-08%2016.12.20.png?dl=0

I'm lost ;(

I suppose there's no database so far on my server? I don't know why it asks for a database

Apparently, you have to use template1 to make it work!

The connection is really not stable. I keep getting messages like:

" [08001] Connection to localhost:53465 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. java.net.ConnectException: Connection refused (Connection refused). Details "

https://www.dropbox.com/s/jhzu4lpwbf0xqrz/Capture%20d%27%C3%A9cran%202018-05-08%2016.12.20.png?dl=0

Screenshot of my error message

For your last error, it looks like you don't have a database called "super", which is what Postgres will try to connect to if you don't specify a database name. If you specify the name of your database, then it should work.