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

[Volkan Unsal <spocksplanet@xxxxxxxxx>]

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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx

--

Volkan Unsal

web and mobile development

volkanunsal.com