Replicação Lógica
Vitor Hugo <[email protected]>
| Newsgroups | gmane.linux.debian.user.portuguese |
|---|---|
| Message-ID | <SJ0PR18MB5054EAAF6BD44A2600A3C688AAFD9@SJ0PR18MB5054.namprd18.prod.outlook.com> |
Pessoal, nem sei se esta forma de comunicação com a comunidade ainda é válida. Só acho que o texto vai ficar longo para colocar no Telegram. Vamos lá !! Estou precisando fazer uma replicação lógica (de todo o banco) de um PostgreSQL 13.0 instalado em CentOS 8, para um 14.2 em Ubuntu Server. *Postgresql.conf do PUBLISHER e do SUBSCRIBER:* wal_level = logical max_wal_senders = 100 max_replication_slots = 100 max_logical_replication_workers = 4 max_sync_workers_per_subscription = 2 max_worker_processes = 8 O problema é que no *log *do destino ( *SUBSCRIBER* ) fica acusando erro na replicação : 2022-04-27 15:22:11 -03 [557526]: [1-1] user=postgres,db=tst_replogica,client=xxx LOG: statement: CREATE SUBSCRIPTION assinatura_tst_replogica CONNECTION 'host=host_origem port=5438 user=replogica dbname=tst_replogica connect_timeout=10 password=senha sslmode=prefer' PUBLICATION publica_tst_replogica WITH (connect = true, enabled = true, copy_data = true, create_slot = true, synchronous_commit = 'off'); 2022-04-27 15:22:11 -03 [557531]: [1-1] user=,db=,client= LOG: logical replication apply worker for subscription "assinatura_tst_replogica" has started 2022-04-27 15:22:11 -03 [557532]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:11 -03 [557532]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:11 -03 [557375]: [16-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557532) exited with exit code 1 2022-04-27 15:22:16 -03 [557534]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:17 -03 [557534]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:17 -03 [557375]: [17-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557534) exited with exit code 1 2022-04-27 15:22:21 -03 [557536]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:22 -03 [557536]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:22 -03 [557375]: [18-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557536) exited with exit code 1 2022-04-27 15:22:26 -03 [557538]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:27 -03 [557538]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:27 -03 [557375]: [19-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557538) exited with exit code 1 2022-04-27 15:22:31 -03 [557540]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:32 -03 [557540]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:32 -03 [557375]: [20-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557540) exited with exit code 1 2022-04-27 15:22:36 -03 [557541]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:37 -03 [557541]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:37 -03 [557375]: [21-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557541) exited with exit code 1 2022-04-27 15:22:41 -03 [557543]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:41 -03 [557543]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:41 -03 [557375]: [22-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557543) exited with exit code 1 2022-04-27 15:22:46 -03 [557544]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:47 -03 [557544]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:47 -03 [557375]: [23-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557544) exited with exit code 1 2022-04-27 15:22:51 -03 [557546]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:52 -03 [557546]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:52 -03 [557375]: [24-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557546) exited with exit code 1 2022-04-27 15:22:56 -03 [557547]: [1-1] user=,db=,client= LOG: logical replication table synchronization worker for subscription "assinatura_tst_replogica", table "tb1" has started 2022-04-27 15:22:57 -03 [557547]: [2-1] user=,db=,client= ERROR: error reading result of streaming command: 2022-04-27 15:22:57 -03 [557375]: [25-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557547) exited with exit code 1 2022-04-27 15:22:59 -03 [557526]: [2-1] user=postgres,db=tst_replogica,client=quebrapedra.hemo.unicamp.br <http://quebrapedra.hemo.unicamp.br> LOG: statement: DROP SUBSCRIPTION IF EXISTS assinatura_tst_replogica; 2022-04-27 15:22:59 -03 [557531]: [2-1] user=,db=,client= FATAL: terminating logical replication worker due to administrator command 2022-04-27 15:22:59 -03 [557375]: [26-1] user=,db=,client= LOG: background worker "logical replication worker" (PID 557531) exited with exit code 1 Os dados até são replicados, mas como tem um retorno de erro, o que me parece é que outra tentativa de replicação é feita indefinidamente. Estou usando um banco com apenas um schema, e uma tabela para teste. No *PUBLISHER *tenho o seguinte *log *: 2022-04-27 15:22:11.491 -03 [3913405]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: CREATE_REPLICATION_SLOT "assinatura_tst_replogica" LOGICAL pgoutput NOEXPORT_SNAPSHOT 2022-04-27 15:22:11.551 -03 [3913405]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000230 2022-04-27 15:22:11.551 -03 [3913405]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:11.580 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: IDENTIFY_SYSTEM 2022-04-27 15:22:11.580 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "assinatura_tst_replogica" LOGICAL 0/0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:11.581 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "assinatura_tst_replogica" 2022-04-27 15:22:11.581 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B2000268, reading WAL from 17/B2000230. 2022-04-27 15:22:11.581 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000230 2022-04-27 15:22:11.581 -03 [3913406]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:11.592 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: CREATE_REPLICATION_SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL pgoutput USE_SNAPSHOT 2022-04-27 15:22:11.671 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:11.671 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:11.781 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:11.781 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:11.781 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:11.781 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:11.781 -03 [3913407]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:17.800 -03 [3913413]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:17.801 -03 [3913413]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:17.801 -03 [3913413]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:17.801 -03 [3913413]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:17.801 -03 [3913413]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:22.818 -03 [3913418]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:22.818 -03 [3913418]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:22.818 -03 [3913418]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:22.819 -03 [3913418]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:22.819 -03 [3913418]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:27.837 -03 [3913420]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:27.837 -03 [3913420]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:27.837 -03 [3913420]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:27.837 -03 [3913420]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:27.837 -03 [3913420]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:32.856 -03 [3913433]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:32.856 -03 [3913433]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:32.856 -03 [3913433]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:32.856 -03 [3913433]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:32.856 -03 [3913433]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:37.873 -03 [3913435]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:37.874 -03 [3913435]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:37.874 -03 [3913435]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:37.874 -03 [3913435]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:37.874 -03 [3913435]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:41.891 -03 [3913438]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:41.891 -03 [3913438]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:41.891 -03 [3913438]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:41.891 -03 [3913438]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:41.891 -03 [3913438]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:47.909 -03 [3913439]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:47.909 -03 [3913439]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:47.909 -03 [3913439]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:47.909 -03 [3913439]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:47.909 -03 [3913439]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:52.927 -03 [3913442]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:52.927 -03 [3913442]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:52.927 -03 [3913442]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:52.928 -03 [3913442]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:52.928 -03 [3913442]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:57.946 -03 [3913444]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: START_REPLICATION SLOT "pg_862364_sync_862356_7086085394085815793" LOGICAL 17/B20002A0 (proto_version '1', publication_names '"publica_tst_replogica"') 2022-04-27 15:22:57.946 -03 [3913444]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: starting logical decoding for slot "pg_862364_sync_862356_7086085394085815793" 2022-04-27 15:22:57.946 -03 [3913444]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: Streaming transactions committing after 17/B20002A0, reading WAL from 17/B2000268. 2022-04-27 15:22:57.946 -03 [3913444]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: logical decoding found consistent point at 17/B2000268 2022-04-27 15:22:57.946 -03 [3913444]: pg_862364_sync_862356_7086085394085815793,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> DETAIL: There are no running transactions. 2022-04-27 15:22:59.309 -03 [3913445]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: DROP_REPLICATION_SLOT pg_862364_sync_862356_7086085394085815793 WAIT 2022-04-27 15:22:59.318 -03 [3913445]: assinatura_tst_replogica,user=replogica,db=tst_replogica,client=sampi.hemo.unicamp.br <http://sampi.hemo.unicamp.br> LOG: received replication command: DROP_REPLICATION_SLOT assinatura_tst_replogica WAIT E nas querys de monitoramento no *PUBLISHER *: image.png image.png e *DESCRIBER*: image.png Com essas informações é possível identificar o que posso fazer para sanar este problema ?