From: | Luciano Martin Galletti <galletti77(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Pgadmin access to Postgresql |
Date: | 2016-07-09 15:00:48 |
Message-ID: | DM3PR13MB0765A19769AC83F068D1BF43C53D0@DM3PR13MB0765.namprd13.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
this is the pg_hba.conf
/etc/postgresql/9.3/main/pg_hba.conf
# Database administrative login by Unix domain socket
local all postgres $
# TYPE DATABASE USER ADDRESS $
# "local" is for Unix domain socket connections only
local all all $
# IPv4 local connections:
host all all 127.0.0.1/32<http://127.0.0.1/32> $
# IPv6 local connections:
host all all ::1/128 $
# Allow replication connections from localhost, by a user with$
# replication privilege.
#local replication postgres $
#host replication postgres 127.0.0.1/32<http://127.0.0.1/32> $
From | Date | Subject | |
---|---|---|---|
Next Message | arnaud gaboury | 2016-07-09 15:08:46 | Re: Broken after upgrade |
Previous Message | Derek Mahar | 2016-07-09 14:29:53 | PostgreSQL image for rkt on CoreOS |