Subject: Re: Problem with replication
To: pgsql-admin@lists.postgresql.org
References: <36847976.780175.1584988236276.ref@mail.yahoo.com>
 <36847976.780175.1584988236276@mail.yahoo.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <c7ff32b3-8545-bd7c-1865-3e6dcf9057c8@jakobs.com>
Date: Mon, 23 Mar 2020 19:33:45 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.4.1
MIME-Version: 1.0
In-Reply-To: <36847976.780175.1584988236276@mail.yahoo.com>
Content-Type: multipart/alternative;
 boundary="------------EA13E74A2B9DE7A09B012543"
Content-Language: de-DE
Precedence: bulk

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

Hi Douglas,

the connection attempt has obviously been started via a "local" 
connection, using a Unix socket instead of TCP/IP. Therefore, no IP 
address is involved.

Is the slave db on the same machine?

Regards,

Holger

Am 23.03.20 um 19:30 schrieb Douglas Reed:
> Hi
>
> We are running Pg Version 9.6
>
> On OS Centos 7 running on a VM (Nutanix)
>
> We are trying to build a slave server on this platform. The relevant 
> IP entry for replication has been placed in pg_hba.conf on the master. 
> We run pg_basebackup successfully and then set up recovery.conf etc 
> and re-start
> the slave database. It seems to process the WALs and then enter the 
> read only state when it then generates the following errors;
>
> Mar 23 15:22:48 xds-data1-temp postgres[13072]: [2-1] 
> user=,db=,app=client= LOG:  database system is ready to accept read 
> only connections
> Mar 23 15:22:49 xds-data1-temp postgres[13083]: [3-1] 
> user=[unknown],db=[unknown],app=[unknown]client=[local] LOG:  
> connection received: host=[local]
> Mar 23 15:22:49 xds-data1-temp postgres[13083]: [4-1] 
> user=postgres,db=[unknown],app=[unknown]client=[local] FATAL:  no 
> pg_hba.conf entry for replication connection from host "[local]", user 
> "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-1] 
> user=,db=,app=client= FATAL:  could not connect to the primary server: 
> FATAL:  no pg_hba.conf entry for replication connection from host 
> "[local]", user "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-2]
> Mar 23 15:22:49 xds-data1-temp postgres[13085]: [3-1] 
> user=[unknown],db=[unknown],app=[unknown]client=[local] LOG:  
> connection received: host=[local]
> Mar 23 15:22:49 xds-data1-temp postgres[13085]: [4-1] 
> user=postgres,db=[unknown],app=[unknown]client=[local] FATAL:  no 
> pg_hba.conf entry for replication connection from host "[local]", user 
> "postgres", SSL off
> Mar 23 15:22:49 xds-data1-temp postgres[13084]: [3-1] 
> user=,db=,app=client= FATAL:  could not connect to the primary server: 
> FATAL:  no pg_hba.conf entry for replication connection from host 
> "[local]", user "postgres", SSL off
>
> We know that the entry is in the hba and have checked for typos, but 
> one thing that does stick out with one line on the message is;
>
>     FATAL:  no pg_hba.conf entry for replication connection from host 
> "[local]"
>
> Other messages I have seen in the past would normally have an IP 
> address where is says "[local]"
>
> Any ideas as to where we might be going wrong?
>
>
> Many thanks
>
>
>
>
>
> Doug Reed
> dougreed765@yahoo.com
> 07973-132664
> https://uk.linkedin.com/pub/douglas-reed/33/326/2b

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------EA13E74A2B9DE7A09B012543
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>
    <p>Hi Douglas,</p>
    <p>the connection attempt has obviously been started via a "local"
      connection, using a Unix socket instead of TCP/IP. Therefore, no
      IP address is involved.</p>
    <p>Is the slave db on the same machine?</p>
    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <div class="moz-cite-prefix">Am 23.03.20 um 19:30 schrieb Douglas
      Reed:<br>
    </div>
    <blockquote type="cite"
      cite="mid:36847976.780175.1584988236276@mail.yahoo.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div class="ydp82a671c2yahoo-style-wrap" style="font-family:
        Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;">
        <div>
          <div dir="ltr" data-setdir="false">
            <div>
              <div dir="ltr" data-setdir="false">Hi</div>
              <div><br>
              </div>
              <div dir="ltr" data-setdir="false">We are running Pg
                Version 9.6</div>
              <div><br>
              </div>
              <div dir="ltr" data-setdir="false">On OS Centos 7 running
                on a VM (Nutanix)</div>
              <div><br>
              </div>
              <div>We are trying to build a slave server on this
                platform. The relevant IP entry for replication has been
                placed in pg_hba.conf on the master. We run
                pg_basebackup successfully and then set up recovery.conf
                etc and re-start </div>
              <div>the slave database. It seems to process the WALs and
                then enter the read only state when it then generates
                the following errors;</div>
              <div><br>
              </div>
              <div>Mar 23 15:22:48 xds-data1-temp postgres[13072]: [2-1]
                user=,db=,app=client= LOG:  database system is ready to
                accept read only connections</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13083]: [3-1]
                user=[unknown],db=[unknown],app=[unknown]client=[local]
                LOG:  connection received: host=[local]</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13083]: [4-1]
                user=postgres,db=[unknown],app=[unknown]client=[local]
                FATAL:  no pg_hba.conf entry for replication connection
                from host "[local]", user "postgres", SSL off</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-1]
                user=,db=,app=client= FATAL:  could not connect to the
                primary server: FATAL:  no pg_hba.conf entry for
                replication connection from host "[local]", user
                "postgres", SSL off</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13082]: [3-2]</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13085]: [3-1]
                user=[unknown],db=[unknown],app=[unknown]client=[local]
                LOG:  connection received: host=[local]</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13085]: [4-1]
                user=postgres,db=[unknown],app=[unknown]client=[local]
                FATAL:  no pg_hba.conf entry for replication connection
                from host "[local]", user "postgres", SSL off</div>
              <div>Mar 23 15:22:49 xds-data1-temp postgres[13084]: [3-1]
                user=,db=,app=client= FATAL:  could not connect to the
                primary server: FATAL:  no pg_hba.conf entry for
                replication connection from host "[local]", user
                "postgres", SSL off</div>
              <div><br>
              </div>
              <div>We know that the entry is in the hba and have checked
                for typos, but one thing that does stick out with one
                line on the message is; </div>
              <div><br>
              </div>
              <div>    FATAL:  no pg_hba.conf entry for replication
                connection from host "[local]" </div>
              <div><br>
              </div>
              <div>Other messages I have seen in the past would normally
                have an IP address where is says "[local]"</div>
              <div><br>
              </div>
              <div>Any ideas as to where we might be going wrong?    </div>
              <div><br>
              </div>
              <div><br>
              </div>
              <div>Many thanks</div>
              <div><br>
              </div>
            </div>
            <br>
          </div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div class="ydp82a671c2signature">Doug Reed 
            <div><a class="moz-txt-link-abbreviated" href="mailto:dougreed765@yahoo.com">dougreed765@yahoo.com</a> </div>
            <div>07973-132664</div>
            <div><span style="color:rgb(51, 51, 51);font-family:Arial,
                sans-serif;font-size:11px;line-height:17px;background-color:rgb(246,
                246, 246);"><a class="moz-txt-link-freetext" href="https://uk.linkedin.com/pub/douglas-reed/33/326/2b">https://uk.linkedin.com/pub/douglas-reed/33/326/2b</a></span></div>
          </div>
        </div>
      </div>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------EA13E74A2B9DE7A09B012543--