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

From: Volkan Unsal <spocksplanet(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Melvin Davidson <melvin6925(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: no pg_hba.conf entry for replication connection from host
Date: 2015-04-09 21:01:27
Message-ID: CAMcqKmkSE3bzDQiuuT+n-=c1SjtB3x4ZBpv0uEL_yq-pdgR1NQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

That was from the standby server logs.

On Thu, Apr 9, 2015 at 5:00 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>>
>> --
>> *Volkan Unsal*
>> /web and mobile development/
>> volkanunsal.com <http://bit.ly/1h1ebjy>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-04-09 21:16:59 Re: no pg_hba.conf entry for replication connection from host
Previous Message Adrian Klaver 2015-04-09 21:00:25 Re: no pg_hba.conf entry for replication connection from host