MIME-Version: 1.0
References: 
 <CAKyzeV1O5KYDFg6Q3qK6=Xfu-bpi51vUxjci07kr1qUbTERvkg@mail.gmail.com>
In-Reply-To: 
 <CAKyzeV1O5KYDFg6Q3qK6=Xfu-bpi51vUxjci07kr1qUbTERvkg@mail.gmail.com>
From: Joao De Almeida Pereira <jdealmeidapereira@pivotal.io>
Date: Wed, 21 Mar 2018 19:53:21 +0000
Message-ID: 
 <CAE+jjan_Jt3ki7YNgUb47HBCO6mf0-DN2y_tduAkBF2qan5cNA@mail.gmail.com>
Subject: Re: Connection Refused Error
To: Rahul Soshte <rahulsoshte360@gmail.com>
Cc: pgadmin-hackers@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b412ff0567f18b3f"
Precedence: bulk

--000000000000b412ff0567f18b3f
Content-Type: text/plain; charset="UTF-8"

Hello Rahul,
Did you change the /etc/postgresql/10/main/pg_hba.conf  file configuration
to allow connections? if not take a look at
https://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/ this
should guide you but basically you need to change the METHOD to `trust` on
the 127.0.0.1 address and eventually of the ::1 as well.
If that didn't help let us know

Thanks
Joao

On Wed, Mar 21, 2018 at 3:35 PM Rahul Soshte <rahulsoshte360@gmail.com>
wrote:

> I had installed pgadmin4 from git Source repo.The First time I Installed I
> was able to create a Server.But when I restarted my PC.I got this error.
>
> Unable to connect to server:
>
> could not connect to server: Connection refused
> Is the server running on host "127.0.0.1" and accepting
> TCP/IP connections on port 5432?
>
> I tried Installing everthing Again but got the same error.I also changed
> postgresql.conf file from
> listen_address="localhost"
> to listen_address="*"
> but it still didnt work.
>
> What do I do?
>

--000000000000b412ff0567f18b3f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello Rahul,<div>Did you change the <font color=3D"#111111=
" face=3D"Georgia, Times New Roman, Times, serif"><span style=3D"font-size:=
16px">/etc/postgresql/10/main/pg_hba.conf</span></font>=C2=A0 file configur=
ation to allow connections? if not take a look at=C2=A0<a href=3D"https://w=
ww.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/">https://w=
ww.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/</a>=C2=A0t=
his should guide you but basically you need to change the METHOD to `trust`=
 on the 127.0.0.1 address and eventually of the ::1 as well.</div><div>If t=
hat didn&#39;t help let us know</div><div><br></div><div>Thanks</div><div>J=
oao=C2=A0</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Wed=
, Mar 21, 2018 at 3:35 PM Rahul Soshte &lt;<a href=3D"mailto:rahulsoshte360=
@gmail.com">rahulsoshte360@gmail.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex"><div dir=3D"ltr"><div>I had installed pgadmin4 from git So=
urce repo.The First time I Installed I was able to create a Server.But when=
 I restarted my PC.I got this error.</div><div><br>Unable to connect to ser=
ver:<br><br>could not connect to server: Connection refused<br>	Is the serv=
er running on host &quot;127.0.0.1&quot; and accepting<br>	TCP/IP connectio=
ns on port 5432?<br><div><br>I tried Installing everthing Again but got the=
 same error.I also changed postgresql.conf file from<br></div><div>listen_a=
ddress=3D&quot;localhost&quot;<br></div><div>to listen_address=3D&quot;*&qu=
ot;<br></div><div>but it still didnt work.</div><br></div>What do I do?<br>=
</div>
</blockquote></div>

--000000000000b412ff0567f18b3f--