Добрый день.
Пытаюсь настроить потоковую репликацию.
настраиваю мастер
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$
| Вложение | Размер |
|---|---|
| postgresql.txt | 21.72 kb |
| pg_hba.txt | 4.51 kb |