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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gQpx8-0006UO-S6
	for pgsql-admin@arkaria.postgresql.org; Sun, 25 Nov 2018 08:39:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gQpx7-0003TA-Ho
	for pgsql-admin@arkaria.postgresql.org; Sun, 25 Nov 2018 08:39:41 +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 <achill@matrix.gatewaynet.com>)
	id 1gQpx7-0003T2-8q
	for pgsql-admin@lists.postgresql.org; Sun, 25 Nov 2018 08:39:41 +0000
Received: from hermes.gatewaynet.com ([193.92.121.98])
	by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1gQpx3-0003WM-Vx
	for pgsql-admin@lists.postgresql.org; Sun, 25 Nov 2018 08:39:40 +0000
Received: from hercules.internal.net (hercules.internal.net [10.9.200.8])
	by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id
 wAP8dZu8025689
	for <pgsql-admin@lists.postgresql.org>; Sun, 25 Nov 2018 10:39:35 +0200
Received: from [10.9.251.9] (dcmchgw.internal.net [10.9.0.1])
	by hercules.internal.net (Postfix) with ESMTPS id CD1A61350AB5
	for <pgsql-admin@lists.postgresql.org>; Sun, 25 Nov 2018 10:39:33 +0200 (EET)
Subject: Re: could not connect to server, in order to operate
 pgAdmin/PostgreSQL
To: pgsql-admin@lists.postgresql.org
References: 
 <1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net>
 <9f4234f2-da51-d174-56d3-c4229e8ad342@matrix.gatewaynet.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <28682ea4-e07a-962e-bf2a-7c78c831a17d@matrix.gatewaynet.com>
Date: Sun, 25 Nov 2018 10:39:32 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
In-Reply-To: <9f4234f2-da51-d174-56d3-c4229e8ad342@matrix.gatewaynet.com>
Content-Type: multipart/alternative;
 boundary="------------965F397521A3BDE4B68AC4A2"
Content-Language: en-US
X-Virus-Scanned: clamav-milter 0.98.7 at hermes
X-Virus-Status: Clean
X-Spam-Status: No, score=-25.9 required=5.0 tests=ALL_TRUSTED,DYN_HAM_IT,
	DYN_HAM_IT_PARTNERS,HTML_MESSAGE,TW_PG autolearn=unavailable version=3.3.1
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
	hermes.gatewaynet.com
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

This is a multi-part message in MIME format.
--------------965F397521A3BDE4B68AC4A2
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit


On 25/11/18 10:37 π.μ., Achilleas Mantzios wrote:
>
>
> On 24/11/18 9:32 μ.μ., Anne Marie Harm wrote:
>> Oddly enough 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.
>>> > Sometimes postgres is running but in another port 5433, 5434, etc.
>> Where do I find that postgres. conf file; where and how do I look? (I 
>> have tried plenty of searching and trying what's suggested, to no avail.)
>
>
> It depends who
>

oops I meant how


> ps aux | egrep -e 'postgres \-D'
>
> and look at the dir after -D . Usually postgresql.conf (and 
> postgresql.auto.conf ) are in there.
>
> If you are running debian look in /etc/postgresql/<insert your pgsql 
> major version>/<your cluster name>/postgresql.conf
>
> You could find those out also by :
>
> postgres@achill-XPS-15-9550:~$ psql
> psql (10.6 (Ubuntu 10.6-0ubuntu0.18.04.1))
> Type "help" for help.
>
> postgres=# show data_directory ;
>        data_directory
> -----------------------------
>  /var/lib/postgresql/10/main
> (1 row)
>
> postgres=# show config_file ;
>                config_file
> -----------------------------------------
>  /etc/postgresql/10/main/postgresql.conf
> (1 row)
>
> postgres=#
>
>
>>
>> Not sure what to do with this, so I'll keep it in mind for future 
>> reference:
>>
>> > 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/PostgreSQL
>>
>>     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 <https://aka.ms/ghei36>
>>>
>>>     ------------------------------------------------------------------------
>>>     *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.
>>
>>
>> ----------------------------
>> 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/
>>
>>

--------------965F397521A3BDE4B68AC4A2
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 25/11/18 10:37 π.μ., Achilleas
      Mantzios wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:9f4234f2-da51-d174-56d3-c4229e8ad342@matrix.gatewaynet.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <p><br>
      </p>
      <div class="moz-cite-prefix">On 24/11/18 9:32 μ.μ., Anne Marie
        Harm wrote:<br>
      </div>
      <blockquote type="cite"
cite="mid:1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net">
        <meta http-equiv="content-type" content="text/html;
          charset=UTF-8">
        <style type="text/css"><!-- DIV {margin:0px;} --></style>
        <div style="font-size: 16px;color: rgb(0, 0,
          0);font-family:&#xA; georgia, serif;">
          <style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style>
          <style>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</style><font
            style="font-family: georgia, serif; font-size: 16px;"
            face="georgia, serif"><span style="font-size: small;">Oddly
              enough I did not receive </span><span
              style="font-size:&#xA; small;">Ricardo Martin Gomez</span></font><span
            style="font-family: georgia, serif; font-size: small;">'s
            response directly -- just received it with Ron's response.</span><br>
          <blockquote type="cite"
cite="mid:RO1P15201MB2267F8DCC9F82D673BA8818CA3D50@RO1P15201MB2267.LAMP152.PROD.OUTLOOK.COM"
            style="font-size: 13.3333px;"><zzzmeta
              http-equiv="Content-Type" content="text/html;
              charset=utf-8" style=""><zzzmeta content="text/html;
                charset=utf-8" style="">
                <div dir="auto" style="direction: ltr; margin: 0px;&#xA;
                  padding: 0px; font-size: 11pt;"><font
                    face="georgia,&#xA; serif">Regarding:</font><br>
                  <br>
                  <font face="sans-serif">&gt; You must be check
                    postgres.conf file in order to see the particular
                    port.</font><br>
                  <font face="sans-serif">&gt; </font><span
                    style="font-family: sans-serif; font-size: 11pt;">Sometimes
                    postgres is running but in another port 5433, 5434,
                    etc.</span></div>
              </zzzmeta></zzzmeta></blockquote>
          <font style="font-family: georgia, serif;" size="2"
            face="georgia, serif">Where do I find that postgres. conf
            file; where and how do I look? (I have tried plenty of
            searching and trying what's suggested, to no avail.)<br>
          </font></div>
      </blockquote>
      <p><br>
      </p>
      <p>It depends who</p>
    </blockquote>
    <br>
    <p>oops I meant how<br>
    </p>
    <p><br>
    </p>
    <blockquote type="cite"
      cite="mid:9f4234f2-da51-d174-56d3-c4229e8ad342@matrix.gatewaynet.com">
      <p> </p>
      <p>ps aux | egrep -e 'postgres \-D'</p>
      <p>and look at the dir after -D . Usually postgresql.conf (and
        postgresql.auto.conf ) are in there.</p>
      <p>If you are running debian look in /etc/postgresql/&lt;insert
        your pgsql major version&gt;/&lt;your cluster
        name&gt;/postgresql.conf</p>
      <p>You could find those out also by :</p>
      <p>postgres@achill-XPS-15-9550:~$ psql<br>
        psql (10.6 (Ubuntu 10.6-0ubuntu0.18.04.1))<br>
        Type "help" for help.<br>
        <br>
        postgres=# show data_directory ;<br>
               data_directory        <br>
        -----------------------------<br>
         /var/lib/postgresql/10/main<br>
        (1 row)<br>
        <br>
        postgres=# show config_file ;<br>
                       config_file               <br>
        -----------------------------------------<br>
         /etc/postgresql/10/main/postgresql.conf<br>
        (1 row)<br>
        <br>
        postgres=# <br>
        <br>
      </p>
      <p><br>
      </p>
      <blockquote type="cite"
cite="mid:1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net">
        <div style="font-size: 16px;color: rgb(0, 0,
          0);font-family:&#xA; georgia, serif;"><font
            style="font-family: georgia, serif;" size="2" face="georgia,
            serif"><br>
            Not sure what to do with this, so I'll keep it in mind for
            future reference:<br>
            <br>
          </font><span style="font-size: 13.3333px;"><span style="white-space:pre">	</span>&gt;
            By default???</span><font style="font-family: georgia,
            serif;" size="2" face="georgia, serif"><br>
          </font>
          <div style="font-family: georgia, serif;"><font size="2"><br>
            </font>
            <blockquote style="font-size: 10pt; font-family: arial,&#xA;
              sans-serif; padding-left: 5px; margin-left: 0px;&#xA;
              border-left: 2px solid rgb(0, 0, 255); font-weight:
              normal;&#xA; font-style: normal; text-decoration: none;
              color: black;">-----Original Message----- <br>
              From: Ron <ronljohnsonjr@gmail.com> <br>
                Sent: Nov 24, 2018 1:10 PM <br>
                To: <a class="moz-txt-link-rfc2396E"
                  href="mailto:pgsql-admin@lists.postgresql.org"
                  moz-do-not-send="true">"pgsql-admin@lists.postgresql.org"</a>
                <pgsql-admin@lists.postgresql.org> <br>
                  Subject: Re: could not connect to server, in order to
                  operate pgAdmin/PostgreSQL <br>
                  <br>
                  <zzzhtml> <zzzhead> <zzzmeta
                        http-equiv="Content-Type" content="text/html;
                        charset=utf-8"> </zzzmeta></zzzhead> <zzzbody
                      bgcolor="#FFFFFF" text="#000000"> By default???<br>
                      <br>
                      <div class="moz-cite-prefix">On 11/24/2018 06:16
                        AM, Ricardo Martin Gomez wrote:<br>
                      </div>
                      <blockquote type="cite"
cite="mid:RO1P15201MB2267F8DCC9F82D673BA8818CA3D50@RO1P15201MB2267.LAMP152.PROD.OUTLOOK.COM">
                        <zzzmeta http-equiv="Content-Type"
                          content="text/html; charset=utf-8"> <zzzmeta
                            content="text/html; charset=utf-8">
                            <div dir="auto" style="direction:ltr;&#xA;
                              margin:0; padding:0;&#xA;&#xA;
                              font-family:sans-serif;
                              font-size:11pt;&#xA; color:black"> Hello,<br>
                            </div>
                            <div dir="auto" style="direction:ltr;&#xA;
                              margin:0; padding:0;&#xA;&#xA;
                              font-family:sans-serif;
                              font-size:11pt;&#xA; color:black"> You
                              must be check postgres.conf file in order
                              to see the particular port.<br>
                            </div>
                            <div dir="auto" style="direction:ltr;&#xA;
                              margin:0; padding:0;&#xA;&#xA;
                              font-family:sans-serif;
                              font-size:11pt;&#xA; color:black">
                              Sometimes postgres is running but in
                              another port 5433, 5434, etc.<br>
                              <br>
                              <br>
                            </div>
                            <div dir="auto" style="direction:ltr;&#xA;
                              margin:0; padding:0;&#xA;&#xA;
                              font-family:sans-serif;
                              font-size:11pt;&#xA; color:black">
                              <div dir="auto" style="direction:ltr;&#xA;
                                margin:0; padding:0;&#xA;&#xA;
                                font-family:sans-serif;
                                font-size:11pt;&#xA; color:black">
                                Obtener <a target="_blank"
                                  href="https://aka.ms/ghei36"
                                  moz-do-not-send="true">Outlook para
                                  Android</a></div>
                              <br>
                            </div>
                            <hr tabindex="-1"
                              style="display:inline-block;&#xA;
                              width:98%">
                            <div id="divRplyFwdMsg" dir="ltr"><font
                                style="font-size:11pt"
                                face="Calibri,&#xA; sans-serif"
                                color="#000000"><b>From:</b> Ron <a
                                  target="_blank"
                                  class="moz-txt-link-rfc2396E"
                                  href="mailto:ronljohnsonjr@gmail.com"
                                  moz-do-not-send="true">&lt;ronljohnsonjr@gmail.com&gt;</a><br>
                                <b>Sent:</b> Saturday, November 24, 2018
                                3:25:02 AM<br>
                                <b>To:</b> <a target="_blank"
                                  class="moz-txt-link-abbreviated"
                                  href="mailto:pgsql-admin@lists.postgresql.org"
                                  moz-do-not-send="true">pgsql-admin@lists.postgresql.org</a><br>
                                <b>Subject:</b> Re: could not connect to
                                server, in order to operate
                                pgAdmin/PostgreSQL</font>
                              <div> </div>
                            </div>
                            <div>On 11/23/2018 08:31 PM, Anne Marie Harm
                              wrote:<br>
                              <blockquote type="cite">
                                <style type="text/css">
<ZZZ!--
div
	{margin:0px}
-->
</style>
                                <div style="font-size:16px;&#xA;
                                  color:rgb(0,0,0);&#xA;&#xA;
                                  font-family:georgia,serif">Hello, <br>
                                  <span
                                    style="font-family:Geneva,Arial,Helvetica,sans-serif;&#xA;&#xA;
                                    font-size:12px"></span><font
                                    style="font-size:12px"
                                    face="georgia,&#xA; serif"><span
                                      style="font-size:16px"><br>
                                      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).</span></font></div>
                              </blockquote>
                              <br>
                              How come.  (Are you running a really old
                              distro version?)<br>
                              <br>
                              <blockquote type="cite">
                                <div style="font-size:16px;&#xA;
                                  color:rgb(0,0,0);&#xA;&#xA;
                                  font-family:georgia,serif"><font
                                    style="font-size:12px"
                                    face="georgia,&#xA; serif"><span
                                      style="font-size:16px">When I
                                      launch pgAdmin in order to try to
                                      use PostgreSGL 9.5, h</span></font>ere
                                  is the full text of the error message
                                  I receive (also, screenshot attached):<span
style="font-family:Geneva,Arial,Helvetica,sans-serif;&#xA;&#xA;
                                    font-size:12px"></span>
                                  <div
                                    style="font-family:Geneva,Arial,Helvetica,sans-serif;&#xA;&#xA;
                                    font-size:12px; margin:0px"> <font
                                      face="georgia, serif"><span
                                        style="font-size:16px"><br>
                                      </span></font></div>
                                  <div
                                    style="font-family:Geneva,Arial,Helvetica,sans-serif;&#xA;&#xA;
                                    font-size:12px; margin:0px"> <font
                                      face="georgia, serif"><span
                                        style="font-size:16px">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?</span></font></div>
                                </div>
                              </blockquote>
                              <br>
                              Well, <b>is</b> Postgres running?  You
                              installed Pg but did you start it?  These
                              two commands will tell you:<br>
                              <br>
                              pg_ctl status # when logged in as user
                              postgres<br>
                              sudo netstat -an | grep 5432<br>
                              <br>
                              -- <br>
                              <div class="moz-signature">Angular
                                momentum makes the world go 'round.</div>
                            </div>
                          </zzzmeta></zzzmeta></blockquote>
                      <br>
                      <div class="moz-signature">-- <br>
                        Angular momentum makes the world go 'round.</div>
                    </zzzbody> </zzzhtml> </pgsql-admin@lists.postgresql.org></ronljohnsonjr@gmail.com></blockquote>
            <br>
            <div id="elnk_signature_1543085724639" style="font-size:
              10pt;&#xA; font-family: arial, sans-serif; font-weight:
              normal;&#xA; font-style: normal; text-decoration: none;
              color: black;">
              <pre>----------------------------
Anne Marie Harm
(312) 563-9397
<a class="moz-txt-link-abbreviated" href="mailto:amharm@earthlink.net" moz-do-not-send="true">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/" moz-do-not-send="true">https://www.linkedin.com/in/annemarieharm/</a></pre>
            </div>
            <br>
            <br>
            <br>
            <div id="elnk_signature_1543086140256" style="font-size:
              10pt;&#xA; font-weight: normal; font-style: normal;
              text-decoration:&#xA; none; font-family: arial,
              sans-serif; color: black;">
              <pre>----------------------------
Anne Marie Harm
(312) 563-9397
<a class="moz-txt-link-abbreviated" href="mailto:amharm@earthlink.net" moz-do-not-send="true">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/" moz-do-not-send="true">https://www.linkedin.com/in/annemarieharm/</a></pre>
            </div>
            <br>
            <br>
          </div>
          <br>
          <div id="elnk_signature_1543087914914"
            style="font-weight:&#xA; normal; font-style: normal;
            text-decoration: none; font-size:&#xA; 10pt; font-family:
            arial,sans-serif; color: black;">
            <pre>----------------------------
Anne Marie Harm
(312) 563-9397
<a class="moz-txt-link-abbreviated" href="mailto:amharm@earthlink.net" moz-do-not-send="true">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/" moz-do-not-send="true">https://www.linkedin.com/in/annemarieharm/</a></pre>
          </div>
          <br>
          <br>
        </div>
      </blockquote>
    </blockquote>
  </body>
</html>

--------------965F397521A3BDE4B68AC4A2--