pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how to connect pgadmin 4.16 to postgres db in linux 5+ messages / 3 participants [nested] [flat]
* how to connect pgadmin 4.16 to postgres db in linux @ 2019-12-30 16:23 bvo <pepevo@yahoo.com> 2019-12-30 17:11 ` Re: how to connect pgadmin 4.16 to postgres db in linux robert@redo2oo.ch <robert@redo2oo.ch> 2019-12-30 17:44 ` Re: how to connect pgadmin 4.16 to postgres db in linux robert <robert@redcor.ch> 0 siblings, 2 replies; 5+ messages in thread From: bvo @ 2019-12-30 16:23 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to connect pgadmin 4.16 to postgres db in linux 2019-12-30 16:23 how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> @ 2019-12-30 17:11 ` robert@redo2oo.ch <robert@redo2oo.ch> 1 sibling, 0 replies; 5+ messages in thread From: robert@redo2oo.ch @ 2019-12-30 17:11 UTC (permalink / raw) To: bvo <pepevo@yahoo.com>; pgsql-admin 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-po... 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 > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to connect pgadmin 4.16 to postgres db in linux 2019-12-30 16:23 how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> @ 2019-12-30 17:44 ` robert <robert@redcor.ch> 2019-12-30 17:55 ` Re: how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> 1 sibling, 1 reply; 5+ messages in thread From: robert @ 2019-12-30 17:44 UTC (permalink / raw) To: bvo <pepevo@yahoo.com>; pgsql-admin 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-po... 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 > > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to connect pgadmin 4.16 to postgres db in linux 2019-12-30 16:23 how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> 2019-12-30 17:44 ` Re: how to connect pgadmin 4.16 to postgres db in linux robert <robert@redcor.ch> @ 2019-12-30 17:55 ` bvo <pepevo@yahoo.com> 2019-12-31 14:30 ` Re: how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> 0 siblings, 1 reply; 5+ messages in thread From: bvo @ 2019-12-30 17:55 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to connect pgadmin 4.16 to postgres db in linux 2019-12-30 16:23 how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> 2019-12-30 17:44 ` Re: how to connect pgadmin 4.16 to postgres db in linux robert <robert@redcor.ch> 2019-12-30 17:55 ` Re: how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> @ 2019-12-31 14:30 ` bvo <pepevo@yahoo.com> 0 siblings, 0 replies; 5+ messages in thread From: bvo @ 2019-12-31 14:30 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-12-31 14:30 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-12-30 16:23 how to connect pgadmin 4.16 to postgres db in linux bvo <pepevo@yahoo.com> 2019-12-30 17:11 ` robert@redo2oo.ch <robert@redo2oo.ch> 2019-12-30 17:44 ` robert <robert@redcor.ch> 2019-12-30 17:55 ` bvo <pepevo@yahoo.com> 2019-12-31 14:30 ` bvo <pepevo@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox