Pgadmin access to Postgresql

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> $

Responses

Browse pgsql-general by date

  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