nvbinh Posted October 27, 2020 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
Flaze Posted October 27, 2020 Posted October 27, 2020 A root admin will need to enable PostgreSQL remote access for you. Escalating...
Krydos Posted October 27, 2020 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.
nvbinh Posted October 29, 2020 Author 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
Recommended Posts