Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eyk7x-0000ux-TD for pgadmin-hackers@arkaria.postgresql.org; Wed, 21 Mar 2018 20:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eyk7w-0006ry-8i for pgadmin-hackers@arkaria.postgresql.org; Wed, 21 Mar 2018 20:14:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eyk7w-0006ro-3W for pgadmin-hackers@lists.postgresql.org; Wed, 21 Mar 2018 20:14:28 +0000 Received: from mail-io0-x241.google.com ([2607:f8b0:4001:c06::241]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1eyk7s-0007NS-Rg for pgadmin-hackers@postgresql.org; Wed, 21 Mar 2018 20:14:27 +0000 Received: by mail-io0-x241.google.com with SMTP id m83so8151160ioi.8 for ; Wed, 21 Mar 2018 13:14:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=hFpL+XzD9yWJfMCBWfEwT/8V7/aI1RPfC6DtzKDXq10=; b=uGH0LYc2s7tPBTl4pA1lxqntG28u0OLoxijlUZrsYnuXqHuXZap8uXpi6gFp1NDh/r 501YL4rfjijrKkHK5RiUDBKlmBXLUmboNyVUGYpHqiQZBqvDfGg7rRJ91gMIUrDv5uuB o98QU6QckUaeXMTXZ6KamExJiM+LtuEMSTO4w9zvDdSwvO5e8rCZNBtDGE6UWYtXw7mY IyOIg0xGHkgZDLhjRQKUNDCgIDKbNIR7LsdZS5ezrsUFVrs6tSEYuwANS2U2xK9p8ILB 7HTiheN2nj5gjE7TtJmNZsIvuAZqAT9HEU7UkCRgZdCY4Dsekr8x9MQXmTAEZsvx2USP Se6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=hFpL+XzD9yWJfMCBWfEwT/8V7/aI1RPfC6DtzKDXq10=; b=l5DYgXUl+rgEU6T7UJ9vHkVcWYasyMlOit805oBdgEyucyjUvk8JFHSnn5gbJzHM55 L3k9Dq21foGjM/5FBn+WHT3nNpoYHyOQD7yt7bIfJ9tgzeEuAikwiGLE4/X/zYfXXSYX +3XV87gbcOzIoDk6xo+6yxxl7c4nWFt+HCSpEhHPoyxd8mQoDjPVcSCr0qeOY7m39yRM vkPdq2D7I5REcm7KS6PhlUdXywFws/GV4fNdqmkU/CzO/1PWF36kjYoJobN6UvfpQg3M SWz8L6wGxUh2136WpJBy5M3/jJION85tem/vt4JnIXR+WWL8l2CZpN+oScCIBeYYgEQK aOUg== X-Gm-Message-State: AElRT7FiKTu/vbEr8rB90w9+z5ZgA/OKqhvsATSK2Yoedi35gjGbuenh RD4SEemr1MSYljS6x/hiShgPmeoyms/gepUhzy8= X-Google-Smtp-Source: AG47ELs6HhfjMIT3Q1NGaPGET9IXAtu8+X4ymz5KxUHq/5Qg10UEbBl4imZrdeXGjDx/nETzGF3Rffg90MnFFDTQseE= X-Received: by 10.107.181.136 with SMTP id e130mr18703669iof.105.1521663262837; Wed, 21 Mar 2018 13:14:22 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.26.212 with HTTP; Wed, 21 Mar 2018 13:14:22 -0700 (PDT) In-Reply-To: References: From: Rahul Soshte Date: Thu, 22 Mar 2018 01:44:22 +0530 Message-ID: Subject: Re: Connection Refused Error To: Joao De Almeida Pereira , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="001a114450183fe4830567f1d631" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a114450183fe4830567f1d631 Content-Type: text/plain; charset="UTF-8" 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 < jdealmeidapereira@pivotal.io> 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 > 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? >> > --001a114450183fe4830567f1d631 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
I solved the bug,actually what I had done= was I had installed postgresql without the version number i.e using this c= ommand

sudo apt-get install postgresql

I uni= nstalled postgresql using this command

sudo apt-get remov=
e --purge postgresql-9.6

and reinstalled with the version n= umber i.e

sudo apt-get install postgresql-9.6


I was actually facing this issue=C2=A0

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 <jdealmeidapereira@pivotal.io> wrote:
Hello Rahul,
Did you change the /etc/postgresql/10/main/pg_hba.conf= =C2=A0 file configuration to allow connections? if not take a look at=C2=A0= https://www.thegeekstuff.com/2014/02/enab= le-remote-postgresql-connection/=C2=A0this should guide you but ba= sically you need to change the METHOD to `trust` on the 127.0.0.1 address a= nd eventually of the ::1 as well.
If that didn't help let us = know

Thanks
Joao=C2=A0

On Wed,= Mar 21, 2018 at 3:35 PM Rahul Soshte <rahulsoshte360@gmail.com> wrote:
I had installed pga= dmin4 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 refuse= d
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=3D"localhost"
to listen_add= ress=3D"*"
but it still didnt work.

= What do I do?

--001a114450183fe4830567f1d631--