Re: Replicação Lógica

Olá André

Só pra constar da lista, conversamos com você pelo telegram, o problema foi
resolvido com a atualização da origem em 13.6

[]s
Flavio

Em qua., 27 de abr. de 2022 20:38, André Ormenese <aormenese(at)gmail(dot)com>
escreveu:

> 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 LOG: received replication command:
> DROP_REPLICATION_SLOT assinatura_tst_replogica WAIT
>
> E nas querys de monitoramento no *PUBLISHER *:
> [image: image.png]
> [image: image.png]
>
> e *DESCRIBER*:
> [image: image.png]
>
> Com essas informações é possível identificar o que posso fazer para sanar
> este problema ?
>
> Obrigado por qualquer ajuda !!!
>
> André
>
>
> *Minhas figuras favoritas do folclore brasileiro são a democracia e o
> estado laico.*
>