[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Replicação Lógica

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 ?
Reply to: