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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
