Re: no pg_hba.conf entry for replication connection from host - Mailing list pgsql-general

From Volkan Unsal
Subject Re: no pg_hba.conf entry for replication connection from host
Date
Msg-id CAMcqKmkSE3bzDQiuuT+n-=c1SjtB3x4ZBpv0uEL_yq-pdgR1NQ@mail.gmail.com
Whole thread Raw
In response to Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
That was from the standby server logs.

On Thu, Apr 9, 2015 at 5:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/09/2015 01:52 PM, Volkan Unsal wrote:
Yup, just did. Can never be too paranoid about this. :)

So where did the below come from?:

LOG:  database system was interrupted; last known up at 2015-04-09 16:35:05 GMT
LOG:  entering standby mode
LOG:  redo starts at 0/E000028
LOG:  consistent recovery state reached at 0/E0000F0


On Thu, Apr 9, 2015 at 4:51 PM, Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

    On 04/09/2015 01:48 PM, Volkan Unsal wrote:

        HI Adrian,

             Is there a chance you have a recovery.conf in your primary
        server
             directory?


        No, this file is only in the standby server. From the gist, here is
        where recovery.conf gets created
        <https://gist.github.com/__volkanunsal/__ad2173e2649393fcd3b6#file-__init-slave-sh-L32-L36
        <https://gist.github.com/volkanunsal/ad2173e2649393fcd3b6#file-init-slave-sh-L32-L36>>.


    Yes, I saw that, but have you checked the primary $PGDATA anyway?







        --
        *Volkan Unsal*
        /web and mobile development/
        volkanunsal.com <http://volkanunsal.com> <http://bit.ly/1h1ebjy>



    --
    Adrian Klaver
    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>




--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>


--
Adrian Klaver
adrian.klaver@aklaver.com



--
Volkan Unsal
web and mobile development

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host
Next
From: Adrian Klaver
Date:
Subject: Re: no pg_hba.conf entry for replication connection from host