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

Поиск
Список
Период
Сортировка
От Volkan Unsal
Тема Re: no pg_hba.conf entry for replication connection from host
Дата
Msg-id CAMcqKmkbegk3mMmPfsRkC1EeBVeNXcLVTiEEUqYZb3Ddw4Dcfg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: no pg_hba.conf entry for replication connection from host  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
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@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.klaver@aklaver.com



--
Volkan Unsal
web and mobile development

В списке pgsql-general по дате отправления:

Предыдущее
От: Volkan Unsal
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: no pg_hba.conf entry for replication connection from host