oswako Posted June 6, 2017 Share Posted June 6, 2017 I'm requesting access to my postgresql database in johnny server via pgadmin 4 for any ip that tries to connect to: host; johnny.heliohost.orgmaintenance DB: oswako_iotecheusername: oswako_postgrespassword: *********port: 5432 Note: the error displayed when I'm trying to connect through pgadmin 4 is FATAL: no pg_hba.conf entry for host "216.75.232.58", user "oswako_postgres", database "oswako_ioteche", SSL off Please let me know if you need any other info or I"m missing something. Thank you Link to comment Share on other sites More sharing options...
wolstech Posted June 6, 2017 Share Posted June 6, 2017 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted June 6, 2017 Share Posted June 6, 2017 The postgresql user oswako_postgres should now be able to remotely connect to the postgresql database oswako_ioteche from any IP. Link to comment Share on other sites More sharing options...
oswako Posted June 6, 2017 Author Share Posted June 6, 2017 (edited) Thank you for doing the changes, now when I try to connect gives' me the following Error:ERROR: unrecognized configuration parameter "bytea_output" Any ideas? Edited June 6, 2017 by oswako Link to comment Share on other sites More sharing options...
Krydos Posted June 6, 2017 Share Posted June 6, 2017 Johnny is running PostgreSQL v8.4.20 which PgAdmin4 does not support. PgAdmin3 should work with Johnny if you want to use an older version. Ricky and Tommy are both running PostgrSQL v9.2.18 which will work with PgAdmin4. So your options are to downgrade PgAdmin, or switch servers. Link to comment Share on other sites More sharing options...
oswako Posted June 7, 2017 Author Share Posted June 7, 2017 I just downgrade to PgAdmin 3 and is working thank you so much for the quick support RegardsOswald Link to comment Share on other sites More sharing options...
Recommended Posts