Настройка Streaming Replication

Добрый день.
Пытаюсь настроить потоковую репликацию.
настраиваю мастер
postgresql.conf : listen_addresses = '*' , wal_level = replica, max_wal_senders = 5, wal_keep_segments = 32, hot_standby = on
конфиг во вложении.
pg_hba.conf -
host replication postgres 192.168.100.0/24 trust
host replication root 192.168.100.0/24 trust
конфиг во вложении.
перезагржаю службу - service postgresql-9.6 restart

В логах :

< 2017-06-30 07:19:29.028 EDT > LOG:  DATABASE system IS shut down
< 2017-06-30 07:19:30.049 EDT > LOG:  DATABASE system was shut down at 2017-06-30 07:19:29 EDT
< 2017-06-30 07:19:30.051 EDT > LOG:  MultiXact member wraparound protections are now enabled
< 2017-06-30 07:19:30.052 EDT > LOG:  DATABASE system IS ready TO accept connections
< 2017-06-30 07:19:30.052 EDT > LOG:  autovacuum launcher started

Потом пытаюсь подключиться со второго сервера

bash-4.1$  pg_basebackup -P -R -X stream -c fast -h 192.168.100.44 -U postgres -D /var/lib/pgsql/slave
could NOT CHANGE directory TO "/root": Permission denied
pg_basebackup: could NOT connect TO server: could NOT connect TO server: Connection refused
        IS the server running ON host "192.168.100.44" AND accepting
        TCP/IP connections ON port 5432?
bash-4.1$

И так же не могу подключиться через pg_admin.
Где блокируется?

ВложениеРазмер
postgresql.txt21.72 kb
pg_hba.txt4.51 kb

Back to top

(С) Виктор Вислобоков, 2008-2010