On Fri, Nov 23, 2018 at 8:31 PM Anne Marie H= arm <amharm@earthlink.net>= ; wrote:

Hello,=C2=A0

Unfortunately I'm unable to operate pgAdmin/PostgreSQL= ; first of all I can only install version 9.5 (tried versions 11, 10, and 9= .6 -- but cannot install). When I launch pgAdmin in order to try to use Pos= tgreSGL 9.5, here is the full text of the error message I rec= eive (also, screenshot attached):

could not co= nnect to server: Connection refused (0x0000274D/10061) Is the server runnin= g on host "localhost" (::1) and accepting TCP/IP connections on p= ort 5432? could not connect to server: Connection refused (0x0000274D/10061= ) Is the server running on host "localhost" (127.0.0.1) and accep= ting TCP/IP connections on port 5432?

Please advise; thank you. ~ Anne Marie
---------------------------- Anne Marie Harm (312) 563-9397 amharm@earthlink.= net ht= tps://www.linkedin.com/in/annemarieharm/
--00000000000005bf26057b69105f-- From ray@rodonnell.ie Sat Nov 24 13:37:00 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQY7f-0007cu-0f for pgadmin-support@arkaria.postgresql.org; Sat, 24 Nov 2018 13:37:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQY7d-0002Kp-IP for pgadmin-support@arkaria.postgresql.org; Sat, 24 Nov 2018 13:37:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQY7d-0002Ki-93 for pgadmin-support@lists.postgresql.org; Sat, 24 Nov 2018 13:37:21 +0000 Received: from [2001:41c9:1:41d::10] (helo=srv01.teladesign.ie) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQY7W-0007m3-1q for pgadmin-support@lists.postgresql.org; Sat, 24 Nov 2018 13:37:20 +0000 Received: from [109.77.230.204] (helo=[192.168.1.134]) by srv01.teladesign.ie with esmtpsa (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.84_2) (envelope-from ) id 1gQY7O-0002ub-SL; Sat, 24 Nov 2018 13:37:09 +0000 To: Malik Rumi , amharm@earthlink.net Cc: pgadmin-support@lists.postgresql.org References: <964914383.8186.1543026683916@wamui-moana.atl.sa.earthlink.net> From: Ray O'Donnell Message-ID: <349b5038-66ab-fba5-9c31-3c6fea852527@rodonnell.ie> Date: Sat, 24 Nov 2018 13:37:00 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/html; charset=utf-8 Content-Language: en-GB Content-Transfer-Encoding: 8bit X-SA-Exim-Connect-IP: 109.77.230.204 X-SA-Exim-Mail-From: ray@rodonnell.ie Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL X-SA-Exim-Version: 4.2.1 (built Mon, 26 Dec 2011 16:24:06 +0000) X-SA-Exim-Scanned: No (on srv01.teladesign.ie); Unknown failure X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:41c9:1:41d::10 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk
On 24/11/18 13:26, Malik Rumi wrote:

1. What is your operating system? It looks like Windows, but I'm not sure. Also what version number for the OS?

2. Look in the url. You are at 127.0.0.1. That is the same as localhost. But then it says 49194. Postgres uses 5432 by default. That's why you got that part of the error message, but we need a lot more detail to help you.

3. It might be that your OS is too old to run the more recent versions of Postgres. I don't use Windows anymore, but I know you have to be at Ubuntu 18 to run PG 10 +, there's probably something similar in Windows. That is one of the many reasons why knowing your OS is important information.

“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”

On Fri, Nov 23, 2018 at 8:31 PM Anne Marie Harm <amharm@earthlink.net> wrote:

Hello,

Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried versions 11, 10, and 9.6 -- but cannot install). When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the full text of the error message I receive (also, screenshot attached):

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

[Removed pgsql-hackers and pgsql-admin, as this question is about pgAdmin]

In addition to what Malik has said above, you might have a mix-up between IPv4 and IPv6 - the error message above indicates that pgAdmin is trying to connect using IPv6.

Ray.

From mbanck@debian.org Sat Nov 24 13:47:31 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQYQx-0000IP-Ud for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 13:57:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQYQw-0001Q9-HQ for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 13:57:18 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQYJi-0007Iq-Ar for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 13:49:50 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQYJS-0008Ka-5F for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 13:49:49 +0000 Received: from nighthawk.chemicalconnection.dyndns.org ([88.217.108.32]) by mail.gmx.com (mrgmx002 [212.227.17.190]) with ESMTPSA (Nemesis) id 0LjZEm-1fpIgK1DM8-00bYqq; Sat, 24 Nov 2018 14:49:28 +0100 Received: from mbanck by nighthawk.chemicalconnection.dyndns.org with local (Exim 4.84_2) (envelope-from ) id 1gQYHT-0006wv-Rp; Sat, 24 Nov 2018 14:47:31 +0100 Date: Sat, 24 Nov 2018 14:47:31 +0100 From: Michael Banck To: Malik Rumi Cc: amharm@earthlink.net, pgsql-admin@lists.postgresql.org Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL Message-ID: <20181124134731.GA5605@nighthawk.caipicrew.dd-dns.de> References: <964914383.8186.1543026683916@wamui-moana.atl.sa.earthlink.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) Sender: X-Provags-ID: V03:K1:ouXUaR3a+sVYMIMhFQAs2/ZtZLuJ3XL8Mni1BQ2zI6r1snN4Dpi cmuUqkVFb+hHexstyibc8+/UlQpR4tZj+1vVD1FeIUmR0QzvmsiMKDSdgejxobiNc3W111I LLMxlp1DR3fmY55KZgYotZ6nrCAwP/PV5IEyX7LA+YYghteNxC7gfySmUTL7chiFdvBIg9p 7RJZxgkRjG5WRTiW7XuSg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:qLXFlRsaRQ0=:sRI0WcF9bVpEB2qNcp/oR3 cCFjSAvfpq36dM53IQxVweW4KrnmGl7wszq49hOhNypywlsGERyLG9HP9DutM7UvMM1zL+4nv ab1sCzsIysBhW8d65eFps1dUT/Mt1t4JFUmc6k5vWM5PTT64Fhi913HLWcXeRcCVueGYonMh5 9r12yHGTN7uv3jA9RnknAtRfblXJrBmQcUZErU5Iq4Dw7pLKBGTNg+1czY5qLgf6+eQCtE7p3 e+1Z7wjc98pEhJaYEOimX5qaIpBUc5HrnmIf3qSyBYIK0gFRawu5l/9V1mtW7orcB4t0iALfh x1qYXCrsiaPyxKkcAsh17+/HHa40sGAqGRPREeUGnosAcAi6zRWDXRPrtHahdvDZpo80K0HBT A+VNjL8wJcSG5gQ+cVjwACWZzTlbgm74a2eT3+Ol99q0BvO0jOitSdVqa0noeJNElgXNSY2ri puWpc5ggJoUh8vobLlHeL8JJJ16VcvmTgjVGJug8NrNza4e6GdmU5+eHWg5cH0i7BT6Cy/jO5 BNmZcE7r0hab/mXqP6ah0MK/K7lrXPSwseG9aw4Hlqt8pW1NHAuiBdjVZWkkPmI5SIWIJiRyw PZ4Z8Bsc25DDuNISMDqt7eJmJUZHWM0s3Z1PsMQH8oB6aVTnEMVbTagI1RIIVj6bDtv3g5qd2 GLWglqY9aOvrk2NXnrCxULt24nKZ0kMxngEw36yuhRJRyMqQb6v5GupH9P+2gw51EuNvjPJYx In7MSaC7dPTG/b0iI/R/N+GKdHA3fB2y4+4R3Nrc8rLdahWP8bPxYAyWtZ9z8v8tZpECvm6d+ fjaWS2dNvAAEkSoPY8LXT0xpkqzdSRtaH/g8TykFEKT2597x3PgeRYGkfV71v+SzktVxfZ/KX XeTVwLOSwCgSEWgLvEOAa+BRWyabcKIgDztPcWMEg= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, (no need to cross-post this to all of pgadmin-support, -admin and -hackers, I've removed pgadmin-support and -hackers) On Sat, Nov 24, 2018 at 07:26:58AM -0600, Malik Rumi wrote: > I don't use Windows anymore, but I know you have to be at Ubuntu > 18 to run PG 10 +, That's not true, the Postgres project supports all Postgres versions on all Ubuntu LTS versions at https://apt.postgresql.org. Michael From malik.a.rumi@gmail.com Sat Nov 24 16:00:51 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQaND-0006nQ-5W for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 16:01:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQaNA-0000Sj-Q2 for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 16:01:32 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQaNA-0000Sc-GW for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 16:01:32 +0000 Received: from mail-it1-x142.google.com ([2607:f8b0:4864:20::142]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQaN7-0003ns-Pm for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 16:01:32 +0000 Received: by mail-it1-x142.google.com with SMTP id x19so22270323itl.1 for ; Sat, 24 Nov 2018 08:01:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=9/fedq6S/KA+IBJ7MGcMijeKftkvPSh45yHJYIhXH2E=; b=XRKXtBwzPq2SsTQRdztQ19bVvpzws0imZ60fpUPgtYKaQJZmX9YWDdmCFLGXQCEQ5c s4+kWflaBVj9D7jaVv7UT08a4K/4MVwSEuf7haqY/WEFRmV+n3uc2TTZUa7Mll+Hi7Bk Cw/yW/S1/DWWrImSCcG0UHSGz8RQU+o5eth6KeMa4S3728ftddyUticiUxgnQJ/6c7x2 0ICiFOCoih1jA24KONxKCK8p0mbaxIlaYHhyc1J7U7Fq7pt6jV4hvgNBic2TQFhk4v2+ Ds4LyqmnWkhxvGibRZ1f+gh5U4wGYQBEt9e2cGB650r8+sa/p+U6MCx39Y1ZJGWWne/9 Scng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=9/fedq6S/KA+IBJ7MGcMijeKftkvPSh45yHJYIhXH2E=; b=PYM0A4gGv8a6lWNRw5hBqz4ztCcoUjUV2lBfY7C/xYwReL+3y5dBO/1IORfK2L9EEI Sb/+px26mvwJDQ+RuAJG9FYu4Fk9Em6TpxEfGSccynZtyARZGZHuVlQi2cwqYPoTIqW2 +QsF0AR4pMhtHWWj3Ecb6T7dJMZr8M8FJHdcjUShKSREoQgPUr8la9z4S+joTMdT4RPO S0kh729W84TO1rMtbVczXPEkidUjozvtCs3MOBA95Jz0vsWfI1XhYEIN2ETITOHSTDvJ A50JXrC0ib30jOR3KQbcfN0Vi8fQFlt/IodneMdAtVK5Ms15FIYFJKwmWDDPfCElHvma ePTQ== X-Gm-Message-State: AGRZ1gJ0yXTuocuZknNvljhfPkdnQgxhw6TGUESKeK5xyIDJ87+JxjqV XuGpfjxaRWr7TglJYUGLzWYxhpZWaUJ7wK1v2JM= X-Google-Smtp-Source: AJdET5fBpzYJPsYlErsC2gL+QKESsaDZxz/5TY37/qpzzVcDd5/mn6WowIRWuZx3ImGePDM1kl2aVDsMce6XuC1Nf8Y= X-Received: by 2002:a02:152:: with SMTP id c79mr17601867jad.138.1543075288111; Sat, 24 Nov 2018 08:01:28 -0800 (PST) MIME-Version: 1.0 References: <964914383.8186.1543026683916@wamui-moana.atl.sa.earthlink.net> <20181124134731.GA5605@nighthawk.caipicrew.dd-dns.de> In-Reply-To: <20181124134731.GA5605@nighthawk.caipicrew.dd-dns.de> From: Malik Rumi Date: Sat, 24 Nov 2018 10:00:51 -0600 Message-ID: Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL To: mbanck@debian.org Cc: Anne Marie Harm , pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000068e142057b6b36d0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000068e142057b6b36d0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable A little off topic, but I clearly remember getting an error message when trying to upgrade to PG 10 while still on Ubuntu 16, and seeing a blog post to the same effect. I can't cite you to them now, of course, that was all months ago, but that's where I got the info. It could easily have been wrong, of course, but it was out there at the time. *=E2=80=9CNone of you has faith until he loves for his brother or his neigh= bor what he loves for himself.=E2=80=9D* On Sat, Nov 24, 2018 at 7:49 AM Michael Banck wrote: > Hi, > > (no need to cross-post this to all of pgadmin-support, -admin and > -hackers, I've removed pgadmin-support and -hackers) > > On Sat, Nov 24, 2018 at 07:26:58AM -0600, Malik Rumi wrote: > > I don't use Windows anymore, but I know you have to be at Ubuntu > > 18 to run PG 10 +, > > That's not true, the Postgres project supports all Postgres versions on > all Ubuntu LTS versions at https://apt.postgresql.org. > > > Michael > --00000000000068e142057b6b36d0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
A little off topic, but I clearly remember getting an erro= r message when trying to upgrade to PG 10 while still on Ubuntu 16, and see= ing a blog post to the same effect. I can't cite you to them now, of co= urse, that was all months ago, but that's where I got the info. It coul= d easily have been wrong, of course, but it was out there at the time.
=E2=80= =9CNone of you has faith until he loves for his brother or his neighbor wha= t he loves for himself.=E2=80=9D

On Sat, Nov 24, 2018 at = 7:49 AM Michael Banck <mbanck@debia= n.org> wrote:
Hi,

(no need to cross-post this to all of pgadmin-support, -admin and
-hackers, I've removed pgadmin-support and -hackers)

On Sat, Nov 24, 2018 at 07:26:58AM -0600, Malik Rumi wrote:
> I don't use Windows anymore, but I know you have to be at Ubuntu > 18 to run PG 10 +,

That's not true, the Postgres project supports all Postgres versions on=
all Ubuntu LTS versions at https://apt.postgresql.org.

Michael

--00000000000068e142057b6b36d0-- From amharm@earthlink.net Sat Nov 24 17:03:53 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQbLf-0001Wr-1e for pgadmin-support@arkaria.postgresql.org; Sat, 24 Nov 2018 17:04:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQbLd-00039D-NE for pgadmin-support@arkaria.postgresql.org; Sat, 24 Nov 2018 17:04:01 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQbLd-000391-68; Sat, 24 Nov 2018 17:04:01 +0000 Received: from elasmtp-galgo.atl.sa.earthlink.net ([209.86.89.61]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQbLZ-00057I-UL; Sat, 24 Nov 2018 17:04:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=earthlink.net; s=dk12062016; t=1543079038; bh=k6iBvCoYM2KApHuHAAStdjIx31bMtjNM0c5k W6w7Ueg=; h=Received:Received:Date:From:Reply-To:To:Cc:Message-ID: Subject:MIME-Version:Content-Transfer-Encoding:X-Mailer: Content-Type:X-ELNK-Trace:X-Originating-IP; b=iV6FOHzdTvn6Br+g1IPd SB3QvRcMRXkE5F/JdTch2O+DR1wkIIxChdcWCeEreUEXmzRnNOCL5c/nP7DdCWbKGn0 lieN0NAWyyaauXVe9tz6DcC9v7EshNTLboK9xqm6DOgSsAZJdV76YEsBqIrvb9ATWll DNrDepLGFTbHjOsjO0f3jDDrwe1OsDY2x/Sga8eOFCgMJUWx+R3kp4hKSsNx2Y9ajQq HoiQAvkeaSCcHd+yXE0sGx1Jid2eY2g2RXaVv0nKkz5/u1caJv4CL8FlBt38ThS8VXF oCNDGB7SqxW3HITgGR6ueF5AAiDpFBjdT7Ikts7/vzqSb3emkk2mkQ== DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk12062016; d=earthlink.net; b=UMv60Rl+BVyowOSS2p1j1zpI80gt7iguJe0wtu/86RnN/9Un89LsSCvIyTk9gO9AhRzsmcIe71ZMJJoqBZ05YSHVEpt5/MDWqgBomc/tFhdtn267MsjnWbuTbfayz0YuSdpNmg3Wf3H0VW9zXMV+66olxdjEy4KhLBWpfEnvYE767hfE2fKfiq7A1DwPdNShgnWiTt99bBzcvFNYyggkKTYnyVZaHTTq7zR+q9nIn5N0YQSBHekfp07nbj9TBE9oXb76qqEHcq4mEIqRw8/yyex+R+QBKGieLI3VBHHjY4ONTn/cAVuxncwzNQy4Ug3CZqpc5LQvoD7KRpmlQwfe3g==; h=Date:From:Reply-To:To:Cc:Message-ID:Subject:MIME-Version:Content-Transfer-Encoding:X-Mailer:Content-Type:X-ELNK-Trace:X-Originating-IP; Received: from [209.86.224.158] (helo=wamui-koala.atl.sa.earthlink.net) by elasmtp-galgo.atl.sa.earthlink.net with esmtpa (Exim 4) (envelope-from ) id 1gQbLV-0003Sb-Jw; Sat, 24 Nov 2018 12:03:53 -0500 Received: from 73.144.143.244 by webmail.earthlink.net with HTTP; Sat, 24 Nov 2018 12:03:53 -0500 Date: Sat, 24 Nov 2018 12:03:53 -0500 (GMT-05:00) From: Anne Marie Harm Reply-To: Anne Marie Harm To: Malik Rumi Cc: pgadmin-support@lists.postgresql.org, pgsql-admin@lists.postgresql.org Message-ID: <514259035.1790.1543079033600@wamui-koala.atl.sa.earthlink.net> Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: EarthLink Zoo Mail 1.0 Content-Type: text/html; charset=UTF-8 X-ELNK-Trace: 2bb16525f3d7da0d94f5150ab1c16ac07475de73c4477ed72f2af09e0dd2b04010ea2369469151e1350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 209.86.224.158 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk
body{font-size:10pt;font-family:arial,sans-serif;background-color:#fff= fff;color:black;}p{margin:0px;}[I removed pgsql-hackers@lists.postgresql= .org address from this reply since it looked like agreement this does not b= elong there. However one said this belongs on the pgadmin-support@lists.pos= tgresql.org list, and another said it belongs on pgsql-admin@lists. postgre= sql.org, so I kept both here; I hope okay.]

<= div>Hello,&n= bsp;

I appreciate all the response. Here are m= y replies, in purple below:
1.= What is your operating system? It looks like Windows, but I'm not sur= e. Also what version number for the OS?

Windows 10
Version 1803 (= OS Build 17134.407)

2. Look in the url. You are at 127.0.0.1. That is the same as loca= lhost. But then it says 49194.

I don't see 49194.

Postgres uses 5432 by default. That's w= hy you got that part of the error message, but we need a lot more deta= il to help you.

3. It might be that your OS is too old to run the more recent versions of= Postgres. I don't use Windows anymore, but I know you have to be at Ubuntu= 18 to run PG 10 +, there's probably something similar in Windows. Tha= t is one of the many reasons why knowing your OS is important information.<= /font>
---------------------------------------------
A= nother reply

How come. (Are you running a real= ly old distro version?)

No.

Well, is Postgres runn= ing? You installed Pg but did you start it? =

=
I can launch pgAdmin, b= ut I cannot log into postgres. Instead I receive the error message cited be= low.

These two commands will tell you:
pg_= ctl status # when logged in as user postgres
sudo netstat -an | gr= ep 5432

On Fri, Nov 23, 2018 at 8:31 PM Anne Mar= ie Harm <amhar= m@earthlink.net> wrote:
H= ello,

Unfortunately I'm unable to operate = pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried vers= ions 11, 10, and 9.6 -- but cannot install). When I launch pgAdmin in order= to try to use PostgreSGL 9.5, here is the full text of the e= rror message I receive (also, screenshot attached):

could not connect to server: Connection refused (0x0000274D/10061) Is = the server running on host "localhost" (::1) and accepting TCP/IP connectio= ns on port 5432? could not connect to server: Connection refused (0x0000274= D/10061) Is the server running on host "localhost" (127.0.0.1) and acceptin= g TCP/IP connections on port 5432?

P= lease advise; thank you. ~ Anne Marie
---------------------------- Anne Marie Harm (312) 563-9397 amharm@earthlink.= net ht= tps://www.linkedin.com/in/annemarieharm

From ronljohnsonjr@gmail.com Sat Nov 24 18:10:58 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOf-000534-No for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 18:11:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQcOd-0004O2-5x for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 18:11:11 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOc-0004Nv-Rb for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 18:11:10 +0000 Received: from mail-oi1-x242.google.com ([2607:f8b0:4864:20::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQcOV-0006eS-PE for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 18:11:10 +0000 Received: by mail-oi1-x242.google.com with SMTP id j21so12371284oii.8 for ; Sat, 24 Nov 2018 10:11:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=eqKC2mFnlgmxe6MER30T0gQ0+OG2mLZrgvKDXyQgIas=; b=P9LDIivMViI3Eaq/oOoSvBXoFhLQwNWmCAAmYWvNItPbFIfoBdK29qOa2XdUrMNWR4 XNeiHTHCYGCe1fuqQK/WnMuMvl6y/8vq/Hnfpv/CFePreak7KO57miM+Uap/5fVNb1ku LIBSFeTQZ5uQCZP6meMmaFSjVzzmFsV8sRIrLl9+nzNlq4WbT7BAbfnhp4dW0smBCiMA uIvxMFd8ywhTg0yDsOwxH4i4zi8qzM5prItuEN0+twqmiKAcecQjSDDzCoyf6J+WRRN+ PG6tBRBZnSj3WiLkzL36vZZpkj0vgGUx6KrR7M4BMTZJZo6hR1vh9SZLAQK+IOwFOAR/ mwpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=eqKC2mFnlgmxe6MER30T0gQ0+OG2mLZrgvKDXyQgIas=; b=Ia2j/3lRPVY7xAMjmZUQVacEUBDbLvZJpf2qT2PLKHpY3pHjHiv0UnRw72TUoe1zp0 OZ7XBDKo0VfG82y2YiYU7CazLe3LKfcm3+e9lcmANF1+mZwXgGrWKUY7KuIC5S5d90B4 j/bvprpAQruWyKr3Dyp6MSRUO+bz0YkkgC4vdUs3Hix6MVo/k00uyzNuxCn9BLA025sB NxJ1v4h1QBXHXgxiOQB61qoJClSm1krBB2Pr+33pAXWuqV68Y+8bI3bttu0/MRpbQQF2 6vahxoDAhdEeAZ0Xog5KaJE/IcD0eASWzVjvqZLxSQYSPm0dI0ehvCv0SWi8KX/mAGzd psUA== X-Gm-Message-State: AGRZ1gJvj/Lf4rogfOsj2qqgR+Fd33gn/EcU+9BLb78HTTV6+ATOtHrx RVSHjdnCwvA3fRRH2OzJvQmMLf/W X-Google-Smtp-Source: AJdET5eD3/YlFe/GP/cFhXLb9QtiXXent/kh7qAC//vLDhg8krTSaSdpKjRbY4x5P17h2VKY2ssvog== X-Received: by 2002:aca:430b:: with SMTP id q11-v6mr10590365oia.37.1543083060882; Sat, 24 Nov 2018 10:11:00 -0800 (PST) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id f127sm4968472oia.19.2018.11.24.10.10.59 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 24 Nov 2018 10:11:00 -0800 (PST) Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL To: "pgsql-admin@lists.postgresql.org" References: <964914383.8186.1543026683916@wamui-moana.atl.sa.earthlink.net> From: Ron Message-ID: <5160c16f-6b7d-5342-3c69-ca0b198a21b9@gmail.com> Date: Sat, 24 Nov 2018 12:10:58 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------3D824B5D4D5E5CBCCCD82955" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------3D824B5D4D5E5CBCCCD82955 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit By default??? On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote: > Hello, > You must be check postgres.conf file in order to see the particular port. > Sometimes postgres is running but in another port 5433, 5434, etc. > > > Obtener Outlook para Android > > ---------------------------------------------------------------------------- > *From:* Ron > *Sent:* Saturday, November 24, 2018 3:25:02 AM > *To:* pgsql-admin@lists.postgresql.org > *Subject:* Re: could not connect to server, in order to operate > pgAdmin/PostgreSQL > On 11/23/2018 08:31 PM, Anne Marie Harm wrote: >> Hello, >> >> Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I >> can only install version 9.5 (tried versions 11, 10, and 9.6 -- but >> cannot install). > > How come. (Are you running a really old distro version?) > >> When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the >> full text of the error message I receive (also, screenshot attached): >> >> could not connect to server: Connection refused (0x0000274D/10061) Is the >> server running on host "localhost" (::1) and accepting TCP/IP connections >> on port 5432? could not connect to server: Connection refused >> (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) >> and accepting TCP/IP connections on port 5432? > > Well, *is* Postgres running? You installed Pg but did you start it? > These two commands will tell you: > > pg_ctl status # when logged in as user postgres > sudo netstat -an | grep 5432 > > -- > Angular momentum makes the world go 'round. -- Angular momentum makes the world go 'round. --------------3D824B5D4D5E5CBCCCD82955 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit By default???

On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote:

Hello,

You must be check postgres.conf file in order to see the particular port.

Sometimes postgres is running but in another port 5433, 5434, etc.

Obtener Outlook para Android

From: Ron <ronljohnsonjr@gmail.com>
Sent: Saturday, November 24, 2018 3:25:02 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

On 11/23/2018 08:31 PM, Anne Marie Harm wrote:

Hello,

Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried versions 11, 10, and 9.6 -- but cannot install).

How come. (Are you running a really old distro version?)

When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the full text of the error message I receive (also, screenshot attached):

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

Well, is Postgres running? You installed Pg but did you start it? These two commands will tell you:

pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432

--

Angular momentum makes the world go 'round.

--
Angular momentum makes the world go 'round.
--------------3D824B5D4D5E5CBCCCD82955-- From amharm@earthlink.net Sat Nov 24 19:32:14 2018 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQdfC-0000qN-PC for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 19:32:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gQdf9-0003mu-TS for pgsql-admin@arkaria.postgresql.org; Sat, 24 Nov 2018 19:32:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQdf9-0003mh-6e for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 19:32:19 +0000 Received: from elasmtp-mealy.atl.sa.earthlink.net ([209.86.89.69]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gQdf6-0008Me-96 for pgsql-admin@lists.postgresql.org; Sat, 24 Nov 2018 19:32:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=earthlink.net; s=dk12062016; t=1543087936; bh=8SZGNObMbf2CKdNcHcjHiuJsBarnYp+ilzhk LzfaRg4=; h=Received:Received:Date:From:Reply-To:To:Message-ID: Subject:MIME-Version:Content-Transfer-Encoding:X-Mailer: Content-Type:X-ELNK-Trace:X-Originating-IP; b=hNCL95cKPB2Yxa2xwony IWWnSHuCgwQwxID9eMw0Kiqny+8MeNCGubJBq4/5fT6O40Ufx59oL83VPcs+Ur9LQDx JHYyFvrNcJLUxOZXOWLuVDG9V8MSxixmkNvNQuGpom2Gzlc70ZPcwnjBr5ONF++WKx4 WbPGxd9ImMSJ5A7xzWWgj4UCD+OoNDwryoL8c32C8GyPMdnhu7UOA66L3Uw3DMenH3w v2DzDecWtf67sZkc2TqzoqxvPOQE+S++jL2p8GIC2sECtxDDhns64TZzaNZZuVrcSoQ /UdN1WjNlkJzTMXAzfcQfk+vZ17iaAnLGTYEgwi0JOUwTsb6H3bOew== DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk12062016; d=earthlink.net; b=cGg1OuxyUR0QcChEnWfWhXa+bGcULOaVRM2vqYvCraj/YI6rEUDGPRvsov7EUoyaid4zT2RX/tPO9RXTefUyeYtshe9QP2qOoy9rLtiSad6EN7RzFIHw91oesY9OHt2SlMbVGIh5ANWutvEwJb0GskzA7VuFKdJYLmM91K7O7zwOGrcbEOKuhkwN1ZXye3Ztj/Gb8gN0sJ4M0Wg43U6IFi8p2KD2t2BcCBDCuFl0D5Vx/UTptOp9t63WtKu79nr3w5r9LXo8XPmbRio88t75bOGknVu0nL93yHD4uqsVxTQBDvts8+rpUE6sovC6UJc3K9xnWBgTJqb7ADpHNyPyeg==; h=Date:From:Reply-To:To:Message-ID:Subject:MIME-Version:Content-Transfer-Encoding:X-Mailer:Content-Type:X-ELNK-Trace:X-Originating-IP; Received: from [209.86.224.181] (helo=wamui-napoleon.atl.sa.earthlink.net) by elasmtp-mealy.atl.sa.earthlink.net with esmtpa (Exim 4) (envelope-from ) id 1gQdf4-0009ZW-Jo; Sat, 24 Nov 2018 14:32:14 -0500 Received: from 73.144.143.244 by webmail.earthlink.net with HTTP; Sat, 24 Nov 2018 14:32:14 -0500 Date: Sat, 24 Nov 2018 14:32:14 -0500 (GMT-05:00) From: Anne Marie Harm Reply-To: Anne Marie Harm To: Ron , "pgsql-admin@lists.postgresql.org" Message-ID: <1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net> Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: EarthLink Zoo Mail 1.0 Content-Type: text/html; charset=UTF-8 X-ELNK-Trace: 2bb16525f3d7da0d94f5150ab1c16ac07475de73c4477ed77cb33a7f6d419bd0944efa5f6dd44ba9350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 209.86.224.181 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk
Oddly eno= ugh I did not receive Ricardo= Martin Gomez's response directly -- just received it with Ron's response= .
Regarding:
=
> You must be check postgres.conf file in = order to see the particular port.
>&= nbsp;Somet= imes postgres is running but in another port 5433, 5434, etc.
<= /zzzmeta>
Where do I find that postgres. conf fi= le; where and how do I look? (I have tried plenty of searching and trying w= hat's suggested, to no avail.)

Not sure what to do with this, so I'l= l keep it in mind for future reference:

=09> By default?= ??

-----Original Message-----
From: Ron
Sent: Nov 24, 2018 1:10 PM
To: "pgsql-admin@lists.postgresql.org"
Subject: Re: could not connect to server, in order to operate pgAdmin/P= ostgreSQL

By default???

On 11/24/2018 06:16 AM, Ricardo Martin Gomez wrote:

Hello,

You must be check postgres.conf file in order to see the particular port.

Sometimes postgres is running but in another port 5433, 5434, etc.

Obtener Outlook para Android

From: Ron <ronljohnsonjr@gmail.com>
Sent: Saturday, November 24, 2018 3:25:02 AM
To: pgsql-admin@lists.postgr= esql.org
Subject: Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

On 11/23/2018 08:31 PM, Anne Marie Harm wrote:

Hello,

Unfortunately I'm unable to operate pgAdmin/PostgreSQL; first of all I can only install version 9.5 (tried versions 11, 10, and 9.6 -- but cannot install).

How come. (Are you running a really old distro version?)

When I launch pgAdmin in order to try to use PostgreSGL 9.5, here is the full text of the error message I receive (also, screenshot attached):
=

= could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

Well, is Postgres running? You installed Pg but did yo= u start it? These two commands will tell you:

pg_ctl status # when logged in as user postgres
sudo netstat -an | grep 5432

--

Angular momentum makes the world go 'round.

--
Angular momentum makes the world go 'round.

<= br>
---------------------------- Anne Marie Harm (312) 563-9397 amharm@earthlink.net https://www.linkedin.com/in/annemarieharm/

---------------------------- Anne Marie Harm (312) 563-9397 amharm@earthlink.net https://www.linkedin.com/in/annemarieharm/

---------------------------- Anne Marie Harm (312) 563-9397 amharm@earthlink.net https://www.linkedin.com/in/annemarieharm/