From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Luciano Martin Galletti <galletti77(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pgadmin access to Postgresql |
Date: | 2016-07-09 16:03:21 |
Message-ID: | 23b4ca45-823a-5678-a089-c028685ae32f@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/09/2016 08:00 AM, Luciano Martin Galletti 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?
Are you connecting over a network?
In other words is pgAdmin on one machine and the server on another?
If so is there a firewall in between that is blocking access to port 5432?
If not can you explain more about what your setup is?
>
> 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> $
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-07-09 16:54:35 | Re: Pgadmin access to Postgresql |
Previous Message | arnaud gaboury | 2016-07-09 15:59:35 | Re: Broken after upgrade |