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

Hi Adrian,

So in your recovery.conf is standby_mode set to on?

Yes, here is that entire file:

standby_mode = 'on'
> primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432
> user=${REP_USER} password=${REP_PASS}'
> trigger_file = '/tmp/promote_db_slave'

On Thu, Apr 9, 2015 at 3:56 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 04/09/2015 12:46 PM, Volkan Unsal wrote:
>
>> Hi Amit,
>>
>> My postgresql.conf file in the standby server looks like this:
>>
>> wal_level = hot_standby
>> hot_standby = on
>> max_standby_streaming_delay = 15min
>>
>>
>> In the master server, it looks like this:
>>
>> listen_addresses = '*'
>> wal_level = hot_standby
>> max_wal_senders = 10
>> max_connections=100
>> checkpoint_segments = 8
>> wal_keep_segments = 8
>> archive_mode = on
>> archive_command = 'cp %p /var/lib/postgresql/archive/%f'
>>
>
>
> So in your recovery.conf is standby_mode set to on?
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

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