LINUX.ORG.RU

Надо смотреть логи на обоих нодах. Потому что ошибки на одной могут быть следствием другой.

turtle_bazon ★★★★★
()
Ответ на: комментарий от turtle_bazon

Логи на слейве лог выше, а на мастере вот

2019-01-24 15:21:15.989 UTC [52122] [unknown]@template1 LOG: manager worker [52122] at slot 0 generation 1 detaching cleanly 2019-01-24 15:21:16.136 UTC [52123] [unknown]@[unknown] LOG: incomplete startup packet 2019-01-24 15:21:16.989 UTC [52127] [unknown]@postgres LOG: manager worker [52127] at slot 0 generation 2 detaching cleanly 2019-01-24 15:21:17.992 UTC [52200] [unknown]@adp LOG: starting pglogical database manager for database adp 2019-01-24 15:22:50.108 UTC [52670] postgres@adp LOG: logical decoding found consistent point at 2D/FDC77050 2019-01-24 15:22:50.108 UTC [52670] postgres@adp DETAIL: There are no running transactions. 2019-01-24 15:22:50.108 UTC [52670] postgres@adp LOG: exported logical decoding snapshot: «00002A0D-1» with 0 transaction IDs 2019-01-24 15:22:50.125 UTC [52672] postgres@adp ERROR: replication origin «pgl_adp_prod_sensors_wh_sensor_data» does not exist 2019-01-24 15:22:50.125 UTC [52672] postgres@adp STATEMENT: SELECT pg_catalog.pg_replication_origin_session_setup('pgl_adp_prod_sensors_wh_sensor_data'); BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED; SET session_replication_role = 'replica'; SET DATESTYLE = ISO; SET INTERVALSTYLE = POSTGRES; SET extra_float_digits TO 3; SET statement_timeout = 0; SET lock_timeout = 0; 2019-01-24 15:22:50.135 UTC [52672] postgres@adp LOG: could not receive data from client: Connection reset by peer 2019-01-24 15:22:50.135 UTC [52670] postgres@adp LOG: could not receive data from client: Connection reset by peer 2019-01-24 15:22:50.135 UTC [52671] postgres@adp LOG: could not receive data from client: Connection reset by peer

wadim_
() автор топика
Ответ на: комментарий от turtle_bazon

Возможно, но не совсем понял что это означает. Попробую ковырну в эту сторону.

wadim_
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.