Re: retirar e-mail do grupo

[Jack Jr.]

https://www.debian.org/MailingLists/unsubscribe


Jack Pogorelsky Jr. (CREA-RS 136845)
*Engenheiro Mecânico*
Tel/WhatsApp: +55 51 985010082
E-mail: mecan...@sulmail.com 
Website: sulmail.com/mecanica 

Em 28/04/2022 14:08, João Maurício Machado de Araujo escreveu:


Boa tarde.

Peço ao administrador para retirar meu nome desse grupo.

Não quero mais receber e-mails.

Agradeço antecipadamente a atenção dispensada.

Enviado do Email  
para Windows

retirar e-mail do grupo

[João Maurício Machado de Araujo]

Boa tarde. Peço ao administrador para retirar meu nome desse grupo. Não quero mais receber e-mails. Agradeço antecipadamente a atenção dispensada. Enviado do Email para Windows 

Replicação Lógica

[Vitor Hugo]

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