martinca Posted May 9, 2019 Share Posted May 9, 2019 Goodnight.My username is martinca1 and I have created a database martinc1_testsystel to which I want to connect from an external service (PGADMIN) using the user martinc1_mcasalis.The problem is that it rejects me, for the following error: FALAT: no pg_hba.conf entry for host 186.153.132.122, user martinc1_mcasalis, database martinc1_testsystel, SSL off.Can you help me configure pg_hba.conf so that it has external access?Thank you. Link to comment Share on other sites More sharing options...
wolstech Posted May 9, 2019 Share Posted May 9, 2019 Krydos can set this up for you. Let's see... Link to comment Share on other sites More sharing options...
Krydos Posted May 9, 2019 Share Posted May 9, 2019 Remote access enabled. Link to comment Share on other sites More sharing options...
martinca Posted May 9, 2019 Author Share Posted May 9, 2019 Genious!!!!! Tanks!!! Link to comment Share on other sites More sharing options...
martinca Posted May 27, 2019 Author Share Posted May 27, 2019 (edited) good afternoonI appreciate if you can add the user martinc1_mcasalis to the martinc1_testsystel database, in the pg_hba.conf Thank you Edited May 27, 2019 by martinca Link to comment Share on other sites More sharing options...
Krydos Posted May 27, 2019 Share Posted May 27, 2019 Remote access enabled. Link to comment Share on other sites More sharing options...
martinca Posted May 27, 2019 Author Share Posted May 27, 2019 TKS!!! Link to comment Share on other sites More sharing options...
martinca Posted May 27, 2019 Author Share Posted May 27, 2019 It gives me the following error. FATAL: no pg_hba.conf entry for host "186.153.132.127", user "martinc1_mcasalis" database "martinc1_ticketspostventa", SSL off Link to comment Share on other sites More sharing options...
Krydos Posted May 27, 2019 Share Posted May 27, 2019 martinc1_testsystel databasedatabase "martinc1_ticketspostventa"You didn't say martinc1_ticketspostventa. You said martinc1_testsystel. Link to comment Share on other sites More sharing options...
martinca Posted May 28, 2019 Author Share Posted May 28, 2019 You are right, I was wrong in the first post. I need to work with the user martinc1_mcasalis to the database martinc1_ticketspostventa. Link to comment Share on other sites More sharing options...
Krydos Posted May 28, 2019 Share Posted May 28, 2019 Remote access enabled. Link to comment Share on other sites More sharing options...
Recommended Posts