From: | Volkan Unsal <spocksplanet(at)gmail(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: no pg_hba.conf entry for replication connection from host |
Date: | 2015-04-10 03:43:11 |
Message-ID: | CAMcqKmnWFQ5Jjo9x5vpL7h6wJwfoDAX=WzrcgAr9d_v0tOmHhw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Melvin,
Thank you for offering to take a look. Here is a gist of all the whole set
up. I enclosed the logs in there as log-slave and lo-master.
https://gist.github.com/volkanunsal/ad2173e2649393fcd3b6
This is the entire setup, except for a few things taken out for privacy
reasons. Please note that the variables are substituted into the conf files
by a preprocessor. I've confirmed that they are substituted correctly.
On Thu, Apr 9, 2015 at 11:09 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
> I'm sorry, my telepathy seems to be failing me. Do you think it would be
> possible for you to attach a copy of your current pg_hba.conf on the
> master, as well as the specific entry in the postgresql log with the error
> about no entry in pg_hba.conf?
>
> On Thu, Apr 9, 2015 at 6:43 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 04/09/2015 03:01 PM, Volkan Unsal wrote:
>>
>>> Good point. But that didn't work either. Back to reading the source code
>>> for me...
>>>
>>>
>> Before you sent:
>>
>> My postgresql.conf file in the standby server looks like this:
>>
>> wal_level = hot_standby
>> hot_standby = on
>> max_standby_streaming_delay = 15min
>>
>> Is that your entire postgresql.conf file on the standby?
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
*Volkan Unsal*
*web and mobile development*
volkanunsal.com <http://bit.ly/1h1ebjy>
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2015-04-10 03:56:07 | Re: Background worker assistance & review |
Previous Message | Craig Ringer | 2015-04-10 03:40:01 | Re: Can a bdr enabled server belong to more than one bdr group? |