shurlik Posted June 11, 2017 Share 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. Link to comment Share on other sites More sharing options...
Krydos Posted June 11, 2017 Share 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. Link to comment Share on other sites More sharing options...
shurlik Posted June 11, 2017 Author Share Posted June 11, 2017 Thank you very much for the quick help! Link to comment Share on other sites More sharing options...
shurlik Posted June 11, 2017 Author Share 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 Link to comment Share on other sites More sharing options...
Krydos Posted June 11, 2017 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts