[Solved] Strange error when logging in via Datagrip (Remote Postgres)

[fudobi]

Hey guys,

I have remote access enabled in my databases and I have always been able to read and write via script and connect via Datagrip or similar software.

Starting yesterday, I am able to remotely write on the DB via script. But I can't seem to be able to connect to my databases nor from Datagrip, or Metabase which I use to analyze data.

This error appears for example:

Can you please help me here? Same happens for all DBs in my user.

Thanks a lot,

Francisco

[wolstech]

That error means remote access isn't set up, so it either was removed for some reason, or perhaps it was never configured for IPv6 (I believe that's been an issue in the past).

Krydos can fix it.

[fudobi]

Ah... ok. Thanks a lot.

I did have remote access in all of my DBs as discussed here (

)

Please if you can re enable it @Krydos would much appreciate it.

Thanks a lot guys,

Francisco

 

[Krydos]

Remote access is already enabled for that database and user. Here is the values you should be using.

host=65.19.154.90
port=5432
user=fudobi_admin_viaviva
dbname=fudobi_viaviva
password=<set in Plesk>

I'm guessing you're using the wrong host.