[Solved] Requesting Postgresql Db Access From Pgadmin 4 & From Any Ip

[oswako]

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.org

maintenance DB: oswako_ioteche

username: oswako_postgres

password: *********

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

 

 

 

[wolstech]

This support request is being escalated to our root admin.

[Krydos]

The postgresql user oswako_postgres should now be able to remotely connect to the postgresql database oswako_ioteche from any IP.

[oswako]

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

[Krydos]

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.

[oswako]

I just downgrade to PgAdmin 3 and is working

 

thank you so much for the quick support

 

Regards

Oswald