Thread: how to connect pgadmin 4.16 to postgres db in linux
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 ? 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
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 > >
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 > >
my listen_address has set to '*' in postgres.conf pg_hba.conf: # IPv4 local connections: host all all 127.0.0.1/32 trust host all all ::0/0 md5 local all postgres trust host all other_user 0.0.0.0/0 trust # IPv6 local connections: host all all ::1/128 indent #allow replication connection from localhost, by a user with replication privilege local replication all trust host replication all 127.0.0.1/32 trust host replication all ::1/128 trust host replication replicauser master'sIP trust host replication replicauser slave'sIP trust pgadmin still can't connect to the database. thank you. Bach-Nga -- Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
I added my subnet into the pg_hba.conf and it works thank you much. Happy New Year. v/r, Bach-Nga -- Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html