Re: how to connect pgadmin 4.16 to postgres db in linux

hi
you have to tell postgres running on your linux server who is allowed to login 
from what url
this is done in pd_hba.conf
and you have also to tell postgres on what ips it should listen
See:

https://www.netiq.com/documentation/identity-manager-47/setup_windows/data/connecting-to-a-remote-postgresql-database.html

On 30.12.19 17:23, bvo wrote:
> Hello,
>
> I am new with postgres and would like to know how to connect to the postgres
> db in Linux using pgadmin in Window.
>
> I created postgresdb in Linux and try to connect into the db using
> pgadmin4.16 in my window workstation.
> I create Server and put the hostname/address. I get an error:
> "Unable to connect to server:
> FATAL: no pg_hba.conf entry for host "192.168.#.#", user "postgres",
> database "dbname", SSL off
> "
> not even with database name as postgres.
>
> Do I need to put my window's ip on pg_hba.conf in Linux? How? In
> pg_hba.conf should I add entry:
> host all postgres trust
> ?

have you tried that?

I think it should work.

As long this is no internet facing machine, there should be no security risk

robert

> What's happen if the other developers want to connect to the database using
> pgadmin, do I need to add their windows' IP in? Is there a way we can use
> like sqldeveloper without add all windows' IP?
>
> thank you.
>
> Bach-Nga
>
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
>