nvbinh Posted October 27, 2020 Share Posted October 27, 2020 I'm trying to access to postgreSql but it's giving me this error:"no pg_hba.conf entry for host "42.118.26.172", user "postgres", database "postgres", SSL off" Please tell me how to fix this error. Thank you Link to comment Share on other sites More sharing options...
flazepe Posted October 27, 2020 Share Posted October 27, 2020 A root admin will need to enable PostgreSQL remote access for you. Escalating... Link to comment Share on other sites More sharing options...
Krydos Posted October 27, 2020 Share Posted October 27, 2020 user "postgres", database "postgres"Postgres is the superuser, and if we gave you access to that account you would be able to see all of the postgresql databases on the server, and even delete them if you wanted to. So, no. Link to comment Share on other sites More sharing options...
nvbinh Posted October 29, 2020 Author Share Posted October 29, 2020 user "postgres", database "postgres"Postgres is the superuser, and if we gave you access to that account you would be able to see all of the postgresql databases on the server, and even delete them if you wanted to. So, no. Sorry, It's a mistake, that user and database is the default and i forget to modify them, can you give me access with user ''nvbinh_admin", database "nvbinh_queswer"Thank you Link to comment Share on other sites More sharing options...
Krydos Posted October 29, 2020 Share Posted October 29, 2020 Remote access enabled. Link to comment Share on other sites More sharing options...
nvbinh Posted October 29, 2020 Author Share Posted October 29, 2020 Remote access enabled.Thank you Link to comment Share on other sites More sharing options...
Recommended Posts