Home > Software design >  Connexion to a remote PostgreSQL database works in command line but not through GUI
Connexion to a remote PostgreSQL database works in command line but not through GUI

Time:10-19

I need to connect to a remote postgreSQL database own by another person

Through a GUI I get the error in the following screenshot

GUI error

I told them to check if they allows remote access to their database and indeed they do.

What i don't understand is that I can access the database through command line without error

C:\Users\François CHIV>psql -h xxx -U xxx -d d70xxx
Mot de passe pour l'utilisateur xxx :
psql (14.5, serveur 13.8 (Ubuntu 13.8-1.pgdg20.04 1))
Attention : l'encodage console (850) diffère de l'encodage Windows 
(1252).
    Les caractères 8 bits peuvent ne pas fonctionner correctement.
    Voir la section « Notes aux utilisateurs de Windows » de la 
    page référence de psql pour les détails.
Connexion SSL (protocole : TLSv1.3, chiffrement : TLS_AES_256_GCM_SHA384, bits : 256, compression : désactivé)
Saisissez « help » pour l'aide.

d7xxx=>

Is there some steps I'm missing ? I have never connecting to a remote database that is why i need your expertise

The driver used is this one https://www.devart.com/dotconnect/postgresql/

CodePudding user response:

The problem is clear: There is no entry in pg_hba.conf for user

  • Related