Добрый день!
Перевожу заббикс с Оракла на Постгрес. Сам перевод уже отработан, проблем с ним нет.
После перехода создаю реплику командой
pg_basebackup -P -R -X stream -c fast -h 192.168.77.90 -U replica -D . (запускаю её с реплики из PGDATA)
запускаю реплику, всё хорошо, данные передаются, но раз в 10 секунд в логах реплики появляются строки:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
2019-01-25 11:21:13 +07 [31941]: [2-1] db=zabbix,user=zabbix,app=[unknown],client=::1 LOG: connection authorized: user=zabbix database=zabbix
2019-01-25 11:21:13 +07 [31941]: [3-1] db=zabbix,user=zabbix,app=[unknown],client=::1 ERROR: cannot execute DROP INDEX in a read-only transaction
2019-01-25 11:21:13 +07 [31941]: [4-1] db=zabbix,user=zabbix,app=[unknown],client=::1 STATEMENT: drop index history_log_2
2019-01-25 11:21:13 +07 [31941]: [5-1] db=zabbix,user=zabbix,app=[unknown],client=::1 LOG: disconnection: session time: 0:00:00.016 user=zabbix database=zabbix host=::1 port=21288
2019-01-25 11:21:23 +07 [31959]: [1-1] db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received: host=::1 port=21289
2019-01-25 11:21:23 +07 [31959]: [2-1] db=zabbix,user=zabbix,app=[unknown],client=::1 LOG: connection authorized: user=zabbix database=zabbix
2019-01-25 11:21:23 +07 [31959]: [3-1] db=zabbix,user=zabbix,app=[unknown],client=::1 LOG: disconnection: session time: 0:00:00.005 user=zabbix database=zabbix host=::1 port=21289
2019-01-25 11:21:23 +07 [31960]: [1-1] db=[unknown],user=[unknown],app=[unknown],client=::1 LOG: connection received: host=::1 port=21290
2019-01-25 11:21:23 +07 [31960]: [2-1] db=zabbix,user=zabbix,app=[unknown],client=::1 LOG: connection authorized: user=zabbix database=zabbix
2019-01-25 11:21:23 +07 [31960]: [3-1] db=zabbix,user=zabbix,app=[unknown],client=::1 ERROR: cannot execute DROP INDEX in a read-only transaction
2019-01-25 11:21:23 +07 [31960]: [4-1] db=zabbix,user=zabbix,app=[unknown],client=::1 STATEMENT: drop index history_log_2
На основном сервере таких сообщений нет. Подскажите пож-ста, куда копать?
Версия постгреса 11.0
OS Oracle Linux Server release 7.5
