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

how to connect pgadmin 4.16 to postgres db in linux

From
bvo
Date:
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



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

From
"robert@redo2oo.ch"
Date:
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
>
>




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

From
robert
Date:
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
>
>





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

From
bvo
Date:
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



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

From
bvo
Date:
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