Re: no pg_hba.conf entry for replication connection from host

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