public inbox for [email protected]  
help / color / mirror / Atom feed
Connection Refused Error
3+ messages / 2 participants
[nested] [flat]

* Connection Refused Error
@ 2018-03-21 19:35  Rahul Soshte <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Rahul Soshte @ 2018-03-21 19:35 UTC (permalink / raw)
  To: pgadmin-hackers

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?


Attachments:

  [image/png] Screenshot from 2018-03-22 01-01-27 - 1.png (164.3K, 3-Screenshot%20from%202018-03-22%2001-01-27%20-%201.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Connection Refused Error
@ 2018-03-21 19:53  Joao De Almeida Pereira <[email protected]>
  parent: Rahul Soshte <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 19:53 UTC (permalink / raw)
  To: Rahul Soshte <[email protected]>; +Cc: pgadmin-hackers

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 <[email protected]>
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?
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Connection Refused Error
@ 2018-03-21 20:14  Rahul Soshte <[email protected]>
  parent: Joao De Almeida Pereira <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Rahul Soshte @ 2018-03-21 20:14 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; pgadmin-hackers

Hi,
I solved the bug,actually what I had done was I had installed postgresql
without the version number i.e using this command

sudo apt-get install postgresql

I uninstalled postgresql using this command

sudo apt-get remove --purge postgresql-9.6


and reinstalled with the version number i.e

sudo apt-get install postgresql-9.6


I was actually facing this issue

https://askubuntu.com/questions/50621/cannot-connect-to-postgresql-on-port-5432

On Thu, Mar 22, 2018 at 1:23 AM, Joao De Almeida Pereira <
[email protected]> wrote:

> 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 <[email protected]>
> 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?
>>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2018-03-21 20:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-21 19:35 Connection Refused Error Rahul Soshte <[email protected]>
2018-03-21 19:53 ` Joao De Almeida Pereira <[email protected]>
2018-03-21 20:14   ` Rahul Soshte <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox