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>, pgorg_aav <kahitarich-postgresorg(at)yahoo(dot)com>
Cc: Melvin Davidson <melvin6925(at)gmail(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-09 19:56:29
Message-ID: 5526D96D.8050303@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan Unsal 2015-04-09 20:00:58 Re: no pg_hba.conf entry for replication connection from host
Previous Message Adrian Klaver 2015-04-09 19:51:59 Re: no pg_hba.conf entry for replication connection from host