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 1gQpvK-0006RS-09
	for pgsql-admin@arkaria.postgresql.org; Sun, 25 Nov 2018 08:37:50 +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 1gQpvG-0000j7-VG
	for pgsql-admin@arkaria.postgresql.org; Sun, 25 Nov 2018 08:37:46 +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 <achill@matrix.gatewaynet.com>)
	id 1gQpvG-0000iz-D2
	for pgsql-admin@lists.postgresql.org; Sun, 25 Nov 2018 08:37:46 +0000
Received: from hermes.gatewaynet.com ([193.92.121.98])
	by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1gQpv6-000120-HI
	for pgsql-admin@lists.postgresql.org; Sun, 25 Nov 2018 08:37:44 +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
 wAP8bUbA025579
	for <pgsql-admin@lists.postgresql.org>; Sun, 25 Nov 2018 10:37:30 +0200
Received: from [10.9.251.9] (dcmchgw.internal.net [10.9.0.1])
	by hercules.internal.net (Postfix) with ESMTPS id E7AB31350AB5
	for <pgsql-admin@lists.postgresql.org>; Sun, 25 Nov 2018 10:37:28 +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>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <9f4234f2-da51-d174-56d3-c4229e8ad342@matrix.gatewaynet.com>
Date: Sun, 25 Nov 2018 10:37:25 +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: 
 <1882688338.3266.1543087934594@wamui-napoleon.atl.sa.earthlink.net>
Content-Type: multipart/alternative;
 boundary="------------55623F1A25B80E2B160F1364"
Content-Language: en-US
X-Virus-Scanned: clamav-milter 0.98.7 at hermes
X-Virus-Status: Clean
X-Spam-Status: No, score=-10.9 required=5.0 tests=ALL_TRUSTED,
	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.
--------------55623F1A25B80E2B160F1364
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit


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 you installed PostgreSQL. It could be in ~postgres/data , 
e.g. /var/lib/pgsql/data or /usr/local/var/pgsql/data , or just echo 
$PGDATA to find out, or do

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/
>
>

--------------55623F1A25B80E2B160F1364
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 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:
        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:
            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;
                padding: 0px; font-size: 11pt;"><font face="georgia,
                  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 you installed PostgreSQL. It could be in
      ~postgres/data , e.g. /var/lib/pgsql/data or
      /usr/local/var/pgsql/data , or just echo $PGDATA to find out, or
      do <br>
    </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:
        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,
            sans-serif; padding-left: 5px; margin-left: 0px;
            border-left: 2px solid rgb(0, 0, 255); font-weight: normal;
            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">"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;
                            margin:0; padding:0;&#xA;
                            font-family:sans-serif; font-size:11pt;
                            color:black"> Hello,<br>
                          </div>
                          <div dir="auto" style="direction:ltr;
                            margin:0; padding:0;&#xA;
                            font-family:sans-serif; font-size:11pt;
                            color:black"> You must be check
                            postgres.conf file in order to see the
                            particular port.<br>
                          </div>
                          <div dir="auto" style="direction:ltr;
                            margin:0; padding:0;&#xA;
                            font-family:sans-serif; font-size:11pt;
                            color:black"> Sometimes postgres is running
                            but in another port 5433, 5434, etc.<br>
                            <br>
                            <br>
                          </div>
                          <div dir="auto" style="direction:ltr;
                            margin:0; padding:0;&#xA;
                            font-family:sans-serif; font-size:11pt;
                            color:black">
                            <div dir="auto" style="direction:ltr;
                              margin:0; padding:0;&#xA;
                              font-family:sans-serif; font-size:11pt;
                              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;
                            width:98%">
                          <div id="divRplyFwdMsg" dir="ltr"><font
                              style="font-size:11pt" face="Calibri,
                              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;
                                color:rgb(0,0,0);&#xA;
                                font-family:georgia,serif">Hello, <br>
                                <span
                                  style="font-family:Geneva,Arial,Helvetica,sans-serif;&#xA;
                                  font-size:12px"></span><font
                                  style="font-size:12px" face="georgia,
                                  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;
                                color:rgb(0,0,0);&#xA;
                                font-family:georgia,serif"><font
                                  style="font-size:12px" face="georgia,
                                  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;
                                  font-size:12px"></span>
                                <div
                                  style="font-family:Geneva,Arial,Helvetica,sans-serif;&#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;
                                  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;
            font-family: arial, sans-serif; font-weight: normal;
            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">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></pre>
          </div>
          <br>
          <br>
          <br>
          <div id="elnk_signature_1543086140256" style="font-size: 10pt;
            font-weight: normal; font-style: normal; text-decoration:
            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">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></pre>
          </div>
          <br>
          <br>
        </div>
        <br>
        <div id="elnk_signature_1543087914914" style="font-weight:
          normal; font-style: normal; text-decoration: none; font-size:
          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">amharm@earthlink.net</a>
<a class="moz-txt-link-freetext" href="https://www.linkedin.com/in/annemarieharm/">https://www.linkedin.com/in/annemarieharm/</a></pre>
        </div>
        <br>
        <br>
      </div>
    </blockquote>
  </body>
</html>

--------------55623F1A25B80E2B160F1364--