I need to connect to a remote postgreSQL database own by another person
Through a GUI I get the error in the following screenshot
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