motum hesa escribió: > Esto me muestra el log después de activar log_connections: > > 93396: [unknown]: 2017-12-21 18:01:51 UTC : [unknown]@xxx [unknown] :LOG: > connection received: host=xxx port=14768 > 93396: [unknown]: 2017-12-21 18:01:51 UTC : replicador@xxx test :LOG: > replication connection authorized: user=replicador SSL enabled > (protocol=TLSv1.2, cipher=ECDHE-RSA-AES128-GCM-SHA256, compression=off) > 93396: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :LOG: > logical decoding found consistent point at 38A/9789A0D0 > 93396: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :DETAIL: > There are no running transactions. > 93397: [unknown]: 2017-12-21 18:01:52 UTC : [unknown]@xxx [unknown] :LOG: > connection received: host=xxxx port=19955 > 93397: [unknown]: 2017-12-21 18:01:52 UTC : replicador@xxx test :LOG: > replication connection authorized: user=replicador SSL enabled > (protocol=TLSv1.2, cipher=ECDHE-RSA-AES128-GCM-SHA256, compression=off) > 93397: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :LOG: > starting logical decoding for slot "subtest" > 93397: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :DETAIL: > streaming transactions committing after 38A/9789A108, reading WAL from > 38A/9789A0D0 > 93397: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :LOG: > logical decoding found consistent point at 38A/9789A0D0 > 93397: subtest: 2017-12-21 18:01:52 UTC : replicador@xxx test :DETAIL: > There are no running transactions. > > ps ax | grep 93397 > 93397 - Rs 1:07.54 postgres: wal sender process replicador > xxxx(19955) (postgres) > > ps ax | grep 93396 > > No hay proceso con ese PID
Por alguna razón los procesos se abren y se cierran de inmediato. Eso es un bug pero falta información para poder depurarlo. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services