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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Volkan Unsal <spocksplanet(at)gmail(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:00:25
Message-ID: 5526E869.5060306@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan Unsal 2015-04-09 21:01:27 Re: no pg_hba.conf entry for replication connection from host
Previous Message Volkan Unsal 2015-04-09 20:52:49 Re: no pg_hba.conf entry for replication connection from host