Обсуждение: Pgadmin and connection to a server
i'm tryng to access to a db that is on a my server.
The port is 5432 open and accept tcp/ip connections.
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "IP_OF_THE_SERVER" and accepting TCP/IP connections on port 5432?
Do i have to set something in pg_hba.conf
to have access at the database from outside and from internet and not intranet?
On 09/07/16 09:52, Nico Aliotta wrote: > i'm tryng to access to a db that is on a my server. > The port is 5432 open and accept tcp/ip connections. > > Server doesn't listen > The server doesn't accept connections: the connection library reports > could not connect to server: Connection refused (0x0000274D/10061) Is > the server running on host "IP_OF_THE_SERVER" and accepting TCP/IP > connections on port 5432? > > Do i have to set something in pg_hba.conf > to have access at the database from outside and from internet and not > intranet? Please try to access your postgresql server from the command line. If this fails as well with the same error, then clearly pgadmin is not part of the problem. You might get a very detailed answer from the general pgadmin list for this issue, but please review the pg_hba.conf details with respect to permissions; likely your port is ok but the server is denying because of incorrect permissions.
On 09/07/16 15:07, Colin Beckingham wrote: > > On 09/07/16 09:52, Nico Aliotta wrote: >> i'm tryng to access to a db that is on a my server. >> The port is 5432 open and accept tcp/ip connections. >> >> Server doesn't listen >> The server doesn't accept connections: the connection library reports >> could not connect to server: Connection refused (0x0000274D/10061) Is >> the server running on host "IP_OF_THE_SERVER" and accepting TCP/IP >> connections on port 5432? >> >> Do i have to set something in pg_hba.conf >> to have access at the database from outside and from internet and not >> intranet? > Please try to access your postgresql server from the command line. > If this fails as well with the same error, then clearly pgadmin is not > part of the problem. > You might get a very detailed answer from the general pgadmin list for > this issue, but please review the pg_hba.conf details with respect to > permissions; likely your port is ok but the server is denying because of > incorrect permissions. Something else worth checking is listen_addresses in postgresql.conf; IIRC, the default is to listen on localhost only. Ray.