From: robert <robert@redcor.ch>
To: bvo <pepevo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: how to connect pgadmin 4.16 to postgres db in linux
Date: Mon, 30 Dec 2019 18:44:30 +0100
Message-ID: <a9c8a1d5-7e24-24dc-5de8-bc08ed1d3ba0@redcor.ch> (raw)
In-Reply-To: <1577723003751-0.post@n3.nabble.com>
References: <1577723003751-0.post@n3.nabble.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robert@redcor.ch, pepevo@yahoo.com
Subject: Re: how to connect pgadmin 4.16 to postgres db in linux
In-Reply-To: <a9c8a1d5-7e24-24dc-5de8-bc08ed1d3ba0@redcor.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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