shurlik Posted June 11, 2017 Posted June 11, 2017 The postgresql user oswako_postgres should now be able to remotely connect to the postgresql database oswako_ioteche from any IP.Hello. I have the same problem FATAL: no pg_hba.conf entry for host "91.237.114.10", user "shurlik_admin", database "shurlik_ursus", SSL off host: johnny.heliohost.orgmaintenance DB: shurlik_ursususername: shurlik_adminport: 5432 Thanky you.
Krydos Posted June 11, 2017 Posted June 11, 2017 Hello. I have the same problem It's not a problem; it's a security feature. Remote postgresql is only enabled by request. You should now be able to connect to the potsgresql database shurlik_ursus remotely from the ip 91.237.114.10 using the postgresql username shurlik_admin. Let us know if you need help with anything else.
shurlik Posted June 11, 2017 Author Posted June 11, 2017 (edited) Krydos, can you change shurlik_ursus remotely from ALL ip using the postgresql username shurlik_admin?And when I change password appeared error org.postgresql.util.PSQLException: FATAL: password authentication failed for user "shurlik_admin" Sorry for my noob behavior, work with localhost easier. Edited June 11, 2017 by shurlik
Krydos Posted June 11, 2017 Posted June 11, 2017 You can now access that database from all IPs. The page to change/create postgresql users is https://johnny.heliohost.org:2083/frontend/paper_lantern/psql/index.html
Recommended Posts