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.kla...@aklaver.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.kla...@aklaver.com
>



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

Reply via email to